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 1235: UPDATE mtl_transaction_lots_temp

1231: AND lot_number = p_lot;
1232:
1233:
1234:
1235: UPDATE mtl_transaction_lots_temp
1236: SET C_ATTRIBUTE1 = c1,
1237: C_ATTRIBUTE2 = c2,
1238: C_ATTRIBUTE3 = c3,
1239: C_ATTRIBUTE4 = c4,

Line 2563: mtl_transaction_lots_temp mtlt

2559: CURSOR mtlt_csr IS
2560: SELECT mtlt.lot_number, mtlt.primary_quantity
2561: FROM
2562: mtl_material_transactions_temp mmtt,
2563: mtl_transaction_lots_temp mtlt
2564: WHERE mmtt.transaction_temp_id = p_temp_id
2565: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id;
2566:
2567: l_lot_control_code NUMBER;