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_RETURN_SV dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 80: FROM mtl_transaction_lots_temp mtlt

76: , rt.transaction_type
77: , rt.parent_transaction_id
78: , rsl.asn_line_flag
79: , DECODE(MSI.RETURN_INSPECTION_REQUIREMENT,1,'Y','N') INSPECTION_REQUIRED_FLAG
80: FROM mtl_transaction_lots_temp mtlt
81: , rcv_shipment_lines rsl
82: , rcv_transactions rt
83: , mtl_system_items msi
84: WHERE rt.group_id = p_group_id

Line 2118: DELETE FROM MTL_TRANSACTION_LOTS_TEMP

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;
2120:
2121: EXCEPTION
2122: WHEN OTHERS THEN NULL;

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 2467: -- It is not possible to use length function here because table MTL_TRANSACTION_LOTS_TEMP

2463: AND MSN.SERIAL_NUMBER >= MSNI.FM_SERIAL_NUMBER
2464: AND MSN.SERIAL_NUMBER <= MSNI.TO_SERIAL_NUMBER;
2465:
2466: -- AND length(MSN.SERIAL_NUMBER) = length(MSNT.FM_SERIAL_NUMBER);
2467: -- It is not possible to use length function here because table MTL_TRANSACTION_LOTS_TEMP
2468: -- has a field 'length' and it would result in a compilation error if function length
2469: -- is used.
2470:
2471: l_uom := l_primary_uom;

Line 2484: FROM WMS_LPN_CONTENTS WLPNC, MTL_TRANSACTION_LOTS_TEMP MTLT

2480: */
2481:
2482: open c_ref for SELECT DISTINCT MTLT.LOT_NUMBER, NULL FM_SERIAL_NUMBER,
2483: NULL TO_SERIAL_NUMBER, MTLT.transaction_quantity quantity,wlpnc.cost_group_id, MTLT.secondary_quantity sec_qty--13399743
2484: FROM WMS_LPN_CONTENTS WLPNC, MTL_TRANSACTION_LOTS_TEMP MTLT
2485: WHERE MTLT.TRANSACTION_TEMP_ID = p_rcv_trx_interface_id
2486: AND WLPNC.LOT_NUMBER = MTLT.LOT_NUMBER
2487: AND WLPNC.PARENT_LPN_ID = p_lpn_id
2488: AND WLPNC.INVENTORY_ITEM_ID = P_ITEM_ID

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 3581: -- It is not possible to use length function here because table MTL_TRANSACTION_LOTS_TEMP

3577: --AND MSN.LOT_NUMBER = MTLT.LOT_NUMBER
3578: AND MSN.SERIAL_NUMBER >= MSNT.FM_SERIAL_NUMBER
3579: AND MSN.SERIAL_NUMBER <= MSNT.TO_SERIAL_NUMBER;
3580: -- AND length(MSN.SERIAL_NUMBER) = length(MSNT.FM_SERIAL_NUMBER);
3581: -- It is not possible to use length function here because table MTL_TRANSACTION_LOTS_TEMP
3582: -- has a field 'length' and it would result in a compilation error if function length
3583: -- is used.
3584:
3585: ELSIF p_lot_controlled = 2 AND p_serial_controlled not in (2,5) THEN

Line 3589: FROM MTL_TRANSACTION_LOTS_TEMP MTLT

3585: ELSIF p_lot_controlled = 2 AND p_serial_controlled not in (2,5) THEN
3586: l_position := '0030';
3587: open c_ref for SELECT MTLT.LOT_NUMBER, NULL FM_SERIAL_NUMBER,
3588: NULL TO_SERIAL_NUMBER, MTLT.TRANSACTION_QUANTITY quantity
3589: FROM MTL_TRANSACTION_LOTS_TEMP MTLT
3590: WHERE MTLT.TRANSACTION_TEMP_ID = p_rcv_trx_interface_id;
3591:
3592: ELSIF p_lot_controlled <> 2 AND p_serial_controlled in (2,5) THEN
3593: l_position := '0040';

Line 4201: FROM mtl_transaction_lots_temp

4197: l_lot_control_code NUMBER := 1;
4198:
4199: CURSOR c_lots IS
4200: SELECT lot_number, primary_quantity
4201: FROM mtl_transaction_lots_temp
4202: WHERE product_code = 'RCV'
4203: AND product_transaction_id = p_intf_txn_id;
4204:
4205: CURSOR c_lots_old IS

Line 4207: FROM mtl_transaction_lots_temp

4203: AND product_transaction_id = p_intf_txn_id;
4204:
4205: CURSOR c_lots_old IS
4206: SELECT lot_number, primary_quantity
4207: FROM mtl_transaction_lots_temp
4208: WHERE transaction_temp_id = p_intf_txn_id;
4209:
4210: l_wms_po_j_higher BOOLEAN;
4211: