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 1001: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil

997: , msik.description
998: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
999: , mms.status_code
1000: , mms.status_id
1001: 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: WHERE moq.organization_id = p_organization_id
1003: AND moq.lot_number IS NOT NULL
1004: AND moq.organization_id = mil.organization_id
1005: AND moq.organization_id = mln.organization_id

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

1026: , msik.description
1027: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1028: , NULL status_code
1029: , msik.default_lot_status_id -- Bug#2267947
1030: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil
1031: WHERE moq.organization_id = p_organization_id
1032: AND moq.lot_number IS NOT NULL
1033: AND moq.organization_id = mil.organization_id
1034: AND moq.organization_id = mln.organization_id

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

1271: , msik.description
1272: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1273: , mms.status_code
1274: , mms.status_id
1275: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil
1276: WHERE moq.organization_id = p_organization_id
1277: AND moq.lot_number IS NOT NULL
1278: AND moq.organization_id = mil.organization_id
1279: AND moq.organization_id = mln.organization_id

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

1301: , msik.description
1302: , TO_CHAR(mln.expiration_date, 'YYYY-MM-DD')
1303: , NULL status_code
1304: , msik.default_lot_status_id -- Bug#2267947
1305: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_system_items_kfv msik, mtl_material_statuses_vl mms, mtl_item_locations mil
1306: WHERE moq.organization_id = p_organization_id
1307: AND moq.lot_number IS NOT NULL
1308: AND moq.organization_id = mil.organization_id
1309: AND moq.organization_id = mln.organization_id