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

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

Line: 36


      ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

      IF( inv_mwb_globals.g_chk_onhand = 1) THEN

         IF inv_mwb_globals.g_serial_from IS NOT NULL
         OR inv_mwb_globals.g_serial_to IS NOT NULL
         OR inv_mwb_globals.g_status_id IS NOT NULL
	 OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN		-- Bug 6429880

            make_common_query_onhand('MSN_QUERY');

Line: 48


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

Line: 50


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

Line: 52


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

Line: 63


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

Line: 65


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

Line: 67


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

Line: 92


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

Line: 94


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

Line: 96


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

Line: 135


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

Line: 141


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

Line: 177


   ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
      inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Tree Node Selected' );

Line: 186


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

Line: 198


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

Line: 210


               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.SUBINVENTORY_CODE).column_value :=
                  'rs.to_subinventory';

Line: 269


         SELECT locator_type
         INTO   loc_type
         FROM   mtl_secondary_inventories
         WHERE  secondary_inventory_name = inv_mwb_globals.g_tree_subinventory_code
         AND    organization_id = inv_mwb_globals.g_tree_organization_id;

Line: 314


    ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

--      IF(inv_mwb_globals.g_chk_onhand = 1) THEN
      IF(inv_mwb_globals.g_tree_mat_loc_id = 1) THEN
         IF inv_mwb_globals.g_serial_from IS NOT NULL  ---serials entered in qf
         OR inv_mwb_globals.g_serial_to IS NOT NULL
         OR inv_mwb_globals.g_status_id IS NOT NULL
	 OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN		-- Bug 6429880
            make_common_query_onhand('MSN_QUERY');

Line: 323


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

Line: 325


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

Line: 340


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

Line: 342


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

Line: 364


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

Line: 366


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

Line: 378


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

Line: 380


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

Line: 396


  END IF; -- node selected

Line: 437


   ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

      IF (inv_mwb_globals.g_tree_mat_loc_id = 1) THEN -- Onhand node chosen
            IF inv_mwb_globals.g_serial_from IS NOT NULL  ---serials entered in qf
            OR inv_mwb_globals.g_serial_to IS NOT NULL
            OR inv_mwb_globals.g_status_id IS NOT NULL
	    OR inv_mwb_globals.g_serial_attr_query IS NOT NULL THEN		-- Bug 6429880
               make_common_query_onhand('MSN_QUERY');

Line: 446


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

Line: 448


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

Line: 450


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

Line: 476


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

Line: 478


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

Line: 480


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

Line: 482


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

Line: 500


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

Line: 502


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

Line: 516


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

Line: 518


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

Line: 536


      END IF; -- node selected

Line: 577


      ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

         IF (inv_mwb_globals.g_tree_mat_loc_id = 1) THEN -- Onhand node chosen

            inv_mwb_query_manager.make_nested_lpn_onhand_query;

Line: 590


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

Line: 592


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

Line: 594


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

Line: 596


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

Line: 628


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

Line: 630


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

Line: 632


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

Line: 634


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

Line: 648


             inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.OWNING_ORG_ID).column_value :=
                'ms.intransit_owning_org_id';

Line: 650


             inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.EXPECTED_RECEIPT_DATE).column_value :=
                'ms.expected_delivery_date';

Line: 652


             inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.FROM_ORG_ID).column_value :=
                'ms.from_organization_id';

Line: 666


	          inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.REQ_HEADER_ID).column_value :=
    		      'ms.req_header_id';

Line: 668


    	       inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.DOCUMENT_LINE_NUMBER).column_value :=
    		      'ms.req_line_id';

Line: 670


    	       inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.LPN_ID).column_value :=
    		      'rsl.asn_lpn_id';

Line: 687


             inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.SHIPMENT_HEADER_ID_ASN).column_value :=
		         'ms.shipment_header_id';

Line: 689


             inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.DOCUMENT_LINE_NUMBER).column_value :=
		         'ms.shipment_line_id';

Line: 691


             inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.LPN_ID).column_value :=
		         'rsl.asn_lpn_id';

Line: 709


             inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.SHIPMENT_HEADER_ID_ASN).column_value :=
		         'ms.shipment_header_id';

Line: 711


             inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.DOCUMENT_LINE_NUMBER).column_value :=
		         'ms.shipment_line_id';

Line: 713


             inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.LPN_ID).column_value :=
		         'rsl.asn_lpn_id';

Line: 715


             inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.VENDOR_ID).column_value :=
		         'rsh.vendor_id';

Line: 717


             inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.VENDOR_SITE_ID).column_value :=
		         'rsh.vendor_site_id';

Line: 743


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

Line: 745


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

