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_LOT_APIS dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 777: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil

773: , msik.description
774: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
775: , mms.status_code
776: , mms.status_id
777: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil
778: WHERE moq.organization_id = p_organization_id
779: AND moq.lot_number IS NOT NULL
780: AND moq.organization_id = mil.organization_id
781: AND moq.organization_id = mln.organization_id

Line 806: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil

802: , msik.description
803: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
804: , NULL status_code
805: , msik.default_lot_status_id -- Bug#2267947
806: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil
807: WHERE moq.organization_id = p_organization_id
808: AND moq.lot_number IS NOT NULL
809: AND moq.organization_id = mil.organization_id
810: AND moq.organization_id = mln.organization_id