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_MWB_QUERY_MANAGER dependencies on MTL_ITEM_LOCATIONS_KFV

Line 1618: FROM mtl_item_locations_kfv

1614:
1615: IF inv_mwb_globals.g_is_projects_enabled_org = 0 THEN
1616: UPDATE MTL_MWB_GTMP
1617: SET locator = substr((SELECT concatenated_segments
1618: FROM mtl_item_locations_kfv
1619: WHERE inventory_location_id = rec.locator_id), 1, 100) -- Bug 6595049: truncating the locator to 100 chars
1620: WHERE locator_id = rec.locator_id;
1621: ELSE
1622: l_project_id := NULL;

Line 1632: FROM mtl_item_locations_kfv

1628: SELECT project_id
1629: , task_id
1630: INTO l_project_id
1631: , l_task_id
1632: FROM mtl_item_locations_kfv
1633: WHERE inventory_location_id = rec.locator_id
1634: AND organization_id = rec.org_id;
1635:
1636: IF inv_mwb_globals.g_project_number IS NOT NULL THEN

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

2453: -- Bug 6060233
2454: IF inv_mwb_globals.g_view_by <> 'STATUS' THEN
2455:
2456: inv_mwb_query_manager.add_from_clause('mtl_system_items msit', 'ONHAND');
2457: inv_mwb_query_manager.add_from_clause('mtl_item_locations_kfv mil', 'ONHAND');
2458: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
2459: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');
2460: inv_mwb_query_manager.add_where_clause('moqd.organization_id = msit.organization_id', 'ONHAND');
2461: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = msit.inventory_item_id', 'ONHAND');

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

2486: WHEN 'ONHAND_MSN' THEN
2487:
2488: IF inv_mwb_globals.g_status_id IS NOT NULL THEN
2489: if l_default_status_id is null then -- Onhand Material Status Support
2490: inv_mwb_query_manager.add_from_clause('mtl_item_locations_kfv mil', 'ONHAND');
2491: inv_mwb_query_manager.add_from_clause('mtl_lot_numbers mln', 'ONHAND');
2492: inv_mwb_query_manager.add_from_clause('mtl_secondary_inventories msi', 'ONHAND');
2493: inv_mwb_query_manager.add_where_clause('msn.current_organization_id = mil.organization_id(+)', 'ONHAND');
2494: inv_mwb_query_manager.add_where_clause('msn.current_locator_id = mil.inventory_location_id(+)', 'ONHAND');