Line: 747


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

Line: 771


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

Line: 773


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

Line: 775


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

Line: 827


      select_lot       NUMBER;

Line: 828


      select_serial    NUMBER;

Line: 829


      select_grade     NUMBER;

Line: 908


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

Line: 928


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

Line: 930


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

Line: 932


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

Line: 934


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

Line: 973


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

Line: 975


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

Line: 977


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

Line: 979


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

Line: 1004


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

Line: 1084


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

Line: 1090


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

Line: 1115


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

Line: 1121


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

Line: 1144


                  inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.REVISION).column_value :=
                     'ms.item_revision';

Line: 1149


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

Line: 1151


                     inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.INBOUND).column_value :=
                        'sum(rls.quantity)';

Line: 1155


                     inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.SERIAL).column_value :=
                        'rss.serial_num';

Line: 1157


                     inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.INBOUND).column_value := 1;

Line: 1163


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.OWNING_ORG_ID).column_value :=
               'ms.intransit_owning_org_id';

Line: 1165


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.EXPECTED_RECEIPT_DATE).column_value :=
               'ms.expected_delivery_date';

Line: 1167


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.FROM_ORG_ID).column_value :=
               'ms.from_organization_id';

Line: 1177


                  inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.DOCUMENT_NUMBER).column_value :=
                  inv_mwb_globals.g_tree_node_value;

Line: 1179


                  inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.PO_HEADER_ID).column_value :=
                  'ms.po_header_id';

Line: 1181


                  inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.DOCUMENT_LINE_NUMBER).column_value :=
                  'ms.po_line_id';

Line: 1183


                  inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.REVISION).column_value :=
                  'ms.item_revision';

Line: 1185


                  inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.PO_RELEASE_ID).column_value :=
                  'ms.po_release_id';

Line: 1204


                  inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.REQ_HEADER_ID).column_value :=
                     'ms.req_header_id';

Line: 1206


                  inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.DOCUMENT_LINE_NUMBER).column_value :=
                     'ms.req_line_id';

Line: 1221


                  inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.SHIPMENT_HEADER_ID_ASN).column_value :=
                  'ms.shipment_header_id';

Line: 1223


                  inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.DOCUMENT_LINE_NUMBER).column_value :=
                  'ms.shipment_line_id';

Line: 1225


                  inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.SHIPPED_DATE).column_value :=
                  'rsh.shipped_date';

Line: 1227


                  inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.OWNING_ORG_ID).column_value :=
                  'ms.intransit_owning_org_id';

Line: 1242


                     inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.LPN_ID).column_value :=
                        'rsl.asn_lpn_id';

Line: 1253


                  inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.SHIPMENT_HEADER_ID_ASN).column_value :=
                  'ms.shipment_header_id';

Line: 1255


                  inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.DOCUMENT_LINE_NUMBER).column_value :=
                  'ms.shipment_line_id';

Line: 1257


                  inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.VENDOR_ID).column_value :=
                  'rsh.vendor_id';

Line: 1259


                  inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.VENDOR_SITE_ID).column_value :=
                  'rsh.vendor_site_id';

Line: 1261


                  inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.SHIPPED_DATE).column_value :=
                  'rsh.shipped_date';

Line: 1279


                     inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.LPN_ID).column_value :=
                        'rsl.asn_lpn_id';

Line: 1293


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

Line: 1295


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

Line: 1297


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

Line: 1337


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

Line: 1341


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

Line: 1346


                  inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.SERIAL).column_value :=
                  'rss.serial_num';

Line: 1354


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

Line: 1358


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

Line: 1365


      END IF; -- node selected

Line: 1382


      select_serial          NUMBER     := 0;

Line: 1383


      select_grade           NUMBER     := 0;                -- NSRIVAST, INVCONV

Line: 1446


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

Line: 1471


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

Line: 1473


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

Line: 1475


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

Line: 1477


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

Line: 1479


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

Line: 1489


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

Line: 1493


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

Line: 1528


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

Line: 1530


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

Line: 1532


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

Line: 1534


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

Line: 1536


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

Line: 1538


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

Line: 1565


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

Line: 1605


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.DOCUMENT_NUMBER).column_value :=
            inv_mwb_globals.g_tree_node_value;

Line: 1607


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.PO_HEADER_ID).column_value :=
               'ms.po_header_id';

Line: 1609


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.DOCUMENT_LINE_NUMBER).column_value :=
               'ms.po_line_id';

Line: 1611


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.REVISION).column_value :=
               'ms.item_revision';

Line: 1613


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.PO_HEADER_ID).column_value :=
               'ms.po_release_id';

