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

Line 4999: FROM mtl_serial_numbers

4995: WHERE organization_id = c_organization_id
4996: AND secondary_inventory_name = c_sub_inventory;
4997: CURSOR check_serial_number (c_inv_item_id NUMBER, c_serial_number VARCHAR2) IS
4998: SELECT 'X'
4999: FROM mtl_serial_numbers
5000: WHERE inventory_item_id = c_inv_item_id
5001: AND serial_number = c_serial_number;
5002: CURSOR check_lot_number (c_inv_item_id NUMBER, c_org_id NUMBER, c_lot_number VARCHAR2) IS
5003: SELECT 'X'