Oracle EBS: Tracking po Entire process

1. Create a PO

Po_headers_all

Select po_header_id from po_headers_all where segment1 =;

SELECT * from po_headers_all where po_header_id =;

Po_lines_all

SELECT * from po_lines_all where po_header_id =;

Po_line_locations_all

SELECT * from po_line_locations_all where po_header_id =;

Po_distributions_all
SELECT * from po_distributions_all where po_header_id =;

Po_releases_all

Select * from po_releases_all Where po_header_id =;


2. Once the PO is received, the receipt data will be transferred to the Receiving and inventory table

Rcv_shipment_headers

SELECT *
From Rcv_accounting_events
WHERE rcv_transaction_id in (SELECT transaction_id
From Rcv_transactions
WHERE po_header_id =);

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_h eader_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 on (select transaction_id from Mtl_material_transactions wher e transaction_source_id =);

Stage 3:invoicing Details

3. Accounting entry Details

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. General Ledger ledger accounts


Prompt 17. Gl_bc_packets. This was 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 =))

Oracle EBS: Tracking po Entire process