Line: 1634


             inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.REQ_HEADER_ID).column_value :=
               'ms.req_header_id';

Line: 1636


             inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.DOCUMENT_LINE_NUMBER).column_value :=
               'ms.req_line_id';

Line: 1638


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

Line: 1640


             inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.LOT_EXPIRY_DATE).column_value :=
               'rls.expiration_date';

Line: 1659


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

Line: 1661


               inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.LOT_EXPIRY_DATE).column_value :=
                  'rls.expiration_date';

Line: 1666


               inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.SERIAL).column_value :=
                 'rss.serial_num';

Line: 1672


               inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.LPN_ID).column_value :=
                  'rsl.asn_lpn_id';

Line: 1679


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.SHIPMENT_HEADER_ID_ASN).column_value :=
               'ms.shipment_header_id';

Line: 1681


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.DOCUMENT_LINE_NUMBER).column_value :=
               'ms.shipment_line_id';

Line: 1683


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.SHIPPED_DATE).column_value :=
               'rsh.shipped_date';

Line: 1685


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.OWNING_ORG_ID).column_value :=
               'ms.intransit_owning_org_id';

Line: 1687


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.REVISION).column_value :=
               'ms.item_revision';

Line: 1705


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

Line: 1707


               inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.LOT_EXPIRY_DATE).column_value :=
                  'rls.expiration_date';

Line: 1712


               inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.SERIAL).column_value :=
                 'rss.serial_num';

Line: 1718


               inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.LPN_ID).column_value :=
                  'rsl.asn_lpn_id';

Line: 1725


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.SHIPMENT_HEADER_ID_ASN).column_value :=
               'ms.shipment_header_id';

Line: 1727


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.DOCUMENT_LINE_NUMBER).column_value :=
               'ms.shipment_line_id';

Line: 1729


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.SHIPPED_DATE).column_value :=
               'rsh.shipped_date';

Line: 1731


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.OWNING_ORG_ID).column_value :=
               'ms.intransit_owning_org_id';

Line: 1733


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.REVISION).column_value :=
               'ms.item_revision';

Line: 1750


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

Line: 1752


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

Line: 1754


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

Line: 1756


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

Line: 1791


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

Line: 1795


               inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.SERIAL).column_value :=
               'rss.serial_num';

Line: 1803


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

Line: 1823


    select_serial        NUMBER    := 0;

Line: 1873


    ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
      SELECT serial_number_control_code
      INTO   serial_control
      FROM   mtl_system_items
      WHERE  organization_id = inv_mwb_globals.g_tree_organization_id
      AND    inventory_item_id = inv_mwb_globals.g_tree_item_id;

Line: 1884


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

Line: 1886


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

Line: 1888


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

Line: 1890


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

Line: 1892


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

Line: 1894


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

Line: 1896


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

Line: 1940


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

Line: 1944


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

Line: 1946


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

Line: 1948


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

Line: 1950


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

Line: 1952


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

Line: 1984


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

Line: 2033


	          inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.REQ_HEADER_ID).column_value :=
    		      'ms.req_header_id';

Line: 2035


    	       inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.DOCUMENT_LINE_NUMBER).column_value :=
    		      'ms.req_line_id';

Line: 2037


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

Line: 2039


     	       inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.LOT_EXPIRY_DATE).column_value :=
    		      'rls.expiration_date';

Line: 2067


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.INBOUND).column_value :=
               'sum(rls.quantity)';

Line: 2074


               inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.SERIAL).column_value :=
                  'rss.serial_num';

Line: 2076


               inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.INBOUND).column_value := 1;

Line: 2094


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.REVISION).column_value :=
               'ms.item_revision';

Line: 2096


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.SHIPMENT_HEADER_ID_ASN).column_value :=
               'ms.shipment_header_id';

Line: 2098


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.DOCUMENT_LINE_NUMBER).column_value :=
               'ms.shipment_line_id';

Line: 2100


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

Line: 2102


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.LOT_EXPIRY_DATE).column_value :=
               'rls.expiration_date';

Line: 2104


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.SHIPPED_DATE).column_value :=
               'ms.receipt_date';

Line: 2106


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.OWNING_ORG_ID).column_value :=
               'ms.intransit_owning_org_id';

Line: 2118


               inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.LPN_ID).column_value :=
                  'rsl.asn_lpn_id';

Line: 2146


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.INBOUND).column_value :=
               'sum(rls.quantity)';

Line: 2155


               inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.SERIAL).column_value :=
                  'rss.serial_num';

Line: 2157


               inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.INBOUND).column_value := 1;

Line: 2162


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.REVISION).column_value :=
               'ms.item_revision';

