APPS.WMS_RETURN_SV dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 2096: DELETE FROM MTL_SERIAL_NUMBERS_TEMP

2092: FETCH c_interface_txn_id INTO l_interface_txn_id;
2093: EXIT WHEN c_interface_txn_id%NOTFOUND;
2094:
2095: BEGIN
2096: DELETE FROM MTL_SERIAL_NUMBERS_TEMP
2097: WHERE TRANSACTION_TEMP_ID = l_interface_txn_id;
2098:
2099: DELETE FROM MTL_TRANSACTION_LOTS_TEMP
2100: WHERE TRANSACTION_TEMP_ID = l_interface_txn_id;

Line 2390: FROM MTL_SERIAL_NUMBERS MSN, MTL_SERIAL_NUMBERS_TEMP MSNT, MTL_TRANSACTION_LOTS_TEMP MTLT

2386: l_position := '0020';
2387:
2388: open c_ref for SELECT msn.lot_number, MSN.SERIAL_NUMBER FM_SERIAL_NUMBER,
2389: MSN.SERIAL_NUMBER TO_SERIAL_NUMBER, null quantity, msn.COST_GROUP_ID
2390: FROM MTL_SERIAL_NUMBERS MSN, MTL_SERIAL_NUMBERS_TEMP MSNT, MTL_TRANSACTION_LOTS_TEMP MTLT
2391: WHERE MTLT.TRANSACTION_TEMP_ID = p_rcv_trx_interface_id
2392: AND MSNT.TRANSACTION_TEMP_ID = MTLT.SERIAL_TRANSACTION_TEMP_ID
2393: AND MSN.INVENTORY_ITEM_ID = p_item_id
2394: AND Nvl(MSN.revision,'@@@') = Nvl(p_item_revision,'@@@')

Line 2430: FROM MTL_SERIAL_NUMBERS MSN, MTL_SERIAL_NUMBERS_TEMP msnt,

2426: /* Serial Controlled */
2427: l_position := '0040';
2428: open c_ref for SELECT NULL LOT_NUMBER, MSN.SERIAL_NUMBER FM_SERIAL_NUMBER,
2429: MSN.SERIAL_NUMBER TO_SERIAL_NUMBER, null quantity, msn.COST_GROUP_ID
2430: FROM MTL_SERIAL_NUMBERS MSN, MTL_SERIAL_NUMBERS_TEMP msnt,
2431: wms_lpn_contents wlpnc
2432: WHERE MSNT.TRANSACTION_TEMP_ID = p_rcv_trx_interface_id
2433: AND MSN.INVENTORY_ITEM_ID = p_item_id
2434: AND Nvl(MSN.revision,'@@@') = Nvl(p_item_revision,'@@@')

Line 2660: FROM MTL_SERIAL_NUMBERS MSN, MTL_SERIAL_NUMBERS_TEMP MSNT, MTL_TRANSACTION_LOTS_TEMP MTLT

2656: IF p_lot_controlled = 2 AND p_serial_controlled in (2,5) THEN
2657: l_position := '0020';
2658: open c_ref for SELECT mtlt.lot_number, MSN.SERIAL_NUMBER FM_SERIAL_NUMBER,
2659: MSN.SERIAL_NUMBER TO_SERIAL_NUMBER, null quantity
2660: FROM MTL_SERIAL_NUMBERS MSN, MTL_SERIAL_NUMBERS_TEMP MSNT, MTL_TRANSACTION_LOTS_TEMP MTLT
2661: WHERE MTLT.TRANSACTION_TEMP_ID = p_rcv_trx_interface_id
2662: AND MSNT.TRANSACTION_TEMP_ID = MTLT.SERIAL_TRANSACTION_TEMP_ID
2663: AND MSN.INVENTORY_ITEM_ID = p_item_id
2664: AND Nvl(MSN.revision,'@@@') = Nvl(p_item_revision,'@@@')

Line 2684: FROM MTL_SERIAL_NUMBERS MSN, MTL_SERIAL_NUMBERS_TEMP MSNT

2680: ELSIF p_lot_controlled <> 2 AND p_serial_controlled in (2,5) THEN
2681: l_position := '0040';
2682: open c_ref for SELECT NULL LOT_NUMBER, MSN.SERIAL_NUMBER FM_SERIAL_NUMBER,
2683: MSN.SERIAL_NUMBER TO_SERIAL_NUMBER, null quantity
2684: FROM MTL_SERIAL_NUMBERS MSN, MTL_SERIAL_NUMBERS_TEMP MSNT
2685: WHERE MSNT.TRANSACTION_TEMP_ID = p_rcv_trx_interface_id
2686: AND MSN.INVENTORY_ITEM_ID = p_item_id
2687: AND Nvl(MSN.revision,'@@@') = Nvl(p_item_revision,'@@@')
2688: AND MSN.SERIAL_NUMBER >= MSNT.FM_SERIAL_NUMBER