APPS.INV_MWB_LPN_TREE SQL Statements

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

Line: 31

      ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

        -- If all material locations are unchecked and the view by is LPN
        -- Using ONHAND but it does not query onhand material location.
         IF inv_mwb_globals.g_chk_onhand = 0
         AND inv_mwb_globals.g_chk_receiving = 0
         AND inv_mwb_globals.g_chk_inbound = 0 THEN
            make_common_query_lpn;

Line: 88

         SELECT meaning
         BULK COLLECT INTO mtl_loc_type
         FROM mfg_lookups
         WHERE lookup_type = 'MTL_LOCATION_TYPES'
         ORDER BY lookup_code;

Line: 94

         inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Selected all the document types' );

Line: 132

      ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

        -- If all material locations are unchecked and the view by is LPN
	     -- Using ONHAND but it does not query onhand material location.

         IF inv_mwb_globals.g_chk_onhand = 0
         AND inv_mwb_globals.g_chk_receiving = 0
         AND inv_mwb_globals.g_chk_inbound = 0
         AND inv_mwb_globals.g_view_by = 'LPN' THEN
            make_common_query_lpn;

Line: 143

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

Line: 145

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

Line: 147

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

Line: 149

            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=
               'wlc.cost_group_id';

Line: 167

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

Line: 169

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

Line: 171

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

Line: 181

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

Line: 183

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

Line: 185

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

Line: 187

               inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=
                  'moqd.cost_group_id';

Line: 203

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

Line: 205

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

Line: 207

               inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.LPN_ID).column_value :=
                  'msn.lpn_id';

Line: 217

               inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
                  'rs.to_subinventory';

Line: 219

               inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
                  'rs.to_locator_id';

Line: 221

               inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.LPN_ID).column_value :=
                  'rs.lpn_id';

Line: 231

      END IF; -- Node selected

Line: 254

      ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

        -- If all material locations are unchecked and the view by is LPN
	-- Using ONHAND but it does not query onhand material location.
         IF inv_mwb_globals.g_chk_onhand = 0
         AND inv_mwb_globals.g_chk_receiving = 0
         AND inv_mwb_globals.g_chk_inbound = 0
         AND inv_mwb_globals.g_view_by = 'LPN' THEN
            make_common_query_lpn;

Line: 264

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

Line: 266

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

Line: 268

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

Line: 270

            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=
               'wlc.cost_group_id';

Line: 290

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

Line: 292

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

Line: 294

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

Line: 296

               inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=
                  'msn.cost_group_id';

Line: 306

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

Line: 308

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

Line: 310

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

Line: 312

               inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=
                  'moqd.cost_group_id';

Line: 328

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

Line: 330

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

Line: 332

               inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.LPN_ID).column_value :=
                  'msn.lpn_id';

Line: 342

               inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
                  'rs.to_subinventory';

Line: 344

               inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
                  'rs.to_locator_id';

Line: 346

               inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.LPN_ID).column_value :=
                  'rs.lpn_id';

Line: 356

      END IF; --Tree node selected

Line: 383

      ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

        -- If all material locations are unchecked and the view by is LPN
	     -- Using ONHAND but it does not query onhand material location.
         IF inv_mwb_globals.g_chk_onhand = 0
         AND inv_mwb_globals.g_chk_receiving = 0
         AND inv_mwb_globals.g_chk_inbound = 0
         AND inv_mwb_globals.g_view_by = 'LPN' THEN

            inv_mwb_query_manager.make_nested_lpn_onhand_query;

Line: 396

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

Line: 398

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

Line: 400

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

Line: 402

            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=
               'wlc.cost_group_id';

Line: 429

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

Line: 431

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

Line: 433

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

Line: 435

               inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=
                  'msn.cost_group_id';

Line: 451

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

Line: 453

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

Line: 455

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

Line: 457

               inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=
                  'moqd.cost_group_id';

Line: 479

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

Line: 481

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

Line: 483

               inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.LPN_ID).column_value :=
                  'msn.lpn_id';

Line: 497

               inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
                  'rs.to_subinventory';

Line: 499

               inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
                  'rs.to_locator_id';

Line: 501

               inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.LPN_ID).column_value :=
                  'rs.lpn_id';

Line: 514

      END IF;  -- Node selected

Line: 572

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

Line: 592

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

Line: 594

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

Line: 596

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

Line: 598

            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=
               'wlc.cost_group_id';

