APPS.WMS_WIP_INTEGRATION dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 253: -- in the mtl_serial_numbers_temp table

249: mydebug('Backflush: after insert into MMTT' || l_temp_header_id || ' ' || l_temp_source_id);
250: END IF;
251:
252: -- Logic for finding which rows will be inserted
253: -- in the mtl_serial_numbers_temp table
254:
255: IF (l_debug = 1) THEN
256: mydebug('Backflush: insert into mtl_serial_numbers_temp' );
257: END IF;

Line 256: mydebug('Backflush: insert into mtl_serial_numbers_temp' );

252: -- Logic for finding which rows will be inserted
253: -- in the mtl_serial_numbers_temp table
254:
255: IF (l_debug = 1) THEN
256: mydebug('Backflush: insert into mtl_serial_numbers_temp' );
257: END IF;
258:
259: INSERT INTO mtl_serial_numbers_temp
260: ( transaction_temp_id,

Line 259: INSERT INTO mtl_serial_numbers_temp

255: IF (l_debug = 1) THEN
256: mydebug('Backflush: insert into mtl_serial_numbers_temp' );
257: END IF;
258:
259: INSERT INTO mtl_serial_numbers_temp
260: ( transaction_temp_id,
261: last_update_date,
262: last_updated_by,
263: creation_date,

Line 669: INSERT INTO mtl_serial_numbers_temp

665: WHERE lot_number = l_lot_number
666: AND lot_number is not null;
667:
668: --Insert into MSNT table
669: INSERT INTO mtl_serial_numbers_temp
670: ( transaction_temp_id,
671: last_update_date,
672: last_updated_by,
673: creation_date,

Line 907: INSERT INTO mtl_serial_numbers_temp

903: ELSE
904: l_serial_temp_id := p_temp_id;
905: END IF;
906:
907: INSERT INTO mtl_serial_numbers_temp
908: ( transaction_temp_id,
909: last_update_date,
910: last_updated_by,
911: creation_date,