How are Receiving Transaction Tied to Inventory Transactions?

最新推荐文章于 2025-07-16 06:49:03 发布

转载最新推荐文章于 2025-07-16 06:49:03 发布 · 1.1k 阅读

文章标签：

#transactions #documentation #reference #table

ORACLE ERP 专栏收录该内容

98 篇文章

订阅专栏

本文解释了如何在Oracle E-Business Suite中将接收交易与库存交易相连接。通过使用特定的交易ID，可以从接收交易表RCV_TRANSACTIONS追溯到库存交易表MTL_MATERIAL_TRANSACTIONS。反之亦然，如果已知库存交易信息，则可以找到对应的接收交易ID。

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.