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

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

Line: 30


      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_status_id IS NOT NULL -- Bug 6060233
            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: 70


     ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

        IF inv_mwb_globals.g_chk_onhand = 1 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_status_id IS NOT NULL -- Bug 6060233
              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: 144


      ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

         SELECT revision_qty_control_code,
                lot_control_code,
                serial_number_control_code
         INTO   l_rev_control,
                l_lot_control,
                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: 180


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

Line: 185


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

Line: 209


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

Line: 214


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

Line: 269


      ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

         SELECT lot_control_code,
                serial_number_control_code
         INTO   l_lot_control,
                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: 283


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

Line: 285


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

Line: 299


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

Line: 303


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

Line: 322


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

Line: 329


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

Line: 378


      ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

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

Line: 392


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

Line: 394


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

Line: 400


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

Line: 414


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

Line: 419


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

Line: 438


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

Line: 443


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

Line: 481


      IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

         SELECT revision_qty_control_code,
                lot_control_code
         INTO   l_rev_control,
                l_lot_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: 498


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

Line: 504


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

Line: 530


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

Line: 533


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

Line: 536


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

Line: 539


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

Line: 541


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

Line: 544


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

Line: 547


               inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UOM_CODE).column_value :=
                  'NULL';

Line: 550


               inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_PACKED).column_value :=
                  'NULL';

Line: 553


               inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UNPACKED).column_value :=
                  'NULL';

Line: 556


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

Line: 565


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

Line: 568


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

Line: 574


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

Line: 577


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


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


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

Line: 586


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

Line: 589


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


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


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

Line: 607


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

Line: 610


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

Line: 613


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

Line: 615


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

Line: 617


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

Line: 651


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