oracle_ebs_po到ap,Oracle EBS:追踪PO全过程

RCV_SHIPMENT_LINES

select * from rcv_shipment_lines where po_header_id =;

RCV_TRANSACTIONS

select * from rcv_transactions where po_header_id =;

RCV_ACCOUNTING_EVENTS

Select * FROM rcv_Accounting_Events Where rcv_transaction_id IN

(select transaction_id from rcv_transactions

where po_header_id =);

RCV_RECEIVING_SUB_LEDGER

select * from rcv_receiving_sub_ledger where rcv_transaction_id in (select transaction_id from rcv_transactions where po_header_id =);

RCV_SUB_LEDGER_DETAILS

select * from rcv_sub_ledger_details

where rcv_transaction_id in (select transaction_id from rcv_transactions where po_header_id =);

MTL_MATERIAL_TRANSACTIONS

select * from mtl_material_transactions where transaction_source_id =;

MTL_TRANSACTION_ACCOUNTS

select * from mtl_transaction_accounts where transaction_id in ( select transaction_id from mtl_material_transactions where transaction_source_id = =);

Stage 3: Invoicing details

3.会计分录明细

AP_INVOICE_DISTRIBUTIONS_ALL

select * from ap_invoice_distributions_all where po_distribution_id in ( select po_distribution_id from po_distributions_all where po_header_id =);

AP_INVOICES_ALL

select * from ap_invoices_all where invoice_id in

(select invoice_id from ap_invoice_distributions_all where po_distribution_id in

( select po_distribution_id from po_distributions_all where po_header_id =));

Stage 4 : Many Time there is tie up with Project related PO

PA_EXPENDITURE_ITEMS_ALL

select * from pa_expenditure_items_all peia where peia.orig_transaction_reference in

( select to_char(transaction_id) from mtl_material_transactions

where transaction_source_id = );

Stage 5 : General Ledger

5.总账分类账目

Prompt 17. GL_BC_PACKETS ..This is for encumbrances

Select * FROM gl_bc_packets Where reference2 IN ('');

GL_INTERFACE

Select *

FROM GL_INTERFACE GLI

Where user_je_source_name ='Purchasing'

AND gl_sl_link_table ='RSL'

AND reference21='PO'

AND EXISTS

( Select 1

FROM rcv_receiving_sub_ledger RRSL

Where GLI.reference22 =RRSL.reference2

AND GLI.reference23 =RRSL.reference3

AND GLI.reference24 =RRSL.reference4

AND RRSL.rcv_transaction_id in

(select transaction_id from rcv_transactions

where po_header_id ));

GL_IMPORT_REFERENCES

Select *

FROM gl_import_references GLIR

Where reference_1='PO'

AND gl_sl_link_table ='RSL'

AND EXISTS

( Select 1

FROM rcv_receiving_sub_ledger RRSL

Where GLIR.reference_2 =RRSL.reference2

AND GLIR.reference_3 =RRSL.reference3

AND GLIR.reference_4 =RRSL.reference4

AND RRSL.rcv_transaction_id in

(select transaction_id from rcv_transactions

where po_header_id =))