APPS.INV_MWB_QUERY_MANAGER dependencies on MTL_ITEM_LOCATIONS_KFV

Line 1696: FROM mtl_item_locations_kfv

1692:
1693: IF inv_mwb_globals.g_is_projects_enabled_org = 0 THEN
1694: UPDATE MTL_MWB_GTMP
1695: SET locator = substr((SELECT concatenated_segments
1696: FROM mtl_item_locations_kfv
1697: WHERE inventory_location_id = rec.locator_id and ORGANIZATION_ID = rec.org_id), 1, 100) -- Bug 6595049: truncating the locator to 100 chars. + Bug 15847437: Add ORGANIZATION_ID into where clause
1698: WHERE locator_id = rec.locator_id;
1699: ELSE
1700: l_project_id := NULL;

Line 1715: FROM mtl_item_locations_kfv

1711: SELECT project_id
1712: , task_id
1713: INTO l_project_id
1714: , l_task_id
1715: FROM mtl_item_locations_kfv
1716: WHERE inventory_location_id = rec.locator_id
1717: AND organization_id = rec.org_id;
1718:
1719: --BUG 8266074--

Line 2802: inv_mwb_query_manager.add_from_clause('mtl_item_locations_kfv mil', 'ONHAND');

2798: -- Bug 6060233
2799: IF inv_mwb_globals.g_view_by <> 'STATUS' THEN
2800:
2801: inv_mwb_query_manager.add_from_clause('mtl_system_items msit', 'ONHAND');
2802: inv_mwb_query_manager.add_from_clause('mtl_item_locations_kfv mil', 'ONHAND');
2803: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
2804: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');
2805: inv_mwb_query_manager.add_where_clause('moqd.organization_id = msit.organization_id', 'ONHAND');
2806: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = msit.inventory_item_id', 'ONHAND');

Line 2835: inv_mwb_query_manager.add_from_clause('mtl_item_locations_kfv mil', 'ONHAND');

2831: WHEN 'ONHAND_MSN' THEN
2832:
2833: IF inv_mwb_globals.g_status_id IS NOT NULL THEN
2834: if l_default_status_id is null then -- Onhand Material Status Support
2835: inv_mwb_query_manager.add_from_clause('mtl_item_locations_kfv mil', 'ONHAND');
2836: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
2837: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');
2838: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = mil.organization_id(+)', 'ONHAND');
2839: inv_mwb_query_manager.add_where_clause('msn.current_locator_id = mil.inventory_location_id(+)', 'ONHAND');