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

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

Line: 74


      IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
         make_common_queries('MOQD');

Line: 76


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

Line: 78


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

Line: 80


         inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
         'moqd.subinventory_code';

Line: 82


         inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
         'moqd.locator_id';

Line: 84


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

Line: 86


         inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LPN_ID).column_value :=
         'moqd.lpn_id';

Line: 88


         inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.STATUS_ID).column_value :=
         'moqd.status_id';

Line: 186


       ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

          NULL;

Line: 215


      ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

         IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
            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 9486070
            THEN
            make_common_queries('MSN_QUERY');

Line: 223


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

Line: 240


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
                                  'moqd.subinventory_code';

Line: 299


      ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

         IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
            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 9486070
            THEN
            make_common_queries('MSN_QUERY');

Line: 307


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

Line: 328


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
                                  'moqd.locator_id';

Line: 390


      ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

         IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
            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 9486070
            THEN
            make_common_queries('MSN_QUERY');

Line: 398


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

Line: 400


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

Line: 421


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

Line: 423


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

Line: 488


      ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

         make_common_queries('MSN');

Line: 529


      IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

         IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
            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 9486070
            THEN

            make_common_queries('MSN_QUERY');

Line: 538


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

Line: 555


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
                                  'moqd.subinventory_code';

Line: 615


      IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

         IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
            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 9486070
            THEN

            make_common_queries('MSN_QUERY');

Line: 624


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

Line: 645


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
                                  'moqd.locator_id';

Line: 709


      IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

         IF ( inv_mwb_globals.g_serial_from IS NOT NULL AND
            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 9486070
            THEN

            make_common_queries('MSN_QUERY');

Line: 718


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

Line: 720


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

Line: 723


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

Line: 726


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

Line: 751


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

Line: 753


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

Line: 756


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
                                  'moqd.subinventory_code';--VARAJAGO

Line: 759


            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
                                  'moqd.locator_id';--VARAJAGO

Line: 831


      IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

         make_common_queries('MSN');

Line: 876


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

Line: 879


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

Line: 882


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

Line: 885


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


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


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

Line: 894


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

Line: 897


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


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


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

Line: 914


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

Line: 917


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

Line: 919


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

Line: 922


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

Line: 933


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

Line: 936


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

Line: 939


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

Line: 942


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

Line: 945


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

Line: 948


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

Line: 950


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

Line: 953


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

Line: 956


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

Line: 983


      OR inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

         inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Tree Node Type: '||inv_mwb_globals.g_tree_node_type);