APPS.WMS_WIP_INTEGRATION dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 433: -- in the mtl_transaction_lots_temp table

429: END LOOP;
430: CLOSE wip_lpn_comp_serials_csr2;
431:
432: -- Logic for finding which rows will be inserted
433: -- in the mtl_transaction_lots_temp table
434:
435: IF (l_debug = 1) THEN
436: mydebug('Backflush: Insert into mtl_transaction_lots_temp ');
437: END IF;

Line 436: mydebug('Backflush: Insert into mtl_transaction_lots_temp ');

432: -- Logic for finding which rows will be inserted
433: -- in the mtl_transaction_lots_temp table
434:
435: IF (l_debug = 1) THEN
436: mydebug('Backflush: Insert into mtl_transaction_lots_temp ');
437: END IF;
438:
439: INSERT INTO mtl_transaction_lots_temp
440: ( transaction_temp_id,

Line 439: INSERT INTO mtl_transaction_lots_temp

435: IF (l_debug = 1) THEN
436: mydebug('Backflush: Insert into mtl_transaction_lots_temp ');
437: END IF;
438:
439: INSERT INTO mtl_transaction_lots_temp
440: ( transaction_temp_id,
441: last_update_date,
442: last_updated_by,
443: creation_date,

Line 663: UPDATE mtl_transaction_lots_temp

659: INTO l_next_ser_tran_temp_id
660: FROM dual;
661:
662: --Update MTLT line
663: UPDATE mtl_transaction_lots_temp
664: SET serial_transaction_temp_id = l_next_ser_tran_temp_id
665: WHERE lot_number = l_lot_number
666: AND lot_number is not null;
667:

Line 1248: UPDATE mtl_transaction_lots_temp

1244: AND lot_number = p_lot;
1245:
1246:
1247:
1248: UPDATE mtl_transaction_lots_temp
1249: SET C_ATTRIBUTE1 = c1,
1250: C_ATTRIBUTE2 = c2,
1251: C_ATTRIBUTE3 = c3,
1252: C_ATTRIBUTE4 = c4,

Line 2593: mtl_transaction_lots_temp mtlt

2589: CURSOR mtlt_csr IS
2590: SELECT mtlt.lot_number, mtlt.primary_quantity
2591: FROM
2592: mtl_material_transactions_temp mmtt,
2593: mtl_transaction_lots_temp mtlt
2594: WHERE mmtt.transaction_temp_id = p_temp_id
2595: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id;
2596:
2597: l_lot_control_code NUMBER;