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_INV_LOVS dependencies on MTL_ITEM_LOCATIONS

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

973: , msik.description
974: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
975: , mms.status_code
976: , mms.status_id
977: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil
978: WHERE moq.organization_id = p_organization_id
979: AND moq.lot_number IS NOT NULL
980: AND moq.organization_id = mil.organization_id
981: AND moq.organization_id = mln.organization_id

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

1002: , msik.description
1003: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1004: , NULL status_code
1005: , msik.default_lot_status_id -- Bug#2267947
1006: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil
1007: WHERE moq.organization_id = p_organization_id
1008: AND moq.lot_number IS NOT NULL
1009: AND moq.organization_id = mil.organization_id
1010: AND moq.organization_id = mln.organization_id

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

1247: , msik.description
1248: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1249: , mms.status_code
1250: , mms.status_id
1251: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil
1252: WHERE moq.organization_id = p_organization_id
1253: AND moq.lot_number IS NOT NULL
1254: AND moq.organization_id = mil.organization_id
1255: AND moq.organization_id = mln.organization_id

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

1277: , msik.description
1278: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1279: , NULL status_code
1280: , msik.default_lot_status_id -- Bug#2267947
1281: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil
1282: WHERE moq.organization_id = p_organization_id
1283: AND moq.lot_number IS NOT NULL
1284: AND moq.organization_id = mil.organization_id
1285: AND moq.organization_id = mln.organization_id