Line: 601

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

Line: 606

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

Line: 610

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

Line: 644

	      inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.STATUS_ID).column_value :=
                    l_status_id;

Line: 681

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

Line: 683

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

Line: 685

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

Line: 687

               inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=
                  'msn.cost_group_id';

Line: 691

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

Line: 696

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

Line: 700

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

Line: 719

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

Line: 721

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

Line: 723

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

Line: 725

               inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=
                  'moqd.cost_group_id';

Line: 748

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

Line: 756

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

Line: 760

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

Line: 787

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

Line: 789

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

Line: 791

               inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.LPN_ID).column_value :=
                  'msn.lpn_id';

Line: 799

                  inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.REVISION).column_value :=
					'msn.revision'; -- Bug 9865190

Line: 804

                  inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.LOT).column_value :=
					'msn.lot_number'; -- Bug 9865190

Line: 808

                  inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.SERIAL).column_value :=
                     'msn.serial_number'; -- Bug 9865190

Line: 823

               inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
                  'rs.to_subinventory';

Line: 825

               inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
                  'rs.to_locator_id';

Line: 827

               inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.LPN_ID).column_value :=
                  'rs.lpn_id';

Line: 835

                  inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.REVISION).column_value :=
                     'rs.item_revision'; -- Bug 9865190

Line: 840

			inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.RECEIVING).column_value :=
			  'SUM(rls.primary_quantity)';

Line: 843

			inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.UNPACKED).column_value :=
			  'SUM(DECODE (rs.lpn_id, null, rls.primary_quantity, 0))';

Line: 845

			inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.PACKED).column_value :=
			  'SUM(DECODE (rs.lpn_id, null, 0, rls.primary_quantity))';

Line: 848

			inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.LOT).column_value :=
            'rls.lot_num';

Line: 851

             inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.SECONDARY_RECEIVING).column_value :=
             'SUM(rls.secondary_quantity)';

Line: 853

              inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.SECONDARY_UNPACKED).column_value :=
              'SUM(DECODE (rs.lpn_id, null, rls.secondary_quantity, 0))';

Line: 855

              inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.SECONDARY_PACKED).column_value :=
              'SUM(DECODE (rs.lpn_id, null, 0, rls.secondary_quantity))';

Line: 861

                  inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.LOT).column_value :=
                     'rls.lot_num'; -- Bug 9865190

Line: 865

		  inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.RECEIVING).column_value :=
			  'SUM(rls.primary_quantity)';

Line: 868

		  inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.UNPACKED).column_value :=
			  'SUM(DECODE (rs.lpn_id, null, rls.primary_quantity, 0))';

Line: 870

		  inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.PACKED).column_value :=
			  'SUM(DECODE (rs.lpn_id, null, 0, rls.primary_quantity))';

Line: 874

        inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.SECONDARY_RECEIVING).column_value :=
        'SUM(rls.secondary_quantity)';

Line: 876

         inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.SECONDARY_UNPACKED).column_value :=
         'SUM(DECODE (rs.lpn_id, null, rls.secondary_quantity, 0))';

Line: 878

         inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.SECONDARY_PACKED).column_value :=
         'SUM(DECODE (rs.lpn_id, null, 0, rls.secondary_quantity))';

Line: 935

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

Line: 952

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

Line: 954

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

Line: 956

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

Line: 958

            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=
               'wlc.cost_group_id';

Line: 960

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

Line: 965

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

Line: 969

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

Line: 1007

	      inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.STATUS_ID).column_value :=
                    l_status_id;

Line: 1036

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

Line: 1038

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

Line: 1040

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

Line: 1042

               inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=
                  'msn.cost_group_id';

Line: 1044

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

Line: 1049

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

Line: 1053

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

Line: 1074

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

Line: 1076

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

Line: 1078

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

Line: 1080

               inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=
                  'moqd.cost_group_id';

Line: 1082

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

Line: 1087

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

Line: 1114

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

Line: 1139

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

Line: 1141

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

Line: 1143

               inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.LPN_ID).column_value :=
                  'msn.lpn_id';

Line: 1150

               inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.REVISION).column_value :=
                  'msn.revision'; -- Bug 9865190

Line: 1155

                  inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.LOT).column_value :=
                     'msn.lot_number'; -- Bug 9865190

Line: 1159

                  inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.SERIAL).column_value :=
                     'msn.serial_number'; -- Bug 9865190

