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

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

Line: 92

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

Line: 130

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

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

Line: 143

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

Line: 145

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

Line: 147

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

Line: 165

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

Line: 167

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

Line: 169

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

Line: 179

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

Line: 181

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

Line: 183

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

Line: 185

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

Line: 201

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

Line: 203

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

Line: 205

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

Line: 215

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

Line: 217

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

Line: 219

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

Line: 229

      END IF; -- Node selected

Line: 252

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

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

Line: 264

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

Line: 266

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

Line: 268

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

Line: 286

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

Line: 288

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

Line: 290

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

Line: 292

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

Line: 302

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

Line: 304

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

Line: 306

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

Line: 308

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

Line: 324

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

Line: 326

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

Line: 328

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

Line: 338

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

Line: 340

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

Line: 342

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

Line: 352

      END IF; --Tree node selected

Line: 379

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

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

Line: 394

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

Line: 396

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

Line: 398

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

Line: 423

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

Line: 425

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

Line: 427

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

Line: 429

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

Line: 445

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

Line: 447

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

Line: 449

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

Line: 451

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

Line: 473

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

Line: 475

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

Line: 477

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

Line: 491

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

Line: 493

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

Line: 495

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

Line: 508

      END IF;  -- Node selected

Line: 566

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

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

Line: 588

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

Line: 590

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

Line: 592

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

Line: 595

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

Line: 600

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

Line: 604

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

Line: 638

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

Line: 673

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

Line: 675

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

Line: 677

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

Line: 679

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

Line: 683

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

Line: 688

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

Line: 692

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

Line: 711

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

Line: 713

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

Line: 715

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

Line: 717

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

Line: 740

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

Line: 748

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

Line: 752

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

Line: 779

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

Line: 781

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

Line: 783

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

Line: 791

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

Line: 796

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

Line: 800

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

Line: 815

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

Line: 817

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

Line: 819

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

Line: 827

                  inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.REVISION).column_value :=
                     'rs.item_revision';

Line: 831

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

Line: 886

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

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

Line: 905

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

Line: 907

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

Line: 909

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

Line: 911

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

Line: 916

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

Line: 920

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

Line: 958

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

Line: 985

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

Line: 987

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

Line: 989

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

Line: 991

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

Line: 993

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

Line: 998

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

Line: 1002

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

Line: 1023

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

Line: 1025

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

Line: 1027

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

Line: 1029

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

Line: 1031

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

Line: 1036

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

Line: 1063

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

Line: 1088

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

Line: 1090

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

Line: 1092

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

Line: 1099

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

Line: 1104

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

Line: 1108

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

Line: 1124

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

Line: 1126

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

Line: 1128

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

Line: 1135

               inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.REVISION).column_value :=
                  'rs.item_revision';

Line: 1140

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

Line: 1185

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

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

Line: 1199

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

Line: 1201

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

Line: 1203

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

Line: 1205

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

Line: 1209

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

Line: 1214

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

Line: 1252

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

Line: 1276

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

Line: 1278

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

Line: 1280

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

Line: 1282

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

Line: 1284

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

Line: 1286

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

Line: 1291

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

Line: 1315

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

Line: 1317

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

Line: 1319

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

Line: 1321

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

Line: 1323

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

Line: 1327

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

Line: 1356

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

Line: 1382

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

Line: 1384

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

Line: 1386

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

Line: 1393

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

Line: 1397

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

Line: 1402

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

Line: 1423

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

Line: 1425

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

Line: 1427

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

Line: 1434

               inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.REVISION).column_value :=
                  'rs.item_revision';

Line: 1439

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

Line: 1477

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

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

Line: 1485

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

Line: 1487

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

Line: 1489

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

Line: 1491

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

Line: 1495

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

Line: 1499

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

Line: 1521

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

Line: 1523

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

Line: 1525

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

Line: 1527

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

Line: 1529

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

Line: 1533

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

Line: 1537

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

Line: 1567

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

Line: 1569

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

Line: 1571

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

Line: 1573

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

Line: 1575

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

Line: 1579

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

Line: 1583

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

Line: 1631

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

Line: 1634

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

Line: 1637

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

Line: 1640

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

Line: 1642

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

Line: 1645

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

Line: 1647

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

Line: 1650

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

Line: 1653

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

Line: 1671

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

Line: 1674

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

Line: 1680

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

Line: 1683

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

Line: 1686

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

Line: 1688

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

Line: 1691

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

Line: 1694

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

Line: 1697

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

Line: 1709

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

Line: 1711

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

Line: 1713

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

Line: 1734

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

Line: 1736

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

Line: 1738

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

Line: 1746

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

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

Line: 1755

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

Line: 1757

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

Line: 1759

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

Line: 1761

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

Line: 1768

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

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

Line: 1779

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

Line: 1781

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

Line: 1783

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

Line: 1789

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

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

Line: 1796

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

Line: 1798

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

Line: 1800

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

Line: 1802

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

Line: 1808

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

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

Line: 1822

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

Line: 1824

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

Line: 1826

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

Line: 1828

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

Line: 1830

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

Line: 1858

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