APPS.WMS_WIP_INTEGRATION dependencies on MTL_SERIAL_NUMBERS

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,

Line 1493: From mtl_serial_numbers

1489: AND header_id = p_header_id;
1490:
1491: select gen_object_id
1492: into l_object_id
1493: From mtl_serial_numbers
1494: where serial_number = p_serial_number
1495: and inventory_item_id = l_item_id;
1496:
1497: if( l_object_id is null ) then

Line 1501: UPDATE mtl_serial_numbers

1497: if( l_object_id is null ) then
1498: select mtl_gen_object_id_s.nextval into l_object_id from dual;
1499: end if;
1500:
1501: UPDATE mtl_serial_numbers
1502: SET
1503: LAST_UPDATE_DATE=d1,
1504: LAST_UPDATED_BY=n1,
1505: CREATION_DATE=d2,

Line 2033: UPDATE mtl_serial_numbers

2029: IF (l_debug = 1) THEN
2030: mydebug('post_completion: serial_number: ' || l_current_serial_number);
2031: END IF;
2032:
2033: UPDATE mtl_serial_numbers
2034: SET
2035: group_mark_id = NULL,
2036: current_status = 5
2037: WHERE current_organization_id = p_org_id