Line: 1175

               inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
                  'rs.to_subinventory';

Line: 1177

               inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
                  'rs.to_locator_id';

Line: 1179

               inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.LPN_ID).column_value :=
                  'rs.lpn_id';

Line: 1186

               inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.REVISION).column_value :=
                  'rs.item_revision'; -- Bug 9865190

Line: 1191

                  inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.LOT).column_value :=
                     'rls.lot_num'; -- Bug 9865190

Line: 1195

                  inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.RECEIVING).column_value :=
                    'SUM(rls.primary_quantity)';

Line: 1198

		   inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.UNPACKED).column_value :=
                    'SUM(DECODE (rs.lpn_id, null, rls.primary_quantity, 0))';

Line: 1200

                  inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.PACKED).column_value :=
                    'SUM(DECODE (rs.lpn_id, null, 0, rls.primary_quantity))';

Line: 1204

                     inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.SECONDARY_RECEIVING).column_value :=
                      'SUM(rls.secondary_quantity)';

Line: 1206

                     inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.SECONDARY_UNPACKED).column_value :=
                      'SUM(DECODE (rs.lpn_id, null, rls.secondary_quantity, 0))';

Line: 1208

                     inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.SECONDARY_PACKED).column_value :=
                      'SUM(DECODE (rs.lpn_id, null, 0, rls.secondary_quantity))';

Line: 1254

      ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

         SELECT serial_number_control_code
         INTO   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_organization_id;

Line: 1266

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

Line: 1268

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

Line: 1270

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

Line: 1272

            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=
               'wlc.cost_group_id';

Line: 1274

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

Line: 1278

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

Line: 1283

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

Line: 1321

	       inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.STATUS_ID).column_value :=
                     l_status_id;

Line: 1347

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

Line: 1349

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

Line: 1351

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

Line: 1353

               inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=
                  'msn.cost_group_id';

Line: 1355

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

Line: 1357

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

Line: 1362

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

Line: 1386

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

Line: 1388

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

Line: 1390

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

Line: 1392

               inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=
                  'moqd.cost_group_id';

Line: 1394

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

Line: 1398

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

Line: 1427

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

Line: 1453

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

Line: 1455

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

Line: 1457

               inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.LPN_ID).column_value :=
                  'msn.lpn_id';

Line: 1464

               inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.REVISION).column_value :=
                  'msn.revision'; -- Bug 9865190

Line: 1468

               inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.LOT).column_value :=
                  'msn.lot_number'; -- Bug 9865190

Line: 1473

                  inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.SERIAL).column_value :=
                     'msn.serial_number'; -- Bug 9865190

Line: 1494

               inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
                  'rs.to_subinventory';

Line: 1496

               inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
                  'rs.to_locator_id';

Line: 1498

               inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.LPN_ID).column_value :=
                  'rs.lpn_id';

Line: 1505

               inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.REVISION).column_value :=
                  'rs.item_revision'; -- Bug 9865190

Line: 1510

               inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.LOT).column_value :=
                  'rls.lot_num'; -- Bug 9865190

Line: 1514

	       inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.RECEIVING).column_value :=
                    'SUM(rls.primary_quantity)';

Line: 1517

               inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.UNPACKED).column_value :=
                    'SUM(DECODE (rs.lpn_id, null, rls.primary_quantity, 0))';

Line: 1519

               inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.PACKED).column_value :=
                    'SUM(DECODE (rs.lpn_id, null, 0, rls.primary_quantity))';

Line: 1522

                     inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.SECONDARY_RECEIVING).column_value :=
                     'SUM(rls.secondary_quantity)';

Line: 1524

                     inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.SECONDARY_UNPACKED).column_value :=
                      'SUM(DECODE (rs.lpn_id, null, rls.secondary_quantity, 0))';

Line: 1526

                     inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.SECONDARY_PACKED).column_value :=
                      'SUM(DECODE (rs.lpn_id, null, 0, rls.secondary_quantity))';

Line: 1565

      IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
         IF inv_mwb_globals.g_chk_onhand = 0
         AND inv_mwb_globals.g_chk_receiving = 0
         AND inv_mwb_globals.g_chk_inbound = 0
         AND inv_mwb_globals.g_view_by = 'LPN' THEN
            make_common_query_lpn;

Line: 1571

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

Line: 1573

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

Line: 1575

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

Line: 1577

            inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=
               'wlc.cost_group_id';

