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_GRADE_TREE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 29


      ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

         IF inv_mwb_globals.g_serial_from IS NOT NULL  OR
            inv_mwb_globals.g_serial_to IS NOT NULL
	    OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN		-- Bug 6429880
            make_common_queries('MSN_QUERY');

Line: 69


      ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

         IF inv_mwb_globals.g_serial_from IS NOT NULL  OR
            inv_mwb_globals.g_serial_to IS NOT NULL
	    OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN		-- Bug 6429880
            make_common_queries('MSN_QUERY');

Line: 112


      ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

         IF inv_mwb_globals.g_serial_from IS NOT NULL  OR
            inv_mwb_globals.g_serial_to IS NOT NULL
	    OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN		-- Bug 6429880
            make_common_queries('MSN_QUERY');

Line: 119


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
                    'msn.inventory_item_id';

Line: 121


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
                    '''Ea''';

Line: 140


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
                    'moqd.inventory_item_id';

Line: 143


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
                    'moqd.transaction_uom_code';

Line: 211


      ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

         IF inv_mwb_globals.g_serial_from IS NOT NULL  OR
            inv_mwb_globals.g_serial_to IS NOT NULL
	    OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN		-- Bug 6429880
            make_common_queries('MSN_QUERY');

Line: 218


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
                    'msn.lot_number';

Line: 220


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
                    'msn.inventory_item_id';

Line: 222


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
                    '''Ea''';

Line: 248


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
                    'moqd.lot_number';

Line: 251


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
                    'moqd.inventory_item_id';

Line: 254


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
                    'moqd.transaction_uom_code';

Line: 332


      ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

         SELECT serial_number_control_code
           INTO l_serial_control
           FROM mtl_system_items
          WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
            AND organization_id = inv_mwb_globals.g_tree_organization_id;

Line: 361


               inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
                       'msn.lot_number';

Line: 363


               inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
                       'msn.inventory_item_id';

Line: 365


               inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
                       '''Ea''';

Line: 397


               inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOT).column_value :=
                       'moqd.lot_number';

Line: 400


               inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
                       'moqd.inventory_item_id';

Line: 403


               inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
                       'moqd.transaction_uom_code';

Line: 440


         inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.GRADE_CODE).column_value :=
                 'mln.grade_code';

Line: 487


      IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

         inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.GRADE_CODE).column_value :=
                 'mln.grade_code';

Line: 556


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
               'msn.inventory_item_id';

Line: 559


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
               'msn.current_organization_id';

Line: 562


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
               '''Ea''';

Line: 565


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value := 1;

Line: 567


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
               'SUM(DECODE(msn.lpn_id, NULL, 0,1))';

Line: 570


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
               'SUM(DECODE(msn.lpn_id, NULL, 1,0))';

Line: 573


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SERIAL).column_value :=
               'msn.serial_number';

Line: 576


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.owning_organization_id).column_value :=
               'msn.owning_organization_id';

Line: 579


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.planning_organization_id).column_value :=
               'msn.planning_organization_id';

Line: 582


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.owning_tp_type).column_value :=
               'msn.owning_tp_type';

Line: 585


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.planning_tp_type).column_value :=
               'msn.planning_tp_type';

Line: 588


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.GRADE_CODE).column_value :=
               'mln.grade_code';

Line: 611


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
               'moqd.organization_id';

Line: 614


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
               'moqd.inventory_item_id';

Line: 617


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.owning_organization_id).column_value :=
               'moqd.owning_organization_id';

Line: 620


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.planning_organization_id).column_value :=
               'moqd.planning_organization_id';

Line: 623


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.owning_tp_type).column_value :=
               'moqd.owning_tp_type';

Line: 626


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.planning_tp_type).column_value :=
               'moqd.planning_tp_type';

Line: 629


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.GRADE_CODE).column_value :=
               'mln.grade_code';

Line: 632


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UOM_CODE).column_value :=
               'moqd.secondary_uom_code';

Line: 635


   	      inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
               'SUM(moqd.primary_transaction_quantity)';

Line: 638


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
               'SUM(DECODE(moqd.containerized_flag, 1, moqd.primary_transaction_quantity, 0))';

Line: 641


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
               'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.primary_transaction_quantity))';

Line: 644


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_ONHAND).column_value :=
               'SUM(moqd.secondary_transaction_quantity)';

Line: 647


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_PACKED).column_value :=
               'SUM(DECODE(moqd.containerized_flag, 1, moqd.secondary_transaction_quantity, 0))';

Line: 650


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UNPACKED).column_value :=
               'SUM(DECODE(moqd.containerized_flag, 1, 0, moqd.secondary_transaction_quantity))';

Line: 674


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ITEM_ID).column_value :=
               'msn.inventory_item_id';

Line: 677


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ORG_ID).column_value :=
               'msn.current_organization_id';

Line: 680


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
               '''Ea''';

Line: 683


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
               'count(1)';

Line: 686


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
               'SUM(DECODE(msn.lpn_id, NULL, 0,1))';

Line: 689


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value :=
               'SUM(DECODE(msn.lpn_id, NULL, 1,0))';

Line: 692


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.owning_organization_id).column_value :=
               'msn.owning_organization_id';

Line: 695


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.planning_organization_id).column_value :=
               'msn.planning_organization_id';

Line: 698


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.owning_tp_type).column_value :=
               'msn.owning_tp_type';

Line: 701


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.planning_tp_type).column_value :=
               'msn.planning_tp_type';

Line: 704


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.GRADE_CODE).column_value :=
               'mln.grade_code';

Line: 740


      OR inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

         CASE inv_mwb_globals.g_tree_node_type

            WHEN 'APPTREE_OBJECT_TRUNK' THEN
                root_node_event (
                    x_node_value
                  , x_node_tbl
                  , x_tbl_index
                  );