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_SERIAL_NUMBERS_INTERFACE

Line 2456: FROM MTL_SERIAL_NUMBERS MSN, MTL_SERIAL_NUMBERS_INTERFACE

2452: UNION --RTV Change 16197273
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

Line 2526: FROM MTL_SERIAL_NUMBERS MSN, MTL_SERIAL_NUMBERS_INTERFACE MSNI,

2522: UNION --RTV Change 16197273
2523:
2524: SELECT NULL LOT_NUMBER, MSN.SERIAL_NUMBER FM_SERIAL_NUMBER,
2525: MSN.SERIAL_NUMBER TO_SERIAL_NUMBER, null quantity, msn.COST_GROUP_ID, null sec_qty --13399743
2526: FROM MTL_SERIAL_NUMBERS MSN, MTL_SERIAL_NUMBERS_INTERFACE MSNI,
2527: wms_lpn_contents wlpnc
2528: WHERE MSNI.PRODUCT_TRANSACTION_ID = p_rcv_trx_interface_id
2529: AND MSN.INVENTORY_ITEM_ID = p_item_id
2530: AND Nvl(MSN.revision,'@@@') = Nvl(p_item_revision,'@@@')