Line: 2164


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.SHIPMENT_HEADER_ID_ASN).column_value :=
               'ms.shipment_header_id';

Line: 2166


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.DOCUMENT_LINE_NUMBER).column_value :=
               'ms.shipment_line_id';

Line: 2168


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

Line: 2170


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.LOT_EXPIRY_DATE).column_value :=
               'rls.expiration_date';

Line: 2172


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.SHIPPED_DATE).column_value :=
               'ms.receipt_date';

Line: 2174


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.OWNING_ORG_ID).column_value :=
               'ms.intransit_owning_org_id';

Line: 2186


               inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.LPN_ID).column_value :=
                  'rsl.asn_lpn_id';

Line: 2211


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

Line: 2213


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

Line: 2215


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

Line: 2217


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

Line: 2257


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

Line: 2261


           inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.SERIAL).column_value :=
              'rss.serial_num';

Line: 2269


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

Line: 2275


   END IF; -- node selected

Line: 2297


    IF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
      IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN
         make_common_query_onhand('MSN');

Line: 2300


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

Line: 2302


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

Line: 2304


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

Line: 2306


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

Line: 2308


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

Line: 2310


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

Line: 2312


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

Line: 2374


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

Line: 2376


               inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.LOT_EXPIRY_DATE).column_value :=
                  'rls.expiration_date';

Line: 2386


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.SERIAL).column_value :=
               'rss.serial_num';

Line: 2388


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.SHIPMENT_HEADER_ID_ASN).column_value :=
               'ms.shipment_header_id';

Line: 2390


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.DOCUMENT_LINE_NUMBER).column_value :=
               'ms.shipment_line_id';

Line: 2392


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.SHIPPED_DATE).column_value :=
               'ms.receipt_date';

Line: 2394


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.OWNING_ORG_ID).column_value :=
               'ms.intransit_owning_org_id';

Line: 2396


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.INBOUND).column_value := 1;

Line: 2404


               inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.LPN_ID).column_value :=
                  'rsl.asn_lpn_id';

Line: 2429


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

Line: 2431


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

Line: 2433


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

Line: 2435


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

Line: 2437


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

Line: 2439


        inv_mwb_query_manager.g_receiving_select(inv_mwb_query_manager.SERIAL).column_value :=
           'rss.serial_num';

Line: 2515


      SELECT meaning
      BULK COLLECT INTO document_type_meaning
      FROM mfg_lookups
      WHERE lookup_type = 'MTL_DOCUMENT_TYPES'
      ORDER BY lookup_code;

Line: 2548


               inv_mwb_globals.g_inserted_under_org := 'Y';

Line: 2550


               inv_mwb_globals.g_inserted_under_org := 'N';

Line: 2627


    ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
      inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Tree Node Selected' );

Line: 2636


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

Line: 2645


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

Line: 2655


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

Line: 2663


            inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Going to add po_header_id in select');

Line: 2664


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.PO_HEADER_ID).column_value :=
               'ms.po_header_id';

Line: 2666


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.REQ_HEADER_ID).column_value :=
               'ms.req_header_id';

Line: 2668


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.SHIPMENT_HEADER_ID_ASN).column_value :=
               'ms.shipment_header_id';

Line: 2704


      ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
         make_common_query_inbound('INBOUND');

Line: 2710


               inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.PO_HEADER_ID).column_value :=
                  'ms.po_header_id';

Line: 2712


               inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.RELEASE_NUMBER).column_value :=
                  'ms.po_release_id';

Line: 2721


               inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.REQ_HEADER_ID).column_value :=
                  'ms.req_header_id';

Line: 2729


               inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.SHIPMENT_HEADER_ID_ASN).column_value :=
                  'ms.shipment_header_id';

Line: 2737


               inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.SHIPMENT_HEADER_ID_ASN).column_value :=
                  'ms.shipment_header_id';

Line: 2739


               inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.VENDOR_ID).column_value :=
                  'rsh.vendor_id';

Line: 2741


               inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.VENDOR_SITE_ID).column_value :=
                  'rsh.vendor_site_id';

Line: 2785


      ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN

         inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.OWNING_ORG_ID).column_value :=
            'ms.intransit_owning_org_id';

Line: 2789


         inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.EXPECTED_RECEIPT_DATE).column_value :=
            'ms.expected_delivery_date';

Line: 2791


         inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.FROM_ORG_ID).column_value :=
            'ms.from_organization_id';

Line: 2801


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.DOCUMENT_NUMBER).column_value :=
            inv_mwb_globals.g_tree_node_value;

Line: 2803


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.PO_HEADER_ID).column_value :=
               'ms.po_header_id';

