PO Receiving Tables in Oracle Fusion

PO Receiving Tables in Oracle Fusion

Hi Friends, we are going to discuss about the PO receiving tables in Oracle Fusion. When we receive the material against the purchase order , we do call this process 'PO Receiving'. PO receiving tables helps to store the complete details about the PO receipts. For Example, PO receiving tables stores , which supplier send this material, against which purchase order, which items we received , how many quantities we received etc. When we do the receiving in Oracle Fusion , System automatically generates the PO receipt number. In Oracle Fusion, PO receiving tables are little bit changed as compared to the Oracle Apps r12. Some tables are quite similar but some tables are totally changed in Oracle Fusion. In this post, We will share the complete list of tables which helps to stores the complete end to end details for PO receiving in Oracle Fusion.

PO Receiving Tables in Oracle Fusion

9 Important Tables of PO Receiving in Oracle Fusion

1. RCV_SHIPMENT_HEADERS

2. RCV_SHIPMENT_LINES

3.RCV_TRANSACTIONS

4.CMR_TRANSACTIONS

5.CMR_TRANSACTION_TAXES

6.CMR_RCV_EVENTS

7.CMR_RCV_EVENT_COSTS

8.CMR_RCV_TRANSACTIONS

9.CMR_RCV_DISTRIBUTIONS

PO Receiving Tables Description

RCV_SHIPMENT_HEADERS :- This Table helps to store the PO Receiving Headers details in Oracle Fusion

RCV_SHIPMENT_LINES :- This Table helps to store the PO Receiving Line Details in Oracle Fusion.

RCV_TRANSACTIONS:- This Table helps to store the PO receiving line level details for different event type like Receive , Inspection & Deliver etc.

CMR_TRANSACTIONS: This splits the receipt into po distribution level and is used as the driving table for receipt accounting

CMR_TRANSACTION_TAXES :- cmr_transaction_taxes contains taxes returned by tax api per CMR_Transactions row (each transaction can contain many taxes)

CMR_RCV_EVENTS:- This contains the accounting event, like RECEIVING_INSPECTION, DELIVERY_TO_EXPENSE etc.... this is also the header level data shown in review receipt accounting distributions UI

CMR_RCV_EVENT_COSTS:- Child of cmr_rcv_events. Each event can have many costs, like PO Price, Taxes, Transfer Price etc... this table contains all costs for a particular event.

CMR_RCV_TRANSACTIONS:- This Table store the PO receiving line level details for different event type like Receive , Inspection & Deliver etc.

CMR_RCV_DISTRIBUTIONS:- This table store the PO Receiving accounting level data for each PO receiving line.

Important SQL Queries about PO Receiving Tables in Oracle Fusion

Here below are some of the important sql queries about PO & Receiving Joins & Tables Data.

select * from cmr_purchase_order_dtls where po_number in ();

select * from cmr_rcv_transactions where po_line_location_id in (select po_line_location_id from cmr_purchase_order_dtls where po_number in ());

select * from cmr_transactions where cmr_po_distribution_id in (select cmr_po_distribution_id from cmr_purchase_order_dtls where po_number in ());
select * from fusion.cmr_transaction_taxes where transaction_id in (select transaction_id from cmr_transactions where cmr_po_distribution_id in (select cmr_po_distribution_id from cmr_purchase_order_dtls where po_number in ()));
select * from cmr_rcv_events where cmr_po_distribution_id in (select cmr_po_distribution_id from cmr_purchase_order_dtls where po_number in ());
select * from fusion.cmr_rcv_event_costs where accounting_event_id in (select accounting_event_id from cmr_rcv_events where cmr_po_distribution_id in (select cmr_po_distribution_id from cmr_purchase_order_dtls where po_number in ()));
select * from cmr_rcv_distributions where accounting_event_id in (select accounting_event_id from cmr_rcv_events where cmr_po_distribution_id in (select cmr_po_distribution_id from cmr_purchase_order_dtls where po_number in ()));
select * from cmr_exp_po_dist_costs where cmr_po_distribution_id in (select cmr_po_distribution_id from cmr_purchase_order_dtls where po_number in ());
select * from cmr_ap_invoice_dtls where cmr_po_distribution_id in (select cmr_po_distribution_id from cmr_purchase_order_dtls where po_number in ());

PO Receiving Tables in Oracle Fusion