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