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 524: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP

520:
521: ELSE -- lpn_discrepancy = 1
522: -- LPN discrepancy transaction so the LPN column to
523: -- insert into is CONTENT_LPN_ID
524: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP
525: (
526: TRANSACTION_HEADER_ID,
527: TRANSACTION_TEMP_ID,
528: INVENTORY_ITEM_ID,