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.INV_VALIDATE dependencies on MTL_SERIAL_NUMBERS

Line 2191: FROM MTL_SERIAL_NUMBERS

2187: -- because while ship confirming predefined serials, the group_mark_id is
2188: -- still not null and is stamped with a valid value.
2189: SELECT *
2190: INTO p_serial
2191: FROM MTL_SERIAL_NUMBERS
2192: WHERE INVENTORY_ITEM_ID = p_item.inventory_item_id
2193: AND CURRENT_ORGANIZATION_ID = p_org.organization_id
2194: AND SERIAL_NUMBER = p_serial.serial_number
2195: AND ((NVL(CURRENT_SUBINVENTORY_CODE,'@@@') =

Line 2214: FROM MTL_SERIAL_NUMBERS

2210: -- Status 1 or 6 serials will not have lot/revision stamped in MSN.
2211:
2212: SELECT *
2213: INTO p_serial
2214: FROM MTL_SERIAL_NUMBERS
2215: WHERE INVENTORY_ITEM_ID = p_item.inventory_item_id
2216: AND CURRENT_ORGANIZATION_ID = p_org.organization_id
2217: AND SERIAL_NUMBER = p_serial.serial_number
2218: AND (CURRENT_STATUS IN (1,6) OR NVL(LOT_NUMBER,'@@@') = NVL(p_lot.lot_number,'@@@'))