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_PICKING_PKG dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 387: FROM mtl_serial_numbers_temp msnt

383: -- Start Bug 4434111
384: CURSOR c_get_serials(p_transaction_temp_id NUMBER) IS
385: SELECT msnt.fm_serial_number,
386: msnt.to_serial_number
387: FROM mtl_serial_numbers_temp msnt
388: WHERE msnt.transaction_temp_id = p_transaction_temp_id;
389: --
390: l_serial_alloc_flag mtl_material_transactions_temp.serial_allocated_flag%TYPE := 'N';
391: l_user_id NUMBER;

Line 397: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt

393: l_to_serial_number VARCHAR2(30);
394: --
395: CURSOR c_get_serialLots(p_transaction_temp_id NUMBER) IS
396: SELECT msnt.fm_serial_number, msnt.to_serial_number
397: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt
398: WHERE msnt.transaction_temp_id = mtlt.serial_transaction_temp_id
399: AND mtlt.transaction_temp_id = p_transaction_temp_id;
400: -- End Bug 4434111
401: BEGIN

Line 650: FROM mtl_serial_numbers_temp msnt

646: BEGIN
647: IF l_lot_control_code = 1 THEN -- not lot controlled
648: SELECT msnt.transaction_temp_id
649: INTO l_serial_temp_id
650: FROM mtl_serial_numbers_temp msnt
651: WHERE msnt.transaction_temp_id = l_transaction_temp_id
652: AND ROWNUM < 2;
653: ELSE -- lot controlled
654: --Bug 9473783 Modified the where clause

Line 657: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt, mtl_material_transactions_temp mmtt

653: ELSE -- lot controlled
654: --Bug 9473783 Modified the where clause
655: SELECT msnt.transaction_temp_id
656: INTO l_serial_temp_id
657: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt, mtl_material_transactions_temp mmtt
658: WHERE ((msnt.transaction_temp_id = NVL(mtlt.serial_transaction_temp_id, -1)
659: AND mtlt.transaction_temp_id = l_transaction_temp_id)
660: OR (msnt.transaction_temp_id = l_transaction_temp_id
661: AND mmtt.transaction_temp_id = l_transaction_temp_id AND mmtt.lot_number IS NOT NULL ))

Line 715: DELETE FROM mtl_serial_numbers_temp

711: --}
712: END LOOP;
713: CLOSE c_get_serials;
714: --
715: DELETE FROM mtl_serial_numbers_temp
716: WHERE transaction_temp_id = l_transaction_temp_id;
717: --
718: IF (l_debug = 1) THEN
719: mydebug('Rows deleted ' || sql%rowcount, l_api_name);

Line 757: DELETE FROM mtl_serial_numbers_temp

