DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_GRP dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 8565: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP (

8561: /*OSFM Support for Serialized Lot Items*/
8562:
8563: IF ( l_lt_flow_schedule = 0) THEN
8564:
8565: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP (
8566: TRANSACTION_HEADER_ID,
8567: TRANSACTION_TEMP_ID,
8568: SOURCE_CODE,
8569: SOURCE_LINE_ID,

Line 8907: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP (

8903: );
8904:
8905: ELSE
8906: IF ( l_lt_flow_schedule <> 0 ) THEN
8907: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP (
8908: TRANSACTION_HEADER_ID,
8909: TRANSACTION_TEMP_ID,
8910: SOURCE_CODE,
8911: SOURCE_LINE_ID,

Line 9266: INSERT INTO mtl_material_transactions_temp

9262: --MMTT
9263: --In case for I, use the current statement.
9264:
9265: IF (wip_constants.DMF_PATCHSET_LEVEL>= wip_constants.DMF_PATCHSET_J_VALUE) THEN
9266: INSERT INTO mtl_material_transactions_temp
9267: (
9268: TRANSACTION_HEADER_ID,
9269: TRANSACTION_TEMP_ID,
9270: SOURCE_CODE,

Line 9602: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP (

9598: and MTI.TRANSACTION_ACTION_ID IN (1, 27, 33, 34) ;
9599:
9600: ELSE
9601:
9602: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP (
9603: TRANSACTION_HEADER_ID,
9604: TRANSACTION_TEMP_ID,
9605: SOURCE_CODE,
9606: SOURCE_LINE_ID,

Line 9920: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT

9916: mti.RELIEVE_RESERVATIONS_FLAG, /*** {{ R12 Enhanced reservations code changes ***/
9917: mti.RELIEVE_HIGH_LEVEL_RSV_FLAG, /*** {{ R12 Enhanced reservations code changes ***/
9918: mti.TRANSFER_PRICE -- INVCONV umoogala For Process-Discrete Transfer Enh.
9919: FROM MTL_TRANSACTIONS_INTERFACE MTI,
9920: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
9921: WHERE MTI.TRANSACTION_HEADER_ID = p_header_id
9922: /* WHERE MTI.ROWID = p_rowid J-dev*/
9923: and MTI.PROCESS_FLAG = 1
9924: and MTI.TRANSACTION_ACTION_ID IN (1, 27, 33, 34)

Line 11613: INSERT INTO mtl_material_transactions_temp

11609: THEN
11610: mydebug ('breadcrumb 30','tmpinsert2');
11611: END IF;
11612:
11613: INSERT INTO mtl_material_transactions_temp
11614: (transaction_header_id
11615: , transaction_temp_id
11616: , source_code
11617: , source_line_id