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_SYSTEM_ITEMS_KFV

Line 1589: FROM mtl_system_items_kfv

1585: SELECT
1586: l_item_name -- Bug 6350236
1587: , DESCRIPTION
1588: , PRIMARY_UOM_CODE
1589: FROM mtl_system_items_kfv
1590: WHERE inventory_item_id = rec.item_id
1591: AND organization_id = rec.org_id)
1592: WHERE item_id = rec.item_id;
1593:

Line 2266: inv_mwb_query_manager.add_from_clause('mtl_system_items_kfv msik', 'ONHAND');

2262: END IF;
2263:
2264: IF inv_mwb_globals.g_inventory_item_id IS NULL
2265: AND inv_mwb_globals.g_item_description IS NOT NULL THEN
2266: inv_mwb_query_manager.add_from_clause('mtl_system_items_kfv msik', 'ONHAND');
2267: add_where_clause('moqd.inventory_item_id = msik.inventory_item_id', 'ONHAND');
2268: add_where_clause('moqd.organization_id = msik.organization_id', 'ONHAND');
2269: add_where_clause('msik.description like :onh_item_description', 'ONHAND');
2270: add_bind_variable('onh_item_description', inv_mwb_globals.g_item_description);

Line 3117: inv_mwb_query_manager.add_from_clause('mtl_system_items_kfv msik','RECEIVING');

3113: END IF;
3114:
3115: IF inv_mwb_globals.g_inventory_item_id IS NULL
3116: AND inv_mwb_globals.g_item_description IS NOT NULL THEN
3117: inv_mwb_query_manager.add_from_clause('mtl_system_items_kfv msik','RECEIVING');
3118: add_where_clause('msik.inventory_item_id = msn.inventory_item_id', 'RECEIVING');
3119: add_where_clause('msik.organization_id = msn.current_organization_id', 'RECEIVING');
3120: add_where_clause('msik.description LIKE '':rcv_item_description''', 'RECEIVING');
3121: add_bind_variable('rcv_item_description', inv_mwb_globals.g_item_description);

Line 3427: add_from_clause(' mtl_system_items_kfv msik ','INBOUND');

3423: END IF;
3424:
3425: IF inv_mwb_globals.g_inventory_item_id IS NULL
3426: AND inv_mwb_globals.g_item_description IS NOT NULL THEN
3427: add_from_clause(' mtl_system_items_kfv msik ','INBOUND');
3428: add_where_clause(' ms.item_id = msik.inventory_item_id ', 'INBOUND');
3429: add_where_clause(' ms.to_organization_id = msik.organization_id ', 'INBOUND');
3430: add_where_clause(' msik.description like :inb_item_description ', 'INBOUND');
3431: add_bind_variable('inb_item_description', inv_mwb_globals.g_item_description);

Line 3640: add_from_clause(' mtl_system_items_kfv msik ','INBOUND');

3636: END IF;
3637:
3638: IF inv_mwb_globals.g_inventory_item_id IS NULL
3639: AND inv_mwb_globals.g_item_description IS NOT NULL THEN
3640: add_from_clause(' mtl_system_items_kfv msik ','INBOUND');
3641: add_where_clause(' ms.item_id = msik.inventory_item_id ', 'INBOUND');
3642: add_where_clause(' ms.to_organization_id = msik.organization_id ', 'INBOUND');
3643: add_where_clause(' msik.description like :inb_item_description ', 'INBOUND');
3644: add_bind_variable('inb_item_description', inv_mwb_globals.g_item_description);

Line 3757: add_from_clause(' mtl_system_items_kfv msik ','INBOUND');

3753: END IF;
3754:
3755: IF inv_mwb_globals.g_inventory_item_id IS NULL
3756: AND inv_mwb_globals.g_item_description IS NOT NULL THEN
3757: add_from_clause(' mtl_system_items_kfv msik ','INBOUND');
3758: add_where_clause(' ms.item_id = msik.inventory_item_id ', 'INBOUND');
3759: add_where_clause(' ms.to_organization_id = msik.organization_id ', 'INBOUND');
3760: add_where_clause(' msik.description like :inb_item_description ', 'INBOUND');
3761: add_bind_variable('inb_item_description', inv_mwb_globals.g_item_description);