Procure to Pay Data Flow

Procure to Pay Tables and Data Flow

--Vendors
SELECT * FROM ap_vendors_v WHERE vendor_name = 'XXX_VENDOR';
select * from po_vendors where vendor_name = 'XXX_VENDOR';

--Requisitions
select segment1, type_lookup_code,a.* from po_requisition_headers_all a where requisition_header_id = xxxxxx;
select * from po_requisition_lines_all where requisition_header_id = xxxx and requisition_line_id = xxxxxx;
select * from po_req_distributions_all where requisition_line_id = xxxxxxx; 
select * from po_document_types where document_subtype = 'PURCHASE';--(po_requisition_headers_all .type_lookup_code)
select * from po_lookup_codes where lookup_type = 'AUTHORIZATION STATUS';

--PO Headers
select * from po_distributions_all where req_distribution_id = po_req_distributions_all.distribution_id
select * from po_lines_all where po_line_id = xxxxx;
select * From po_headers_all where po_header_id = xxxxx;
select * from po_line_locations_all where po_header_id = xxxxx;

--Receiving
select * from rcv_transactions where po_header_id = 147163 and po_distribution_id = xxxxx;
select * from rcv_shipment_headers where shipment_header_id = rcv_transaction.shipment_header_id;
select * from rcv_shipment_lines where where shipment_header_id = rcv_transaction.shipment_header_id;
select * from rcv_serial_transactions where transaction_id = rcv.transactions.transaction_id;
--Receiving transaction Processor import 

--AP Invoices and Payments
select * from ap_invoice_distributions_all where po_distribution_id = xxxx;
select * from ap_invoices_all where invoice_id = xxxxxx;
select * from ap_terms where term_id = xxxxx;
select * from ap_invoice_payments_all where invoice_id = xxxxx;
select * from ap_payment_schedules_all where invoice_id = xxxxxx;
select * from ap_payment_distributions_all where invoice_payment_id in (select invoice_payment_id from ap_invoice_payments_all where invoice_id = xxxxxx);
select * from ap_checks_all where check_id = xxxxx;

--Accounting Entries
select * from ap_ae_lines_all where source_table = 'AP_INVOICES' and source_id = xxxxx; -- (ap_invoices_all.invoice_id)
select * from ap_ae_headers_all where ae_header_id = xxxxxx;

--Reconciling Bank Accounts in Cash Management Module
select * from ce_statement_headers_all where statement_header_id =xxxxx
select * from ce_statement_lines where statement_header_id in (select statement_header_id from ce_statement_headers_all where statement_header_id =xxxxx)

--Concurrent Program "Payables Transfer to General Ledger"
select * from gl_interface;

--Import Journal
select * from gl_je_batches;
select * from gl_je_headers;
select * from gl_je_lines;

--Post Journals "Posting"select * from gl_balances;

--Requisition Screen Header
select * from PO_REQUISITION_HEADERS_INQ_V where requisition_num = 'xxxxxx';
select * from PO_REQUISITION_LINES_INQ_V where requisition_header_id = xxxxxx;
select * from PO_REQUISITION_HEADERS_V where requisition_number = 'xxxxx';
select * from PO_REQUISITION_LINES_V where requisition_header_id = xxxxxx;
select * from PO_REQ_DISTRIBUTIONS_V where requisition_line_id in (select requisition_line_id from PO_REQUISITION_LINES_V where requisition_header_id = xxxxx);