Line: 1579

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

Line: 1583

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

Line: 1587

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

Line: 1609

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

Line: 1611

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

Line: 1613

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

Line: 1615

               inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.CG_ID).column_value :=
                  'msn.cost_group_id';

Line: 1617

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

Line: 1621

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

Line: 1625

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

Line: 1655

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

Line: 1657

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

Line: 1659

               inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.LPN_ID).column_value :=
                  'msn.lpn_id';

Line: 1661

               inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.CG_ID).column_value :=
                  'msn.cost_group_id';

Line: 1663

               inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.REVISION).column_value :=
                  'msn.revision';

Line: 1667

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

Line: 1671

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

Line: 1719

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

Line: 1722

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

Line: 1725

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

Line: 1728

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

Line: 1730

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

Line: 1733

               inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value := 0;

Line: 1735

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

Line: 1738

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

Line: 1741

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

Line: 1759

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

Line: 1762

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

Line: 1768

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

Line: 1771

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

Line: 1774

               inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value := 0;

Line: 1776

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

Line: 1779

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

Line: 1782

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

Line: 1785

               inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.SECONDARY_UNPACKED).column_value := 0;

Line: 1797

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

Line: 1799

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

Line: 1801

               inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.UNPACKED).column_value := 0;

Line: 1822

            inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.ORG_ID).column_value :=
               'rs.to_organization_id';

Line: 1824

            inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.ITEM_ID).column_value :=
               'rs.item_id';

Line: 1826

            inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.RECEIVING).column_value :=
               'SUM(rs.to_org_primary_quantity)';

Line: 1830

              inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.SECONDARY_RECEIVING).column_value :=
            'SUM(rs.secondary_quantity)';

Line: 1839

            IF inv_mwb_globals.g_multiple_loc_selected = 'FALSE'
            OR inv_mwb_globals.g_tree_node_type <> 'APPTREE_OBJECT_TRUNK' THEN
               inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.UNPACKED).column_value := 0;

Line: 1842

               inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.PACKED).column_value :=
               'SUM(rs.to_org_primary_quantity)';

Line: 1846

                 inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.SECONDARY_UNPACKED).column_value :=
                 'SUM(DECODE (rs.lpn_id, null, rs.secondary_quantity, 0))';

Line: 1848

               inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.SECONDARY_PACKED).column_value :=
                 'SUM(DECODE (rs.lpn_id, null, 0, rs.secondary_quantity))';

Line: 1856

            inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.ORG_ID).column_value :=
               'wlpn.organization_id';

Line: 1858

            inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.ITEM_ID).column_value :=
               'wlc.inventory_item_id';

Line: 1860

            inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
               'wlc.uom_code';

Line: 1862

            inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.RECEIVING).column_value :=
               'SUM(wlc.primary_quantity)';--bug 4761399

Line: 1869

   	      IF inv_mwb_globals.g_multiple_loc_selected = 'FALSE'
            OR inv_mwb_globals.g_tree_node_type <> 'APPTREE_OBJECT_TRUNK' THEN
               inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.SECONDARY_UOM_CODE).column_value :=
                  'wlc.secondary_uom_code';

Line: 1878

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

Line: 1880

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

Line: 1882

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

Line: 1884

            inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.receiving).column_value := 1;

Line: 1890

            IF inv_mwb_globals.g_multiple_loc_selected = 'FALSE'
            OR inv_mwb_globals.g_tree_node_type <> 'APPTREE_OBJECT_TRUNK' THEN
               inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.PACKED).column_value := 1;

Line: 1893

               inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.UNPACKED).column_value := 0;

Line: 1897

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

Line: 1899

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

Line: 1901

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

Line: 1903

            inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.receiving).column_value :=
               'count(1)';

Line: 1909

            IF inv_mwb_globals.g_multiple_loc_selected = 'FALSE'
            OR inv_mwb_globals.g_tree_node_type <> 'APPTREE_OBJECT_TRUNK' THEN
               inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.PACKED).column_value :=
                  'count(1)';

Line: 1913

               inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.UNPACKED).column_value := 0;

Line: 1923

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

Line: 1925

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

Line: 1927

      inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.PRIMARY_UOM_CODE).column_value :=
      'wlc.uom_code';

Line: 1929

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

Line: 1931

      inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.ONHAND).column_value :=
      'SUM(wlc.primary_quantity)'; --bug 4761399

Line: 1959

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