Line: 2805


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.DOCUMENT_LINE_NUMBER).column_value :=
               'ms.po_line_id';

Line: 2807


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.PO_RELEASE_ID).column_value :=
               'ms.po_release_id';

Line: 2821


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.REQ_HEADER_ID).column_value :=
               'ms.req_header_id';

Line: 2823


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.DOCUMENT_LINE_NUMBER).column_value :=
               'ms.req_line_id';

Line: 2834


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.SHIPMENT_HEADER_ID_ASN).column_value :=
               'ms.shipment_header_id';

Line: 2836


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.DOCUMENT_LINE_NUMBER).column_value :=
               'ms.shipment_line_id';

Line: 2838


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.LPN_ID).column_value :=
               'rsl.asn_lpn_id';

Line: 2840


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.OWNING_ORG_ID).column_value :=
               'ms.intransit_owning_org_id';

Line: 2842


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.SHIPPED_DATE).column_value :=
               'rsh.shipped_date';

Line: 2857


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.SHIPMENT_HEADER_ID_ASN).column_value :=
               'ms.shipment_header_id';

Line: 2859


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.DOCUMENT_LINE_NUMBER).column_value :=
               'ms.shipment_line_id';

Line: 2861


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.VENDOR_ID).column_value :=
               'rsh.vendor_id';

Line: 2863


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.VENDOR_SITE_ID).column_value :=
               'rsh.vendor_site_id';

Line: 2865


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.SHIPPED_DATE).column_value :=
               'rsh.shipped_date';

Line: 2867


            inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.LPN_ID).column_value :=
               'rsl.asn_lpn_id';

Line: 2885


      END IF; -- Tree node selected /expanded.

Line: 2896


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

Line: 2899


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

Line: 2902


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

Line: 2905


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

Line: 2914


               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_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
                     'DECODE(msn.lpn_id, NULL, 0,1)';

Line: 2920


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

Line: 2923


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

Line: 2926


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

Line: 2929


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

Line: 2932


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

Line: 2935


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

Line: 2938


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

Line: 2941


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

Line: 2944


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

Line: 2958


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

Line: 2961


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

Line: 2964


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

Line: 2972


               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_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
                     'SUM(DECODE(moqd.containerized_flag, 1, moqd.primary_transaction_quantity, 0))';

Line: 2978


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


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

Line: 2984


                  inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.owning_organization_id).column_value :=
                     'moqd.owning_organization_id';

Line: 2987


                  inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.planning_organization_id).column_value :=
                     'moqd.planning_organization_id';

Line: 2990


                  inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.owning_tp_type).column_value :=
                     'moqd.owning_tp_type';

Line: 2993


                  inv_mwb_query_manager.g_onhand_select(inv_mwb_query_manager.planning_tp_type).column_value :=
                     'moqd.planning_tp_type';

Line: 2996


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

Line: 2999


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


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


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

Line: 3019


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

Line: 3022


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

Line: 3025


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

Line: 3035


               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_onhand_select(inv_mwb_query_manager.PACKED).column_value :=
                     'sum(decode(msn.lpn_id,NULL,0, 1))';

Line: 3039


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

Line: 3056


            SELECT lot_control_code
              INTO l_lot_control
              FROM mtl_system_items
             WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
         AND organization_id = inv_mwb_globals.g_tree_organization_id;

Line: 3063


         inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.ITEM_ID).column_value :=
            'ms.item_id';

Line: 3065


         inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.ORG_ID).column_value :=
            'ms.to_organization_id';

Line: 3067


         inv_mwb_query_manager.g_inbound_select(inv_mwb_query_manager.INBOUND).column_value :=
           'SUM(ms.to_org_primary_quantity)'; --bug 4761399

Line: 3089


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

Line: 3091


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

Line: 3093


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

Line: 3099


            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 :=
                 'SUM(DECODE (rs.lpn_id, null, rs.to_org_primary_quantity, 0))';

Line: 3103


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

Line: 3108


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

Line: 3110


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

Line: 3112


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

Line: 3114


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

Line: 3121


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


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

Line: 3132


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

Line: 3134


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

Line: 3136


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

Line: 3143


            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 :=
                  'DECODE(rs.lpn_id, NULL, 0,1)';

Line: 3147


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

Line: 3152


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

Line: 3154


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

Line: 3156


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

Line: 3158


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

Line: 3164


            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 :=
                  'sum(decode(rs.lpn_id,NULL,0, 1))';

Line: 3168


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

Line: 3189


         inv_mwb_globals.g_inserted_under_org := 'Y';

Line: 3191


         inv_mwb_globals.g_inserted_under_org := 'N';