APPS.INV_TXN_MANAGER_GRP dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 8922: mtl_transactions_interface mti, mtl_material_transactions_temp mmtt

8918: AND (
8919: EXISTS
8920: (
8921: select 1 FROM mtl_serial_numbers msn, mtl_serial_numbers_interface msni,
8922: mtl_transactions_interface mti, mtl_material_transactions_temp mmtt
8923: WHERE msn.serial_number BETWEEN msni.fm_serial_number AND msni.to_serial_number
8924: AND Length(msn.serial_number) = Length(msni.fm_serial_number)
8925: AND msn.current_organization_id = mti.organization_id
8926: AND msn.inventory_item_id = mti.inventory_item_id

Line 8940: mtl_material_transactions_temp mmtt

8936: (
8937: select msn.serial_number, msn.group_mark_id,mti.transaction_interface_id
8938: FROM mtl_serial_numbers msn, mtl_serial_numbers_interface msni,
8939: mtl_transactions_interface mti,mtl_transaction_lots_interface mtli,
8940: mtl_material_transactions_temp mmtt
8941: WHERE msn.serial_number BETWEEN msni.fm_serial_number AND msni.to_serial_number
8942: AND Length(msn.serial_number) = Length(msni.fm_serial_number)
8943: AND msn.current_organization_id = mti.organization_id
8944: AND msn.inventory_item_id = mti.inventory_item_id

Line 9134: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP (

9130: /*OSFM Support for Serialized Lot Items*/
9131:
9132: IF ( l_lt_flow_schedule = 0) THEN
9133:
9134: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP (
9135: TRANSACTION_HEADER_ID,
9136: TRANSACTION_TEMP_ID,
9137: SOURCE_CODE,
9138: SOURCE_LINE_ID,

Line 9478: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP (

9474: );
9475:
9476: ELSE
9477: IF ( l_lt_flow_schedule <> 0 ) THEN
9478: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP (
9479: TRANSACTION_HEADER_ID,
9480: TRANSACTION_TEMP_ID,
9481: SOURCE_CODE,
9482: SOURCE_LINE_ID,

Line 9837: INSERT INTO mtl_material_transactions_temp

9833: --MMTT
9834: --In case for I, use the current statement.
9835:
9836: IF (wip_constants.DMF_PATCHSET_LEVEL>= wip_constants.DMF_PATCHSET_J_VALUE) THEN
9837: INSERT INTO mtl_material_transactions_temp
9838: (
9839: TRANSACTION_HEADER_ID,
9840: TRANSACTION_TEMP_ID,
9841: SOURCE_CODE,

Line 10173: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP (

10169: and MTI.TRANSACTION_ACTION_ID IN (1, 27, 33, 34) ;
10170:
10171: ELSE
10172:
10173: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP (
10174: TRANSACTION_HEADER_ID,
10175: TRANSACTION_TEMP_ID,
10176: SOURCE_CODE,
10177: SOURCE_LINE_ID,

Line 10491: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT

10487: mti.RELIEVE_RESERVATIONS_FLAG, /*** {{ R12 Enhanced reservations code changes ***/
10488: mti.RELIEVE_HIGH_LEVEL_RSV_FLAG, /*** {{ R12 Enhanced reservations code changes ***/
10489: mti.TRANSFER_PRICE -- INVCONV umoogala For Process-Discrete Transfer Enh.
10490: FROM MTL_TRANSACTIONS_INTERFACE MTI,
10491: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
10492: WHERE MTI.TRANSACTION_HEADER_ID = p_header_id
10493: /* WHERE MTI.ROWID = p_rowid J-dev*/
10494: and MTI.PROCESS_FLAG = 1
10495: and MTI.TRANSACTION_ACTION_ID IN (1, 27, 33, 34)

Line 12184: INSERT INTO mtl_material_transactions_temp

12180: THEN
12181: mydebug ('breadcrumb 30','tmpinsert2');
12182: END IF;
12183:
12184: INSERT INTO mtl_material_transactions_temp
12185: (transaction_header_id
12186: , transaction_temp_id
12187: , source_code
12188: , source_line_id