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_RCV_DIR_RCPT_APIS dependencies on MTL_LOT_NUMBERS

Line 4006: FROM mtl_lot_numbers mln

4002: , lpnc.lot_number
4003: , mln.expiration_date
4004: , mln.status_id
4005: , lpnc.lpn_org_id
4006: FROM mtl_lot_numbers mln
4007: , (SELECT wlpn.lpn_id
4008: , wlpnc.inventory_item_id
4009: , msi.organization_id
4010: , msi.lot_control_code

Line 4230: FROM mtl_lot_numbers

4226: IF (p_source_type = 'INTERNAL' AND l_lot_control_code = 2) THEN
4227: BEGIN
4228: SELECT expiration_date
4229: INTO l_lot_expiration_date
4230: FROM mtl_lot_numbers
4231: WHERE inventory_item_id = l_inventory_item_id
4232: AND organization_id = l_lpn_org
4233: AND lot_number = l_lot_number;
4234: EXCEPTION