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 THEN		-- Bug 6429880
            make_common_queries('MSN_QUERY');

Line: 68


     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 THEN		-- Bug 6429880
              make_common_queries('MSN_QUERY');

Line: 140


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


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

Line: 179


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

Line: 203


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

Line: 208


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

Line: 263


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


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

Line: 279


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

Line: 291


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

Line: 295


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

Line: 314


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

Line: 321


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

Line: 370


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


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

Line: 386


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

Line: 392


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

Line: 404


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

Line: 409


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

Line: 428


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

Line: 433


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

Line: 471


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


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

Line: 494


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

Line: 520


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

Line: 523


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

Line: 526


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

Line: 529


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

Line: 531


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

Line: 534


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

Line: 537


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

Line: 540


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

Line: 543


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

Line: 546


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

Line: 555


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

Line: 558


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

Line: 564


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

Line: 567


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


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


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

Line: 576


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

Line: 579


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


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


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

Line: 597


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

Line: 600


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

Line: 603


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

Line: 605


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

Line: 607


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

Line: 641


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