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_UI_ITEM_ATT_LOVS dependencies on MTL_LOT_NUMBERS_ALL_V

Line 437: FROM mtl_lot_numbers_all_v

433: SELECT expiration_date
434: , NVL(status_code, '')
435: INTO x_expiration_date
436: , x_lot_status
437: FROM mtl_lot_numbers_all_v
438: WHERE organization_id = p_organization_id
439: AND inventory_item_id = p_inventory_item_id
440: AND lot_number = p_lot_number
441: AND ROWNUM < 2