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              -- Bug 6429880
            OR inv_mwb_globals.g_unit_number IS NOT NULL                    -- Bug 9365452
         THEN
            make_common_queries('MSN_QUERY');

Line: 71


      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              -- Bug 6429880
            OR inv_mwb_globals.g_unit_number IS NOT NULL                    -- Bug 9365452
         THEN
            make_common_queries('MSN_QUERY');

Line: 116


      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              -- Bug 6429880
            OR inv_mwb_globals.g_unit_number IS NOT NULL                    -- Bug 9365452
         THEN
            make_common_queries('MSN_QUERY');

Line: 125


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

Line: 127


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

Line: 146


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

Line: 149


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

Line: 217


      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              -- Bug 6429880
            OR inv_mwb_globals.g_unit_number IS NOT NULL                    -- Bug 9365452
         THEN
            make_common_queries('MSN_QUERY');

Line: 226


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

Line: 228


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

Line: 230


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

Line: 256


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

Line: 259


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

Line: 262


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

Line: 340


      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: 371


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

Line: 373


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

Line: 375


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

Line: 407


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

Line: 410


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

Line: 413


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

Line: 450


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

Line: 497


      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: 566


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

Line: 569


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

Line: 572


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

Line: 575


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

Line: 577


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

Line: 580


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

Line: 583


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

Line: 586


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

Line: 589


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

Line: 592


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

Line: 595


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

Line: 598


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

Line: 621


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

Line: 624


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

Line: 627


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

Line: 630


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

Line: 633


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

Line: 636


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

Line: 639


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

Line: 642


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

Line: 645


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

Line: 648


            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: 651


            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: 654


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

Line: 657


            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: 660


            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: 684


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

Line: 687


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

Line: 690


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

Line: 693


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

Line: 696


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

Line: 699


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

Line: 702


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

Line: 705


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

Line: 708


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

Line: 711


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

Line: 714


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

Line: 750


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