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

Line 296: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Inserting into mtl_serial_numbers_interface total of '||l_fm_serial_num_tbl.COUNT||' records');

292: AND wdd.delivery_detail_id = wsn.delivery_detail_id;
293:
294: -- insert into mtl serial number interface.
295: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
296: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Inserting into mtl_serial_numbers_interface total of '||l_fm_serial_num_tbl.COUNT||' records');
297: END IF;
298: FORALL j in 1 ..l_fm_serial_num_tbl.COUNT
299: INSERT INTO mtl_serial_numbers_interface
300: (transaction_interface_id, source_code,

Line 299: INSERT INTO mtl_serial_numbers_interface

295: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
296: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Inserting into mtl_serial_numbers_interface total of '||l_fm_serial_num_tbl.COUNT||' records');
297: END IF;
298: FORALL j in 1 ..l_fm_serial_num_tbl.COUNT
299: INSERT INTO mtl_serial_numbers_interface
300: (transaction_interface_id, source_code,
301: source_line_id, last_update_date, last_updated_by,
302: creation_date, created_by, last_update_login,
303: fm_serial_number,

Line 1705: FROM mtl_serial_numbers

1701: l_limit CONSTANT NUMBER := 1000;
1702:
1703: CURSOR db_sn IS
1704: SELECT serial_number
1705: FROM mtl_serial_numbers
1706: WHERE inventory_item_id = p_inv_item_id
1707: AND current_organization_id = p_current_org_id
1708: AND current_status = 3 -- resides in stores.
1709: AND current_subinventory_code = nvl(p_subinventory,current_subinventory_code)

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,