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 4147: FROM mtl_lot_numbers mln

4143: , mln.expiration_date
4144: , mln.status_id
4145: , lpnc.lpn_org_id
4146: , lpnc.secondary_quantity --Bug 7656734
4147: FROM mtl_lot_numbers mln
4148: , (SELECT wlpn.lpn_id
4149: , wlpnc.inventory_item_id
4150: , msi.organization_id
4151: , msi.lot_control_code

Line 4374: FROM mtl_lot_numbers

4370: IF (p_source_type = 'INTERNAL' AND l_lot_control_code = 2) THEN
4371: BEGIN
4372: SELECT expiration_date
4373: INTO l_lot_expiration_date
4374: FROM mtl_lot_numbers
4375: WHERE inventory_item_id = l_inventory_item_id
4376: AND organization_id = l_lpn_org
4377: AND lot_number = l_lot_number;
4378: EXCEPTION