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

Line 971: from mtl_lot_numbers

967: BEGIN
968:
969: Select expiration_date
970: into l_lot_expiration_date
971: from mtl_lot_numbers
972: where lot_number = p_lot_number
973: and inventory_item_id = p_inventory_item_id
974: and organization_id= p_organization_id
975: and expiration_date is not null;

Line 1595: from mtl_lot_numbers

1591: BEGIN
1592:
1593: Select expiration_date
1594: into l_lot_expiration_date
1595: from mtl_lot_numbers
1596: where lot_number = p_lot_number
1597: and inventory_item_id = p_inventory_item_id
1598: and organization_id = p_organization_id
1599: and expiration_date is not null;

Line 2265: mtl_lot_numbers mln

2261: AND physical_inventory_id = p_phy_inv_id AND void_flag = 2)
2262:
2263: ) wms,
2264: mtl_serial_numbers msn,
2265: mtl_lot_numbers mln
2266: WHERE wms.organization_id = msn.current_organization_id (+)
2267: AND wms.inventory_item_id = msn.inventory_item_id (+)
2268: AND wms.subinventory_name = msn.current_subinventory_code(+)
2269: AND wms.locator_id = msn.current_locator_id(+)