753: --}
754: END LOOP;
755: CLOSE c_get_serialLots;
756: --
757: DELETE FROM mtl_serial_numbers_temp
758: WHERE transaction_temp_id IN
759: (
760: SELECT serial_transaction_temp_id
761: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt

Line 761: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt

757: DELETE FROM mtl_serial_numbers_temp
758: WHERE transaction_temp_id IN
759: (
760: SELECT serial_transaction_temp_id
761: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt
762: WHERE msnt.transaction_temp_id = mtlt.serial_transaction_temp_id
763: AND mtlt.transaction_temp_id = l_transaction_temp_id
764: );
765: --

Line 849: from mtl_serial_numbers_temp

845: SET group_mark_id = l_new_serial_temp_id
846: WHERE current_organization_id = l_org_id
847: AND inventory_item_id = l_inventory_item_id
848: AND serial_number in (select fm_serial_number
849: from mtl_serial_numbers_temp
850: where transaction_temp_id = l_serial_temp_id);
851: UPDATE mtl_serial_numbers_temp
852: SET transaction_temp_id = l_new_serial_temp_id
853: WHERE transaction_temp_id = l_serial_temp_id;

Line 851: UPDATE mtl_serial_numbers_temp

847: AND inventory_item_id = l_inventory_item_id
848: AND serial_number in (select fm_serial_number
849: from mtl_serial_numbers_temp
850: where transaction_temp_id = l_serial_temp_id);
851: UPDATE mtl_serial_numbers_temp
852: SET transaction_temp_id = l_new_serial_temp_id
853: WHERE transaction_temp_id = l_serial_temp_id;
854:
855: end loop;

Line 2032: FROM mtl_transaction_lots_temp mtlt, mtl_serial_numbers_temp msnt

2028: l_txn_temp_id NUMBER;
2029:
2030: CURSOR c_serial_list(p_txn_temp_id IN NUMBER, p_lot_num IN VARCHAR2) IS
2031: SELECT msnt.fm_serial_number
2032: FROM mtl_transaction_lots_temp mtlt, mtl_serial_numbers_temp msnt
2033: WHERE p_lot_num IS NOT NULL
2034: AND mtlt.transaction_temp_id = p_txn_temp_id
2035: AND mtlt.lot_number = p_lot_num
2036: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id

Line 2039: FROM mtl_serial_numbers_temp msnt

2035: AND mtlt.lot_number = p_lot_num
2036: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id
2037: UNION ALL
2038: SELECT msnt.fm_serial_number
2039: FROM mtl_serial_numbers_temp msnt
2040: WHERE p_lot_num IS NULL
2041: AND msnt.transaction_temp_id = p_txn_temp_id
2042: ORDER BY 1;
2043: BEGIN

Line 2129: FROM mtl_serial_numbers_temp msnt

2125: CURSOR c_fm_to_serial_number IS
2126: SELECT
2127: msnt.fm_serial_number,
2128: msnt.to_serial_number
2129: FROM mtl_serial_numbers_temp msnt
2130: WHERE msnt.transaction_temp_id = p_transaction_temp_id;
2131:
2132: CURSOR c_fm_to_lot_serial_number IS
2133: SELECT

Line 2137: mtl_serial_numbers_temp msnt,

2133: SELECT
2134: msnt.fm_serial_number,
2135: msnt.to_serial_number
2136: FROM
2137: mtl_serial_numbers_temp msnt,
2138: mtl_transaction_lots_temp mtlt
2139: WHERE mtlt.transaction_temp_id = p_transaction_temp_id
2140: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id;
2141:

Line 2145: l_fm_serial_number MTL_SERIAL_NUMBERS_TEMP.FM_SERIAL_NUMBER%TYPE;

2141:
2142: l_item_id NUMBER := NULL;
2143: l_serial_ctrl_code NUMBER;
2144: l_lot_ctrl_code NUMBER ;
2145: l_fm_serial_number MTL_SERIAL_NUMBERS_TEMP.FM_SERIAL_NUMBER%TYPE;
2146: l_to_serial_number MTL_SERIAL_NUMBERS_TEMP.TO_SERIAL_NUMBER%TYPE;
2147: l_txn_hdr_id NUMBER;
2148: /*6009436 End */
2149:

Line 2146: l_to_serial_number MTL_SERIAL_NUMBERS_TEMP.TO_SERIAL_NUMBER%TYPE;

2142: l_item_id NUMBER := NULL;
2143: l_serial_ctrl_code NUMBER;
2144: l_lot_ctrl_code NUMBER ;
2145: l_fm_serial_number MTL_SERIAL_NUMBERS_TEMP.FM_SERIAL_NUMBER%TYPE;
2146: l_to_serial_number MTL_SERIAL_NUMBERS_TEMP.TO_SERIAL_NUMBER%TYPE;
2147: l_txn_hdr_id NUMBER;
2148: /*6009436 End */
2149:
2150: BEGIN

Line 2386: UPDATE mtl_serial_numbers_temp

2382: l_to_serial_number;
2383: END LOOP;
2384: CLOSE c_fm_to_lot_serial_number;
2385:
2386: UPDATE mtl_serial_numbers_temp
2387: SET group_header_id= l_txn_hdr_id
2388: WHERE transaction_temp_id in ( SELECT serial_transaction_temp_id
2389: FROM mtl_transaction_lots_temp
2390: WHERE transaction_temp_id= p_transaction_temp_id );

Line 2408: UPDATE mtl_serial_numbers_temp

2404: l_to_serial_number;
2405: END LOOP;
2406: CLOSE c_fm_to_serial_number;
2407:
2408: UPDATE mtl_serial_numbers_temp
2409: SET group_header_id= l_txn_hdr_id
2410: WHERE transaction_temp_id=p_transaction_temp_id ;
2411:
2412: END IF;

Line 4231: FROM mtl_serial_numbers_temp

4227: MAX(status_id)
4228: INTO x_resultant_task_details(l_index).from_serial_number ,
4229: x_resultant_task_details(l_index).to_serial_number ,
4230: x_resultant_task_details(l_index).serial_status_id
4231: FROM mtl_serial_numbers_temp
4232: WHERE transaction_temp_id = l_mtlt_row.serial_transaction_temp_id;
4233: END IF;
4234: END LOOP;
4235: CLOSE mtlt_changed;

Line 4250: FROM mtl_serial_numbers_temp

4246: INTO x_resultant_task_details(l_index).from_serial_number ,
4247: x_resultant_task_details(l_index).to_serial_number ,
4248: x_resultant_task_details(l_index).serial_status_id ,
4249: x_resultant_task_details(l_index).number_of_serials
4250: FROM mtl_serial_numbers_temp
4251: WHERE transaction_temp_id = new_task_table(i).transaction_temp_id;
4252: END LOOP;
4253: END IF;
4254: IF g_debug = 1 THEN

Line 4528: FROM mtl_serial_numbers_temp

4524: BEGIN
4525: --serial quantity
4526: SELECT sum(1)
4527: INTO l_msnt_transaction_qty
4528: FROM mtl_serial_numbers_temp
4529: WHERE transaction_temp_id IN
4530: (SELECT serial_transaction_temp_id
4531: FROM mtl_transaction_lots_temp
4532: WHERE transaction_temp_id = p_transaction_temp_id

Line 4579: FROM mtl_serial_numbers_temp

4575: END IF;
4576: --Serial quantity
4577: SELECT sum(1)
4578: INTO l_msnt_transaction_qty
4579: FROM mtl_serial_numbers_temp
4580: WHERE transaction_temp_id = p_transaction_temp_id;
4581: IF l_msnt_transaction_qty <> l_mmtt_transaction_quantity THEN
4582: x_return_status := 'E';
4583: IF g_debug = 1 THEN

Line 5377: FROM mtl_serial_numbers_temp msnt

5373: CURSOR C_MSNT
5374: IS
5375: SELECT rowid,
5376: msnt.*
5377: FROM mtl_serial_numbers_temp msnt
5378: WHERE transaction_temp_id = p_orig_transaction_temp_id
5379: ORDER BY fm_serial_number;
5380:
5381: l_transaction_remaining_qty NUMBER;

Line 5394: UPDATE mtl_serial_numbers_temp

5390: END IF;
5391: FOR msnt IN C_MSNT
5392: LOOP
5393: l_transaction_remaining_qty := l_transaction_remaining_qty - 1;
5394: UPDATE mtl_serial_numbers_temp
5395: SET transaction_temp_id = p_new_transaction_temp_id ,
5396: last_updated_by = FND_GLOBAL.USER_ID
5397: WHERE rowid = msnt.rowid;
5398: UPDATE mtl_serial_numbers msn