How are Receiving Transaction Tied to Inventory Transactions?
Note:100298.1
Problem Description
-------------------
How the MTL_MATERIAL_TRANSACTIONS table tie to the RCV_TRANSACTIONS table?
Solution Description
--------------------
If the RECEIVING transaction information is known, then do the following:
1. Get the transaction_id from rcv_transactions where the receiving
transaction_type is CORRECT, DELIVER or RETURN TO RECEIVING.
2. The transaction_id in rcv_transactions will be the
rcv_transaction_id in mtl_material_transactions.
RCV_TRANSACTIONS.TRANSACTION_ID=MTL_MATERIAL_TRANSACTIONS.RCV_TRANSACTION_ID
If the INVENTORY transaction information is known, then do the following:
1. Get the transaction_id and the rcv_transaction_id from
mtl_material_transactions.
2. The rcv_transaction_id.mtl_material_transactions will equal the
transaction_id in rcv_transactions.
(rcv_transaction_id.mtl_material_transactions ???)
The Technical Reference Manual for the RCV_TRANSACTIONS table reads that
the inv_transaction_id ties to mtl_material_transactions.
This is true, but only applies to Internal Order Issue transactions.
There is little documentation on the links between the tables.