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

Line 526: FROM mtl_system_items

522: serial_number_control_code
523: INTO l_rev_control,
524: l_lot_control,
525: l_serial_control
526: FROM mtl_system_items
527: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
528: AND organization_id = inv_mwb_globals.g_tree_organization_id;
529:
530: inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=

Line 859: FROM mtl_system_items

855: serial_number_control_code
856: INTO l_rev_control,
857: l_lot_control,
858: l_serial_control
859: FROM mtl_system_items
860: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
861: AND organization_id = inv_mwb_globals.g_tree_organization_id;
862:
863: IF inv_mwb_globals.g_chk_onhand = 1 THEN

Line 914: FROM mtl_system_items

910: SELECT lot_control_code,
911: serial_number_control_code
912: INTO l_lot_control,
913: l_serial_control
914: FROM mtl_system_items
915: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
916: AND organization_id = inv_mwb_globals.g_tree_organization_id;
917:
918: INV_MWB_ITEM_TREE.make_common_queries('MOQD');

Line 953: FROM mtl_system_items

949: SELECT revision_qty_control_code,
950: serial_number_control_code
951: INTO l_rev_control,
952: l_serial_control
953: FROM mtl_system_items
954: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
955: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
956:
957: INV_MWB_ITEM_TREE.make_common_queries('MOQD');

Line 1097: FROM mtl_system_items

1093: SELECT revision_qty_control_code,
1094: serial_number_control_code
1095: INTO l_rev_control,
1096: l_serial_control
1097: FROM mtl_system_items
1098: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
1099: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
1100:
1101: INV_MWB_LOT_TREE.make_common_queries('MOQD');

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 1935: FROM mtl_system_items

1931: or nvl(g_item_id_trak_qty, -9999) <> rec.item_id) then
1932:
1933: SELECT tracking_quantity_ind
1934: INTO l_tracking_qty_ind
1935: FROM mtl_system_items
1936: WHERE organization_id = rec.org_id
1937: AND inventory_item_id = rec.item_id;
1938:
1939: IF nvl(l_tracking_qty_ind, '@@@@') <> 'PS' THEN

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 2444: inv_mwb_query_manager.add_from_clause('mtl_system_items msit', 'ONHAND');

2440: if inv_mwb_globals.g_status_id is not null then
2441: if l_default_status_id is not null then
2442: IF inv_mwb_globals.g_view_by <> 'STATUS' THEN
2443:
2444: inv_mwb_query_manager.add_from_clause('mtl_system_items msit', 'ONHAND');
2445: inv_mwb_query_manager.add_where_clause('moqd.organization_id = msit.organization_id', 'ONHAND');
2446: inv_mwb_query_manager.add_where_clause('moqd.inventory_item_id = msit.inventory_item_id', 'ONHAND');
2447: inv_mwb_query_manager.add_where_clause('msit.serial_number_control_code IN (1, 6)', 'ONHAND');
2448:

Line 2456: inv_mwb_query_manager.add_from_clause('mtl_system_items msit', 'ONHAND');

2452: else
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');

Line 2744: FROM mtl_system_items

2740:
2741: IF inv_mwb_globals.g_tree_item_id IS NOT NULL THEN
2742: SELECT serial_number_control_code
2743: INTO l_serial_control
2744: FROM mtl_system_items
2745: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
2746: AND organization_id = inv_mwb_globals.g_tree_organization_id;
2747: END IF;
2748:

Line 2989: FROM mtl_system_items

2985: SELECT lot_control_code,
2986: serial_number_control_code
2987: INTO l_lot_control,
2988: l_serial_control
2989: FROM mtl_system_items
2990: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
2991: AND organization_id = inv_mwb_globals.g_tree_organization_id;
2992: EXCEPTION
2993: WHEN NO_DATA_FOUND THEN

Line 3053: inv_mwb_query_manager.add_from_clause('mtl_system_items_b msib','RECEIVING');

3049: END IF;
3050:
3051: IF inv_mwb_globals.g_inventory_item_id IS NULL
3052: AND inv_mwb_globals.g_item_description IS NOT NULL THEN
3053: inv_mwb_query_manager.add_from_clause('mtl_system_items_b msib','RECEIVING');
3054: add_where_clause('msib.inventory_item_id = rs.item_id', 'RECEIVING');
3055: add_where_clause('msib.organization_id = rs.to_organization_id', 'RECEIVING');
3056: add_where_clause('msib.description LIKE :rcv_item_description', 'RECEIVING');
3057: add_bind_variable('rcv_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 3219: inv_mwb_query_manager.add_from_clause('mtl_system_items_b msib','RECEIVING');

3215: END IF;
3216:
3217: IF inv_mwb_globals.g_inventory_item_id IS NULL
3218: AND inv_mwb_globals.g_item_description IS NOT NULL THEN
3219: inv_mwb_query_manager.add_from_clause('mtl_system_items_b msib','RECEIVING');
3220: add_where_clause('msib.inventory_item_id = rs.item_id', 'RECEIVING');
3221: add_where_clause('msib.organization_id = rs.to_organization_id', 'RECEIVING');
3222: add_where_clause('msib.description LIKE :rcv_item_description', 'RECEIVING');
3223: add_bind_variable('rcv_item_description', inv_mwb_globals.g_item_description);

Line 3316: FROM mtl_system_items

3312: serial_number_control_code
3313: INTO l_rev_control,
3314: l_lot_control,
3315: l_serial_control
3316: FROM mtl_system_items
3317: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
3318: AND organization_id = inv_mwb_globals.g_tree_organization_id;
3319:
3320: END IF;

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);