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 2323: FROM MTL_SERIAL_NUMBERS

2319: -- because while ship confirming predefined serials, the group_mark_id is
2320: -- still not null and is stamped with a valid value.
2321: SELECT *
2322: INTO p_serial
2323: FROM MTL_SERIAL_NUMBERS
2324: WHERE INVENTORY_ITEM_ID = p_item.inventory_item_id
2325: AND CURRENT_ORGANIZATION_ID = p_org.organization_id
2326: AND SERIAL_NUMBER = p_serial.serial_number
2327: AND ((NVL(CURRENT_SUBINVENTORY_CODE,'@@@') =

Line 2346: FROM MTL_SERIAL_NUMBERS

2342: -- Status 1 or 6 serials will not have lot/revision stamped in MSN.
2343:
2344: SELECT *
2345: INTO p_serial
2346: FROM MTL_SERIAL_NUMBERS
2347: WHERE INVENTORY_ITEM_ID = p_item.inventory_item_id
2348: AND CURRENT_ORGANIZATION_ID = p_org.organization_id
2349: AND SERIAL_NUMBER = p_serial.serial_number
2350: AND (CURRENT_STATUS IN (1,6) OR NVL(LOT_NUMBER,'@@@') = NVL(p_lot.lot_number,'@@@'))