eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSD_INTERNAL_ORDERS_PVT dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 2350: FROM mtl_serial_numbers_temp

2346:
2347: SELECT fm_serial_number, to_serial_number
2348: BULK COLLECT INTO
2349: l_fm_serial_number, l_to_serial_number
2350: FROM mtl_serial_numbers_temp
2351: WHERE transaction_temp_id = l_mmtt_temp_id;
2352:
2353: -- unmark the serials.
2354: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN

Line 2377: DELETE FROM mtl_serial_numbers_temp WHERE transaction_temp_id = l_mmtt_temp_id;

2373: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
2374: fnd_log.string(G_LEVEL_PROCEDURE, lc_api_name,'Deleting from MSNT for transaction_temp_id='||l_mmtt_temp_id);
2375: END IF;
2376:
2377: DELETE FROM mtl_serial_numbers_temp WHERE transaction_temp_id = l_mmtt_temp_id;
2378:
2379: -- mark the newly passed serials. And insert them into MSNT.
2380: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
2381: fnd_log.string(G_LEVEL_PROCEDURE, lc_api_name,'Marking the newly entered serial ranges');

Line 2406: INSERT INTO mtl_serial_numbers_temp

2402: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
2403: fnd_log.string(G_LEVEL_PROCEDURE, lc_api_name,'Inserting into msnt='||l_mmtt_temp_id);
2404: END IF;
2405:
2406: INSERT INTO mtl_serial_numbers_temp
2407: (transaction_temp_id,
2408: last_update_date,
2409: last_updated_by,
2410: creation_date,