DBA Data[Home] [Help]

APPS.MTL_CC_TRANSACT_PKG dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 236: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP

232: -- Bug# 2872044
233: -- TM orders by the txn batch ID instead of txn temp ID as of
234: -- patchset I so store the value of the txn temp ID in the batch
235: -- ID column to maintain the order in which MMTT records are processed
236: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP
237: (
238: TRANSACTION_HEADER_ID,
239: TRANSACTION_TEMP_ID,
240: INVENTORY_ITEM_ID,

Line 330: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP

326: -- Bug# 2872044
327: -- TM orders by the txn batch ID instead of txn temp ID as of
328: -- patchset I so store the value of the txn temp ID in the batch
329: -- ID column to maintain the order in which MMTT records are processed
330: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP
331: (
332: TRANSACTION_HEADER_ID,
333: TRANSACTION_TEMP_ID,
334: INVENTORY_ITEM_ID,

Line 635: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP

631:
632: ELSE -- lpn_discrepancy = 1
633: -- LPN discrepancy transaction so the LPN column to
634: -- insert into is CONTENT_LPN_ID
635: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP
636: (
637: TRANSACTION_HEADER_ID,
638: TRANSACTION_TEMP_ID,
639: INVENTORY_ITEM_ID,