APPS.INV_TXN_MANAGER_PUB dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 2314: UPDATE mtl_transaction_lots_temp

2310: AND NVL(TRANSACTION_STATUS,TS_DEFAULT) <> TS_SAVE_ONLY /* 2STEP */
2311: AND TRANSACTION_HEADER_ID = l_header_id
2312: AND transaction_source_type_id <> 5;
2313:
2314: UPDATE mtl_transaction_lots_temp
2315: SET PRIMARY_QUANTITY = ROUND(PRIMARY_QUANTITY,5),
2316: TRANSACTION_QUANTITY = ROUND(TRANSACTION_QUANTITY,5)
2317: WHERE transaction_temp_id
2318: IN ( SELECT transaction_temp_id

Line 2334: UPDATE mtl_transaction_lots_temp

2330: AND NVL(TRANSACTION_STATUS,TS_DEFAULT) <> TS_SAVE_ONLY /* 2STEP */
2331: AND TRANSACTION_HEADER_ID = l_header_id
2332: AND transaction_source_type_id = 5;
2333:
2334: UPDATE mtl_transaction_lots_temp
2335: SET PRIMARY_QUANTITY = ROUND(PRIMARY_QUANTITY,6),
2336: TRANSACTION_QUANTITY = ROUND(TRANSACTION_QUANTITY,6)
2337: WHERE transaction_temp_id
2338: IN( SELECT transaction_temp_id

Line 4724: from mtl_transaction_lots_temp mtlt

4720:
4721: delete from mtl_serial_numbers_temp
4722: where transaction_temp_id in (
4723: select mtlt.serial_transaction_temp_id
4724: from mtl_transaction_lots_temp mtlt
4725: where mtlt.transaction_temp_id in (
4726: select mmtt.transaction_temp_id
4727: from mtl_material_transactions_temp mmtt
4728: where mmtt.transaction_header_id = l_header_id));

Line 4730: DELETE from mtl_transaction_lots_temp

4726: select mmtt.transaction_temp_id
4727: from mtl_material_transactions_temp mmtt
4728: where mmtt.transaction_header_id = l_header_id));
4729:
4730: DELETE from mtl_transaction_lots_temp
4731: where transaction_temp_id in
4732: (select mmtt.transaction_temp_id
4733: from MTL_MATERIAL_TRANSACTIONS_TEMP mmtt
4734: WHERE mmtt.TRANSACTION_HEADER_ID = l_header_id );

Line 5223: , mtl_transaction_lots_temp b

5219: , a.transaction_source_name
5220: , a.transaction_date
5221: , a.content_lpn_id
5222: FROM mtl_system_items c
5223: , mtl_transaction_lots_temp b
5224: , mtl_material_transactions_temp a
5225: WHERE a.transaction_header_id = p_line_rec_type.transaction_header_id
5226: AND a.transaction_temp_id =
5227: p_line_rec_type.transaction_interface_id

Line 5823: , mtl_transaction_lots_temp b

5819: , a.shippable_flag
5820: , b.transaction_temp_id --lot record identifier in MTLT
5821: , a.relieve_high_level_rsv_flag /*** {{ R12 Enhanced reservations code changes ***/
5822: FROM mtl_system_items c
5823: , mtl_transaction_lots_temp b
5824: , mtl_material_transactions_temp a
5825: WHERE a.transaction_header_id = p_header_id
5826: AND a.transaction_temp_id = p_transaction_temp_id
5827: AND a.organization_id = c.organization_id