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_INTERFACE

Line 2457: MSNI, mtl_transaction_lots_interface MTLI

2453:
2454: SELECT msn.lot_number, MSN.SERIAL_NUMBER FM_SERIAL_NUMBER,
2455: MSN.SERIAL_NUMBER TO_SERIAL_NUMBER, null quantity, msn.COST_GROUP_ID, null sec_qty--13399743
2456: FROM MTL_SERIAL_NUMBERS MSN, MTL_SERIAL_NUMBERS_INTERFACE
2457: MSNI, mtl_transaction_lots_interface MTLI
2458: WHERE MTLI.PRODUCT_TRANSACTION_ID = p_rcv_trx_interface_id
2459: AND MSNI.PRODUCT_TRANSACTION_ID = p_rcv_trx_interface_id
2460: AND MSN.INVENTORY_ITEM_ID = p_item_id
2461: AND Nvl(MSN.revision,'@@@') = Nvl(p_item_revision,'@@@')

Line 2495: FROM WMS_LPN_CONTENTS WLPNC, mtl_transaction_lots_interface MTLI

2491: UNION -- RTV Change 16197273
2492:
2493: SELECT DISTINCT MTLI.LOT_NUMBER, NULL FM_SERIAL_NUMBER,
2494: NULL TO_SERIAL_NUMBER, MTLI.transaction_quantity quantity,wlpnc.cost_group_id, MTLI.SECONDARY_TRANSACTION_QUANTITY sec_qty--13399743
2495: FROM WMS_LPN_CONTENTS WLPNC, mtl_transaction_lots_interface MTLI
2496: WHERE MTLI.PRODUCT_TRANSACTION_ID = p_rcv_trx_interface_id
2497: AND WLPNC.LOT_NUMBER = MTLI.LOT_NUMBER
2498: AND WLPNC.PARENT_LPN_ID = p_lpn_id
2499: AND WLPNC.INVENTORY_ITEM_ID = P_ITEM_ID