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.WMS_PUTAWAY_UTILS dependencies on MTL_SERIAL_NUMBERS

Line 106: TYPE ser_num_tab IS TABLE OF mtl_serial_numbers.serial_number%TYPE

102: TYPE line_tab IS TABLE OF WIP_LINES.LINE_CODE%TYPE INDEX BY BINARY_INTEGER;
103: TYPE dept_tab IS TABLE OF BOM_DEPARTMENTS.DEPARTMENT_CODE%TYPE INDEX BY BINARY_INTEGER;
104: TYPE schedule_tab IS TABLE OF WIP_ENTITIES.WIP_ENTITY_NAME%TYPE INDEX BY BINARY_INTEGER;
105:
106: TYPE ser_num_tab IS TABLE OF mtl_serial_numbers.serial_number%TYPE
107: INDEX BY BINARY_INTEGER;
108: TYPE ser_mark_tab IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
109:
110: TYPE mol_in_rec IS RECORD(

Line 8640: FROM mtl_serial_numbers

8636:
8637: BEGIN
8638: SELECT serial_number
8639: bulk collect INTO l_serial_numbers
8640: FROM mtl_serial_numbers
8641: WHERE lpn_id = p_from_lpn_id
8642: AND inventory_item_id = l_wlpnc_rec.inventory_item_id
8643: AND Nvl(lot_number, '@@@') = Nvl(l_wlpnc_rec.lot_number, '@@@')
8644: AND Nvl(revision, '@@@') = Nvl(l_wlpnc_rec.revision,'@@@');

Line 8648: debug('Error retrieving entries from MTL_SERIAL_NUMBERS',

8644: AND Nvl(revision, '@@@') = Nvl(l_wlpnc_rec.revision,'@@@');
8645: EXCEPTION
8646: WHEN OTHERS THEN
8647: IF (l_debug = 1) THEN
8648: debug('Error retrieving entries from MTL_SERIAL_NUMBERS',
8649: 'transfer_contents', 9);
8650: END IF;
8651: RAISE fnd_api.g_exc_error;
8652: END;

Line 9079: FROM mtl_serial_numbers

9075:
9076: BEGIN
9077: SELECT serial_number
9078: bulk collect INTO l_serial_numbers
9079: FROM mtl_serial_numbers
9080: WHERE lpn_id = p_from_lpn_id
9081: AND inventory_item_id = l_wlpnc_rec.inventory_item_id
9082: AND Nvl(lot_number, '@@@') = Nvl(l_wlpnc_rec.lot_number, '@@@')
9083: AND Nvl(revision, '@@@') = Nvl(l_wlpnc_rec.revision,'@@@');

Line 9087: debug('Error retrieving entries from MTL_SERIAL_NUMBERS',

9083: AND Nvl(revision, '@@@') = Nvl(l_wlpnc_rec.revision,'@@@');
9084: EXCEPTION
9085: WHEN OTHERS THEN
9086: IF (l_debug = 1) THEN
9087: debug('Error retrieving entries from MTL_SERIAL_NUMBERS',
9088: 'transfer_contents', 9);
9089: END IF;
9090: RAISE fnd_api.g_exc_error;
9091: END;

Line 9426: FROM mtl_serial_numbers_interface msni

9422: SELECT msn.serial_number
9423: , 'N'
9424: , msn.inspection_status
9425: , msn.lot_number
9426: FROM mtl_serial_numbers_interface msni
9427: , mtl_serial_numbers msn
9428: , rcv_serials_supply rss
9429: WHERE msni.transaction_interface_id = p_msni_txn_interface_id
9430: AND msn.serial_number BETWEEN msni.fm_serial_number AND Nvl(msni.to_serial_number, msni.fm_serial_number)

Line 9427: , mtl_serial_numbers msn

9423: , 'N'
9424: , msn.inspection_status
9425: , msn.lot_number
9426: FROM mtl_serial_numbers_interface msni
9427: , mtl_serial_numbers msn
9428: , rcv_serials_supply rss
9429: WHERE msni.transaction_interface_id = p_msni_txn_interface_id
9430: AND msn.serial_number BETWEEN msni.fm_serial_number AND Nvl(msni.to_serial_number, msni.fm_serial_number)
9431: AND Length(msn.serial_number) = Length(msni.fm_serial_number)

Line 9445: FROM mtl_serial_numbers

9441: CURSOR msnt_ser_csr(v_lpn_id NUMBER
9442: , v_item_id NUMBER) IS
9443: SELECT serial_number
9444: , 'N'
9445: FROM mtl_serial_numbers
9446: WHERE inventory_item_id = v_item_id
9447: AND lpn_id = v_lpn_id
9448: AND (
9449: (p_revision IS NOT NULL and revision = p_revision)

Line 9495: l_cur_ser_number mtl_serial_numbers.serial_number%TYPE;

9491: l_lot_number mtl_lot_numbers.lot_number%type; --p_lot for complete_putaway
9492: l_mmtt_prm_qty NUMBER; --Lot quantity in primary uom
9493: l_lot_expiration_date DATE; --Lot expiration date
9494: l_lot_status_id NUMBER; --Lot Status
9495: l_cur_ser_number mtl_serial_numbers.serial_number%TYPE;
9496: l_mmtt_temp_id NUMBER; --Variable to store p_temp_id of complete_putaway
9497: l_mmtt_temp_id_tbl num_tab; --Transaction_Temp_ids for the current group
9498: l_mmtt_item_id_tbl num_tab; --Item ID for the current group
9499: l_mmtt_rev_tbl rev_tab; --Revision for the current group

Line 9862: FROM mtl_serial_numbers

9858: --code is dynamic at SO issue
9859: IF (l_serial_control_code = 6) THEN
9860: SELECT count(1)
9861: INTO l_lpn_serials_cnt
9862: FROM mtl_serial_numbers
9863: WHERE lpn_id = p_lpn_id
9864: AND inventory_item_id = p_item_id;
9865: END IF;
9866: IF ((l_serial_control_code IN (2, 5)) OR

Line 9906: FROM mtl_serial_numbers_interface msni, mtl_serial_numbers msn

9902: --R12: Find out the serials entered by the user in the UI,
9903: --grouping by their inspection_status and lot_number
9904: SELECT count(1), Nvl(msn.inspection_status,-1), Nvl(msn.lot_number,'&*_')
9905: bulk collect INTO l_msni_qty_tbl, l_msni_inspect_status_tbl, l_msni_lot_tbl
9906: FROM mtl_serial_numbers_interface msni, mtl_serial_numbers msn
9907: WHERE msni.transaction_interface_id = p_msni_txn_interface_id
9908: AND msn.serial_number BETWEEN msni.fm_serial_number AND Nvl(msni.to_serial_number,msni.fm_serial_number)
9909: AND Length(msn.serial_number) = Length(msni.fm_serial_number)
9910: GROUP BY msn.inspection_status, msn.lot_number;

Line 10300: DELETE FROM mtl_serial_numbers_interface

10296: OPEN rcv_serials_csr;
10297: FETCH rcv_serials_csr
10298: BULK COLLECT INTO l_ser_num_tbl, l_ser_mark_tbl,l_ser_inspect_status_tbl,l_ser_lot_num_tbl;
10299:
10300: DELETE FROM mtl_serial_numbers_interface
10301: WHERE transaction_interface_id = p_msni_txn_interface_id;
10302:
10303: IF (l_debug = 1) THEN
10304: debug('Number of MSNI deleted: '||SQL%rowcount,l_proc_name,9);