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_SERIAL_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

         make_common_queries('MSN_QUERY');

Line: 62


      ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

         make_common_queries('MSN');

Line: 65


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

Line: 104


      ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

         make_common_queries('MSN');

Line: 107


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

Line: 109


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

Line: 111


         inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
                                       'msn.current_subinventory_code';

Line: 113


         inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
                                       'msn.current_locator_id';

Line: 169


      ELSIF 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  organization_id = inv_mwb_globals.g_tree_organization_id
         AND    inventory_item_id = inv_mwb_globals.g_tree_item_id;

Line: 180


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

Line: 182


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

Line: 184


         inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
                                       'msn.current_subinventory_code';

Line: 186


         inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
                                       'msn.current_locator_id';

Line: 214


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

Line: 218


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

Line: 251


      ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

         SELECT lot_control_code
         INTO   l_lot_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: 260


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

Line: 262


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

Line: 264


         inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
                                       'msn.current_subinventory_code';

Line: 266


         inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
                                       'msn.current_locator_id';

Line: 268


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

Line: 304


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

Line: 330


      IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

         SELECT revision_qty_control_code
         INTO   l_rev_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: 339


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

Line: 341


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

Line: 343


         inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
                                       'msn.current_subinventory_code';

Line: 345


         inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
                                       'msn.current_locator_id';

Line: 347


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

Line: 379


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

Line: 399


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

Line: 401


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

Line: 403


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

Line: 405


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

Line: 411


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

Line: 413


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

Line: 415


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

Line: 417


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

Line: 446


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