APPS.WMS_RETURN_SV dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 2115: DELETE FROM MTL_SERIAL_NUMBERS_TEMP

2111: FETCH c_interface_txn_id INTO l_interface_txn_id;
2112: EXIT WHEN c_interface_txn_id%NOTFOUND;
2113:
2114: BEGIN
2115: DELETE FROM MTL_SERIAL_NUMBERS_TEMP
2116: WHERE TRANSACTION_TEMP_ID = l_interface_txn_id;
2117:
2118: DELETE FROM MTL_TRANSACTION_LOTS_TEMP
2119: WHERE TRANSACTION_TEMP_ID = l_interface_txn_id;

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

2439: l_position := '0020';
2440:
2441: open c_ref for SELECT msn.lot_number, MSN.SERIAL_NUMBER FM_SERIAL_NUMBER,
2442: MSN.SERIAL_NUMBER TO_SERIAL_NUMBER, null quantity, msn.COST_GROUP_ID, null sec_qty--13399743
2443: FROM MTL_SERIAL_NUMBERS MSN, MTL_SERIAL_NUMBERS_TEMP MSNT, MTL_TRANSACTION_LOTS_TEMP MTLT
2444: WHERE MTLT.TRANSACTION_TEMP_ID = p_rcv_trx_interface_id
2445: AND MSNT.TRANSACTION_TEMP_ID = MTLT.SERIAL_TRANSACTION_TEMP_ID
2446: AND MSN.INVENTORY_ITEM_ID = p_item_id
2447: AND Nvl(MSN.revision,'@@@') = Nvl(p_item_revision,'@@@')

Line 2509: FROM MTL_SERIAL_NUMBERS MSN, MTL_SERIAL_NUMBERS_TEMP msnt,

2505: /* Serial Controlled */
2506: l_position := '0040';
2507: open c_ref for SELECT NULL LOT_NUMBER, MSN.SERIAL_NUMBER FM_SERIAL_NUMBER,
2508: MSN.SERIAL_NUMBER TO_SERIAL_NUMBER, null quantity, msn.COST_GROUP_ID, null sec_qty --13399743
2509: FROM MTL_SERIAL_NUMBERS MSN, MTL_SERIAL_NUMBERS_TEMP msnt,
2510: wms_lpn_contents wlpnc
2511: WHERE MSNT.TRANSACTION_TEMP_ID = p_rcv_trx_interface_id
2512: AND MSN.INVENTORY_ITEM_ID = p_item_id
2513: AND Nvl(MSN.revision,'@@@') = Nvl(p_item_revision,'@@@')

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

3568: IF p_lot_controlled = 2 AND p_serial_controlled in (2,5) THEN
3569: l_position := '0020';
3570: open c_ref for SELECT mtlt.lot_number, MSN.SERIAL_NUMBER FM_SERIAL_NUMBER,
3571: MSN.SERIAL_NUMBER TO_SERIAL_NUMBER, null quantity
3572: FROM MTL_SERIAL_NUMBERS MSN, MTL_SERIAL_NUMBERS_TEMP MSNT, MTL_TRANSACTION_LOTS_TEMP MTLT
3573: WHERE MTLT.TRANSACTION_TEMP_ID = p_rcv_trx_interface_id
3574: AND MSNT.TRANSACTION_TEMP_ID = MTLT.SERIAL_TRANSACTION_TEMP_ID
3575: AND MSN.INVENTORY_ITEM_ID = p_item_id
3576: AND Nvl(MSN.revision,'@@@') = Nvl(p_item_revision,'@@@')

Line 3596: FROM MTL_SERIAL_NUMBERS MSN, MTL_SERIAL_NUMBERS_TEMP MSNT

3592: ELSIF p_lot_controlled <> 2 AND p_serial_controlled in (2,5) THEN
3593: l_position := '0040';
3594: open c_ref for SELECT NULL LOT_NUMBER, MSN.SERIAL_NUMBER FM_SERIAL_NUMBER,
3595: MSN.SERIAL_NUMBER TO_SERIAL_NUMBER, null quantity
3596: FROM MTL_SERIAL_NUMBERS MSN, MTL_SERIAL_NUMBERS_TEMP MSNT
3597: WHERE MSNT.TRANSACTION_TEMP_ID = p_rcv_trx_interface_id
3598: AND MSN.INVENTORY_ITEM_ID = p_item_id
3599: AND Nvl(MSN.revision,'@@@') = Nvl(p_item_revision,'@@@')
3600: AND MSN.SERIAL_NUMBER >= MSNT.FM_SERIAL_NUMBER