ORACLE MASTERMINDS

Doyen System Pvt. Ltd.

Showing posts with label AP. Show all posts
Showing posts with label AP. Show all posts
Wednesday, 2 January 2019

Script to extract Expenses SLA Details

›
SELECT aerh.invoice_num "Report_Number", papf.full_name "Employee_Name",        papf.employee_number "Emp_Number...
1 comment:

AP Web Report Workflow Status

›
SELECT 'WPAY' TYPE, gl.segment1 division, gl.segment3 dcc,            gl.segment4 ccc, h.report_submitted_date creation_date,    ...
2 comments:

Script to extract Goods Received Date for Suppliers along with Invoice and PO Information

›
select (select hou.name from apps.hr_operating_units hou where organization_id = (select org_id from apps.ap_invoices_all apa where apa.ve...
1 comment:
Monday, 8 January 2018

Vendor Ledger Report Query

›
SELECT flag,   vendor_num,   vendor_name,   vendor_site_id,   vendor_site_code,   state_code,   project_code,   transaction_...
1 comment:
Sunday, 7 January 2018

Query for Supplier details with banks

›
SELECT                          aps.vendor_name|| ' ~ '|| ass.vendor_site_code "Payee_Identifier"                 ,a...
2 comments:
›
Home
View web version

Contributors

  • Anand Kumar Palanisamy
  • Anand Rajendran
  • Beena Thomas
  • BlazeDream
  • Dhiraj
  • DoyenTeam
  • K Nikethan Reddy
  • Mohan G
  • Prathap Nagarajan
  • Prem Shanker Singh
  • SIVACHANDARAN
  • Tapas Kumar Sathua
  • Unknown
  • Unknown
  • Unknown
  • Unknown
  • Unknown
  • Vimal
  • gopikakuru
Powered by Blogger.