Oracle Po Tables

Stage 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 =;

Stage 2.Receive the PO

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_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

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

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 =))

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s