OPM: ic_tran_cmp_vw1 mapping for PO receipts

ic_tran_cmp_vw1 is a view inside Oracle Process Manufacturing, through it, you are able to see all completed transactions no matter what their source is, next is the mapping to link PORC transactions in that view with Oracle Purchasing Tables.

-----------------------------------------------------------
IC_TRAN_CMP_VW1.ITEM_ID = IC_ITEM_MST.ITEM_ID

Note that this item_id is not same as Item_id in PO and INV and OM instead link it using ic_item_mst.item_no = mtl_system_items.segment1,
-----------------------------------------------------------
IC_TRAN_CMP_VW1.LINE_ID = RCV_TRANSACTIONS.TRANSACTION_ID (where TRANSACTION_TYPE is equal to 'DELIVER')

also

IC_TRAN_CMP_VW1.LINE_ID = RCV_LOT_TRANSACTIONS.TRANSACTION_ID

Note LINE_ID could be repeated several times depending on how many lot+sublote the item was received
------------------------------------------------------------
IC_TRAN_CMP_VW1.doc_type='PORC' Purchasing source

IC_TRAN_CMP_VW1.TRANS_QTY > 0 To avoid negative transactions generate through the correction transaction in Oracle Purchasing.
------------------------------------------------------------
C_TRAN_CMP_VW1.DOC_ID = SHIPMENT_HEADER_ID on any PO table
same thing as LINE_ID
-------------------------------------------------------------

the end.