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 THEN		-- Bug 6429880

            make_common_queries('MSN_QUERY');

Line: 222


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

Line: 239


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

Line: 298


      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 THEN		-- Bug 6429880

            make_common_queries('MSN_QUERY');

Line: 305


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

Line: 326


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

Line: 388


      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 THEN		-- Bug 6429880

            make_common_queries('MSN_QUERY');

Line: 395


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

Line: 397


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

Line: 418


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

Line: 420


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

Line: 485


      ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

         make_common_queries('MSN');

Line: 526


      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 THEN		-- Bug 6429880

            make_common_queries('MSN_QUERY');

Line: 533


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

Line: 550


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

Line: 610


      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 THEN		-- Bug 6429880

            make_common_queries('MSN_QUERY');

Line: 617


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

Line: 638


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

Line: 702


      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 THEN		-- Bug 6429880

            make_common_queries('MSN_QUERY');

Line: 709


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

Line: 711


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

Line: 714


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

Line: 717


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

Line: 742


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

Line: 744


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

Line: 747


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

Line: 750


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

Line: 822


      IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

         make_common_queries('MSN');

Line: 867


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

Line: 870


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

Line: 873


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

Line: 876


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


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


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

Line: 885


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

Line: 888


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


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


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

Line: 905


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

Line: 908


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

Line: 910


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

Line: 913


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

Line: 924


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

Line: 927


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

Line: 930


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

Line: 933


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

Line: 936


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

Line: 939


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

Line: 941


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

Line: 944


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

Line: 947


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

Line: 974


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