DBA Data[Home] [Help]

APPS.INV_MWB_TREE1 SQL Statements

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

Line: 12

        insert into amintemp1 VALUES (b || a);
Line: 24

   select_str varchar2(10000);
Line: 46

      query_str := ' SELECT distinct pha.segment1, pha.po_header_id
                       FROM  po_headers_all pha
                           , po_lines_all pla
                           , mtl_supply ms
                           , mtl_system_items_kfv msik
                       WHERE pha.po_header_id = ms.po_header_id
                         AND pla.po_line_id = ms.po_line_id
                         AND pha.authorization_status = ''APPROVED''
                         AND ms.destination_type_code = ''INVENTORY''
                         AND ms.item_id = msik.inventory_item_id
                         AND ms.to_organization_id = msik.organization_id
                         AND ms.supply_type_code IN (''PO'')
                         AND pha.segment1 IS NOT NULL';
Line: 232

      select_str := ' SELECT distinct rsh.shipment_num, rsh.shipment_header_id FROM mtl_supply ms
                                  , rcv_shipment_lines rsl
                                  , rcv_shipment_headers rsh ';
Line: 244

         select_str := select_str || ' , wms_license_plate_numbers wlpn ';
Line: 286

         select_str := select_str || ', mtl_system_items_kfv msik ';
Line: 322

         select_str := select_str || ', rcv_serials_supply rss ';
Line: 340

         select_str := select_str || ', rcv_lots_supply rls ';
Line: 356

      query_str := select_str || where_str;
Line: 494

      select_str := ' SELECT distinct rsh.shipment_num, rsh.shipment_header_id FROM mtl_supply ms
                                  , rcv_shipment_lines rsl
                                  , rcv_shipment_headers rsh ';
Line: 507

         select_str := select_str || ' , wms_license_plate_numbers wlpn ';
Line: 554

         select_str := select_str || ', mtl_system_items_kfv msik ';
Line: 578

         select_str := select_str || ', rcv_serials_supply rss ';
Line: 609

         select_str := select_str || ', rcv_lots_supply rls ';
Line: 625

      query_str := select_str || where_str;
Line: 629

/*      delete from rtest2;
Line: 630

      insert into rtest2 values (query_str);
Line: 776

      select_str := ' SELECT distinct prha.segment1, prha.requisition_header_id
                        FROM mtl_supply ms
                           , po_requisition_headers_all prha
                           , po_requisition_lines_all prla ';
Line: 832

         select_str := select_str || ', mtl_system_items_kfv msik ';
Line: 841

         select_str := select_str || ', rcv_serials_supply rss ';
Line: 861

         select_str := select_str || ', rcv_lots_supply rls ';
Line: 877

      query_str := select_str || where_str;
Line: 881

/*      delete from rtest2;
Line: 882

      insert into rtest2 values (query_str);
Line: 1012

      inb_select_clause  VARCHAR2(500) := ' SELECT DISTINCT mp.organization_code , ms.to_organization_id ';
Line: 1051

         SELECT sum(inbound)
               ,sum(onhand)
               ,sum(receiving)
    	    INTO  l_inbound_qty
               ,l_onhand_qty
               ,l_rcv_qty
          FROM mtl_mwb_gtmp;
Line: 1380

         inb_query_str := inb_select_clause || inb_from_clause || inb_where_clause || inb_orderby_clause;
Line: 1384

/*         delete from rtest2;
Line: 1385

         insert into rtest2 values (inb_query_str);
Line: 1702

         query_str  := 'SELECT mp.organization_id, mp.organization_code  ';
Line: 1704

         query_str  := query_str || '(select organization_id ';
Line: 1757

         query_str  := ' SELECT mp.organization_id, mp.organization_code FROM mtl_parameters mp ';
Line: 1790

               query_str  := query_str || 'SELECT v.organization_id from ' || table_required;
Line: 1795

                || ' SELECT v.organization_id from'
		|| ' (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '		--BUG 7556505
                || inv_mwb_globals.g_tree_lot_attr_query
                || ' ) mln, '
                || table_required;
Line: 2007

          query_str  := query_str || ' and EXISTS ( SELECT 1 ' ;
Line: 2049

          query_str  := query_str || ' SELECT v.organization_id from ' || table_required;
Line: 2055

             || ' SELECT v.organization_id from'
             || ' (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
             || inv_mwb_globals.g_tree_serial_attr_query
             || ') msn, '
             || table_required;
Line: 2065

             || ' SELECT v.organization_id from'
             || ' (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '		--BUG 7556505
             || inv_mwb_globals.g_tree_lot_attr_query
             || ' ) mln, '
             || table_required;
Line: 2080

             || ' SELECT v.organization_id from'
             || ' (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '		--BUG 7556505
             || inv_mwb_globals.g_tree_lot_attr_query
             || ' ) mln, '
             || ' (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
             || inv_mwb_globals.g_tree_serial_attr_query
             || ' ) msn, '
             || table_required;
Line: 2261

           query_str := query_str || ' (select vendor_site_id from po_vendor_sites_all ';
Line: 2311

          query_str  := query_str || ' and EXISTS ( SELECT 1 ' ;
Line: 2346

          query_str  := query_str || 'SELECT v.organization_id from ' || table_required;
Line: 2351

             || 'SELECT v.organization_id from'
             || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '		--BUG 7556505
             || inv_mwb_globals.g_tree_lot_attr_query
             || ') mln, '
             || table_required;
Line: 2523

           query_str := query_str || ' (select vendor_site_id from po_vendor_sites_all ';
Line: 2589

          query_str  := query_str || 'SELECT v.organization_id from ' || table_required;
Line: 2595

             || 'SELECT v.organization_id from'
             || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
             || inv_mwb_globals.g_tree_lot_attr_query
             || ') mln, '
             || table_required;
Line: 2757

          query_str  := query_str || ' and EXISTS ( SELECT 1 ' ;
Line: 2793

        query_str  := query_str || ' SELECT organization_id from ' || table_required;
Line: 2797

          query_str  := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';
Line: 2856

                     query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_serial_attr_query
                     || ') msn ';
Line: 2861

          query_str  := query_str || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_lot_attr_query || ') mln ';
Line: 2872

             || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
             || inv_mwb_globals.g_tree_lot_attr_query
             || ') mln '
             || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
             || inv_mwb_globals.g_tree_serial_attr_query
             || ') msn ';
Line: 3057

           query_str := query_str || ' (select vendor_site_id from po_vendor_sites_all ';
Line: 3107

          query_str  := query_str || ' and EXISTS ( SELECT 1 ' ;
Line: 3273

   SELECT   mp.organization_id, mp.organization_code
      INTO  org_id,org_code
       FROM mtl_parameters mp
      WHERE EXISTS (SELECT organization_id
                      FROM mtl_onhand_total_mwb_v
                     WHERE 1 = 1 AND organization_id = mp.organization_id)
        AND mp.organization_id = inv_mwb_globals.g_organization_id
   ORDER BY organization_code;
Line: 3358

      query_str  := 'SELECT mp.organization_id, mp.organization_code  ';
Line: 3360

      query_str  := query_str || '(select organization_id ';
Line: 3413

      query_str  := ' SELECT mp.organization_id, mp.organization_code FROM mtl_parameters mp ';
Line: 3447

          query_str  := query_str || 'SELECT v.organization_id from ' || table_required;
Line: 3452

             || ' SELECT v.organization_id from'
             || ' (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
             || inv_mwb_globals.g_tree_lot_attr_query
             || ' ) mln, '
             || table_required;
Line: 3660

          query_str  := query_str || ' and EXISTS ( SELECT 1 ' ;
Line: 3702

          query_str  := query_str || ' SELECT v.organization_id from ' || table_required;
Line: 3708

             || ' SELECT v.organization_id from'
             || ' (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
             || inv_mwb_globals.g_tree_serial_attr_query
             || ') msn, '
             || table_required;
Line: 3718

             || ' SELECT v.organization_id from'
             || ' (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '		--BUG 7556505
             || inv_mwb_globals.g_tree_lot_attr_query
             || ' ) mln, '
             || table_required;
Line: 3733

             || ' SELECT v.organization_id from'
             || ' (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '		--BUG 7556505
             || inv_mwb_globals.g_tree_lot_attr_query
             || ' ) mln, '
             || ' (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
             || inv_mwb_globals.g_tree_serial_attr_query
             || ' ) msn, '
             || table_required;
Line: 3913

           query_str := query_str || ' (select vendor_site_id from po_vendor_sites_all ';
Line: 3963

          query_str  := query_str || ' and EXISTS ( SELECT 1 ' ;
Line: 3998

          query_str  := query_str || 'SELECT v.organization_id from ' || table_required;
Line: 4003

             || 'SELECT v.organization_id from'
             || ' (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '		--BUG 7556505
             || inv_mwb_globals.g_tree_lot_attr_query
             || ') mln, '
             || table_required;
Line: 4175

           query_str := query_str || ' (select vendor_site_id from po_vendor_sites_all ';
Line: 4240

          query_str  := query_str || 'SELECT v.organization_id from ' || table_required;
Line: 4246

             || 'SELECT v.organization_id from'
             || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
             || inv_mwb_globals.g_tree_lot_attr_query
             || ') mln, '
             || table_required;
Line: 4408

          query_str  := query_str || ' and EXISTS ( SELECT 1 ' ;
Line: 4444

        query_str  := query_str || ' SELECT organization_id from ' || table_required;
Line: 4448

          query_str  := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';
Line: 4506

                     query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_serial_attr_query
                     || ') msn ';
Line: 4511

          query_str  := query_str || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_lot_attr_query || ') mln ';
Line: 4522

             || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
             || inv_mwb_globals.g_tree_lot_attr_query
             || ') mln '
             || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
             || inv_mwb_globals.g_tree_serial_attr_query
             || ') msn ';
Line: 4707

           query_str := query_str || ' (select vendor_site_id from po_vendor_sites_all ';
Line: 4757

          query_str  := query_str || ' and EXISTS ( SELECT 1 ' ;
Line: 4923

   SELECT   mp.organization_id, mp.organization_code
      INTO  org_id,org_code
       FROM mtl_parameters mp
      WHERE EXISTS (SELECT organization_id
                      FROM mtl_onhand_total_mwb_v
                     WHERE 1 = 1 AND organization_id = mp.organization_id)
        AND mp.organization_id = inv_mwb_globals.g_organization_id
   ORDER BY organization_code;
Line: 5023

    query_str       := 'SELECT mms.status_id, mms.status_code ';
Line: 5029

      SELECT serial_number_control_code
        INTO serial_control
        FROM mtl_system_items
       WHERE organization_id = inv_mwb_globals.g_organization_id
         AND inventory_item_id = inv_mwb_globals.g_inventory_item_id;
Line: 5044

        query_str  := query_str || 'SELECT v.organization_id from mtl_onhand_serial_v v ';
Line: 5055

           || 'SELECT v.organization_id from'
           || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_serial_attr_query
           || ') msn, mtl_onhand_serial_v v ';
Line: 5069

           || 'SELECT v.organization_id from'
           || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_lot_attr_query
           || ') mln, mtl_onhand_serial_v v ';
Line: 5088

           || 'SELECT v.organization_id from'
           || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_lot_attr_query
           || ') mln, '
           || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_serial_attr_query
           || ') msn, mtl_onhand_serial_v v ';
Line: 5229

         query_str := query_str || ' (select vendor_site_id from po_vendor_sites_all ';
Line: 5280

        query_str  := query_str || ' AND  EXISTS ( SELECT 1 ' ;
Line: 5302

        query_str  := query_str || 'SELECT v.organization_id from mtl_onhand_total_v v ';
Line: 5307

           || 'SELECT v.organization_id from'
           || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_lot_attr_query
           || ') mln, mtl_onhand_total_v v ';
Line: 5436

         query_str := query_str || ' (select vendor_site_id from po_vendor_sites_all ';
Line: 5511

        query_str  := query_str || ' AND  EXISTS ( SELECT 1 ' ;
Line: 5529

        query_str  := query_str || 'SELECT v.organization_id from mtl_onhand_serial_v v ';
Line: 5535

           || 'SELECT v.organization_id from'
           || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_lot_attr_query
           || ') mln, mtl_onhand_serial_v v  ';
Line: 5666

         query_str := query_str || ' (select vendor_site_id from po_vendor_sites_all ';
Line: 5717

        query_str  := query_str || ' and EXISTS ( SELECT 1 ' ;
Line: 5743

      query_str       := query_str || 'SELECT organization_id from ' || table_required;
Line: 5747

        query_str  := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';
Line: 5792

                     query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_serial_attr_query
                     || ') msn ';
Line: 5797

        query_str  := query_str || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_lot_attr_query || ') mln ';
Line: 5808

           || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_lot_attr_query
           || ') mln '
           || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_serial_attr_query
           || ') msn ';
Line: 5927

         query_str := query_str || ' (select vendor_site_id from po_vendor_sites_all ';
Line: 5979

        query_str  := query_str || ' and EXISTS ( SELECT 1 ' ;
Line: 6249

      query_str  := 'select wlpn.subinventory_code ';
Line: 6304

      query_str  := 'SELECT msi.secondary_inventory_name subinventory_code FROM mtl_secondary_inventories msi ';
Line: 6334

          query_str  := query_str || ' SELECT v.subinventory_code from ' || table_required;
Line: 6339

             || ' SELECT v.subinventory_code from '
             || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
             || inv_mwb_globals.g_tree_lot_attr_query
             || ') mln, '
             || table_required;
Line: 6402

           query_str := query_str || ' (select vendor_site_id from po_vendor_sites_all ';
Line: 6534

          query_str  := query_str || 'SELECT v.subinventory_code from ' || table_required;
Line: 6540

             || 'SELECT v.subinventory_code from'
             || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
             || inv_mwb_globals.g_tree_serial_attr_query
             || ') msn, '
             || table_required;
Line: 6550

             || 'SELECT v.subinventory_code from'
             || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
             || inv_mwb_globals.g_tree_lot_attr_query
             || ') mln, '
             || table_required;
Line: 6565

             || 'SELECT v.subinventory_code from'
             || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
             || inv_mwb_globals.g_tree_lot_attr_query
             || ') mln, '
             || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
             || inv_mwb_globals.g_tree_serial_attr_query
             || ') msn, '
             || table_required;
Line: 6616

           query_str := query_str || ' (select vendor_site_id from po_vendor_sites_all ';
Line: 6771

          query_str  := query_str || 'SELECT v.subinventory_code from ' || table_required;
Line: 6776

             || 'SELECT v.subinventory_code from'
             || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
             || inv_mwb_globals.g_tree_lot_attr_query
             || ') mln, '
             || table_required;
Line: 6816

           query_str := query_str || ' (select vendor_site_id from po_vendor_sites_all ';
Line: 6935

          query_str  := query_str || 'SELECT v.subinventory_code from ' || table_required;
Line: 6941

             || 'SELECT v.subinventory_code from'
             || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
             || inv_mwb_globals.g_tree_lot_attr_query
             || ') mln, '
             || table_required;
Line: 7093

        query_str  := query_str || 'SELECT subinventory_code from ' || table_required;
Line: 7097

          query_str  := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';
Line: 7159

                     query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_serial_attr_query
                     || ') msn ';
Line: 7164

          query_str  := query_str || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_lot_attr_query || ') mln ';
Line: 7175

             || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
             || inv_mwb_globals.g_tree_lot_attr_query
             || ') mln '
             || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
             || inv_mwb_globals.g_tree_serial_attr_query
             || ') msn ';
Line: 7208

           query_str := query_str || ' (select vendor_site_id from po_vendor_sites_all ';
Line: 7557

      SELECT stock_locator_control_code
        INTO stock_loc_code
        FROM mtl_parameters
       WHERE organization_id = NVL(inv_mwb_globals.g_tree_organization_id ,
                                   inv_mwb_globals.g_organization_id);
Line: 7571

          SELECT locator_type
            INTO loc_type
            FROM mtl_secondary_inventories
           WHERE secondary_inventory_name = NVL(inv_mwb_globals.g_tree_subinventory_code,
                                                inv_mwb_globals.g_subinventory_code)
             AND organization_id = NVL(inv_mwb_globals.g_tree_organization_id,
                                       inv_mwb_globals.g_organization_id);
Line: 7607

      query_str  := 'SELECT wlpn.locator_id, mil.concatenated_segments ';
Line: 7693

          query_str  := query_str || 'SELECT v.locator_id, v.locator from ' || table_required;
Line: 7698

             || 'SELECT v.locator_id, v.locator from'
             || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
             || inv_mwb_globals.g_tree_lot_attr_query
             || ') mln, '
             || table_required;
Line: 7741

           query_str := query_str || ' (select vendor_site_id from po_vendor_sites_all ';
Line: 7875

          query_str  := query_str || 'SELECT v.locator_id, v.locator from ' || table_required;
Line: 7881

             || 'SELECT v.locator_id, v.locator from'
             || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
             || inv_mwb_globals.g_tree_serial_attr_query
             || ') msn, '
             || table_required;
Line: 7891

             || 'SELECT v.locator_id, v.locator from'
             || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
             || inv_mwb_globals.g_tree_lot_attr_query
             || ') mln, '
             || table_required;
Line: 7906

             || 'SELECT v.locator_id, v.locator from'
             || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
             || inv_mwb_globals.g_tree_lot_attr_query
             || ') mln, '
             || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
             || inv_mwb_globals.g_tree_serial_attr_query
             || ') msn, '
             || table_required;
Line: 8062

        query_str  := 'SELECT locator_id, locator from (';
Line: 8065

          query_str  := query_str || 'SELECT v.locator_id locator_id, v.locator locator from ' || table_required;
Line: 8070

             || 'SELECT v.locator_id locator_id, v.locator locator from'
             || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
             || inv_mwb_globals.g_tree_lot_attr_query
             || ') mln, '
             || table_required;
Line: 8110

           query_str := query_str || ' (select vendor_site_id from po_vendor_sites_all ';
Line: 8234

          query_str  := query_str || 'SELECT v.locator_id locator_id , v.locator locator from ' || table_required;
Line: 8240

             || 'SELECT v.locator_id locator_id, v.locator locator from'
             || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
             || inv_mwb_globals.g_tree_lot_attr_query
             || ') mln, '
             || table_required;
Line: 8363

        query_str  := 'SELECT locator_id, locator from ' || table_required;
Line: 8367

          query_str  := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';
Line: 8423

                     query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_serial_attr_query
                     || ') msn ';
Line: 8428

          query_str  := query_str || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_lot_attr_query || ') mln ';
Line: 8439

             || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
             || inv_mwb_globals.g_tree_lot_attr_query
             || ') mln '
             || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
             || inv_mwb_globals.g_tree_serial_attr_query
             || ') msn ';
Line: 8472

           query_str := query_str || ' (select vendor_site_id from po_vendor_sites_all ';
Line: 8830

        query_str  := 'SELECT DISTINCT v.cost_group_id , ccg.cost_group ';
Line: 8836

           || 'SELECT v.cost_group_id , ccg.cost_group from'
           || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_lot_attr_query
           || ') mln, cst_cost_groups ccg, '
           || table_required;
Line: 8971

         query_str := query_str || ' (select vendor_site_id from po_vendor_sites_all ';
Line: 9005

        query_str  := query_str || ' and EXISTS ( SELECT 1 ' ;
Line: 9056

        query_str  := 'SELECT DISTINCT v.cost_group_id, ccg.cost_group ';
Line: 9063

           || 'SELECT DISTINCT v.cost_group_id, ccg.cost_group from'
           || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_serial_attr_query
           || ') msn, cst_cost_groups ccg, '
           || table_required;
Line: 9074

           || 'SELECT DISTINCT v.cost_group_id, ccg.cost_group from'
           || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_lot_attr_query
           || ') mln, cst_cost_groups ccg, '
           || table_required;
Line: 9090

           || 'SELECT DISTINCT v.cost_group_id, ccg.cost_group from'
           || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_lot_attr_query
           || ') mln, '
           || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_serial_attr_query
           || ') msn, cst_cost_groups ccg, '
           || table_required;
Line: 9239

        query_str := query_str || ' (select vendor_site_id from po_vendor_sites_all ';
Line: 9273

        query_str  := query_str || ' and EXISTS ( SELECT 1 ' ;
Line: 9320

      query_str  := 'SELECT DISTINCT cost_group_id, cost_group from (';
Line: 9323

        query_str  := query_str || 'SELECT v.cost_group_id cost_group_id, ccg.cost_group cost_group ';
Line: 9329

           || 'SELECT v.cost_group_id cost_group_id, ccg.cost_group cost_group FROM '
           || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_lot_attr_query
           || ') mln, cst_cost_groups ccg, '
           || table_required;
Line: 9467

         query_str := query_str || ' (select vendor_site_id from po_vendor_sites_all ';
Line: 9522

        query_str  := query_str || 'SELECT v.cost_group_id, ccg.cost_group ';
Line: 9529

           || 'SELECT v.cost_group_id, ccg.cost_group from'
           || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_lot_attr_query
           || ') mln, cst_cost_groups ccg, mtl_onhand_serial_v v ';
Line: 9633

        query_str  := query_str || ' and EXISTS ( SELECT 1 ' ;
Line: 9683

      query_str  := 'SELECT DISTINCT mol.cost_group_id, ccg.cost_group ';
Line: 9688

        query_str  := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';
Line: 9742

                     query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_serial_attr_query
                     || ') msn ';
Line: 9747

        query_str  := query_str || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_lot_attr_query || ') mln ';
Line: 9758

           || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_lot_attr_query
           || ') mln '
           || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_serial_attr_query
           || ') msn ';
Line: 9896

         query_str := query_str || ' (select vendor_site_id from po_vendor_sites_all ';
Line: 10136

/*  , inv_mwb_globals.g_inserted_under_org  IN            VARCHAR2 DEFAULT 'N'*/
    x_node_value          IN OUT NOCOPY NUMBER
  , x_node_tbl            IN OUT NOCOPY fnd_apptree.node_tbl_type
  , x_tbl_index           IN OUT NOCOPY NUMBER
  ) IS
    query_str        VARCHAR2(8000);
Line: 10148

    select_from_str  VARCHAR2(4000);
Line: 10165

      inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Entered'||inv_mwb_globals.g_inserted_under_org);
Line: 10184

      select_from_str :=
         ' SELECT DISTINCT wlpn.license_plate_number
                , wlpn.lpn_id
             FROM rcv_shipment_lines rsl
                , mtl_system_items_kfv msik
                , wms_license_plate_numbers wlpn ';
Line: 10202

         select_from_str := select_from_str || ' , rcv_serials_supply rss ';
Line: 10210

         select_from_str := select_from_str || ' , rcv_lots_supply rls ';
Line: 10280

      query_str := select_from_str || where_str;
Line: 10444

        query_str  := 'SELECT license_plate_number lpn, lpn_id, inventory_item_id ';
Line: 10446

        query_str  := query_str || ' (select outermost_lpn_id ';
Line: 10451

          IF inv_mwb_globals.g_inserted_under_org = 'Y' OR inv_mwb_globals.g_inserted_under_org = 'y' THEN
            query_str  := query_str || ' AND mol.subinventory_code is null AND mol.locator_id is null ';
Line: 10467

          IF inv_mwb_globals.g_inserted_under_org = 'Y' OR inv_mwb_globals.g_inserted_under_org = 'y' THEN
            --don't add the below locator id not null check
            NULL;
Line: 10533

        query_str  := 'SELECT license_plate_number lpn, lpn_id, inventory_item_id ';
Line: 10538

          IF inv_mwb_globals.g_inserted_under_org = 'Y'  OR inv_mwb_globals.g_inserted_under_org = 'y' THEN
            query_str  := query_str || ' AND mol.subinventory_code is null AND mol.locator_id is null ';
Line: 10554

          IF inv_mwb_globals.g_inserted_under_org = 'Y' OR inv_mwb_globals.g_inserted_under_org = 'y' THEN
            --don't add the below locator id not null check
            NULL;
Line: 10655

        query_str  := 'SELECT license_plate_number lpn, lpn_id, inventory_item_id ';
Line: 10657

        query_str  := query_str || ' (select MOL.outermost_lpn_id ';
Line: 10662

          query_str  := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';
Line: 10667

            IF inv_mwb_globals.g_inserted_under_org = 'Y' OR inv_mwb_globals.g_inserted_under_org = 'y' THEN
              query_str  := query_str || ' AND wlpn.subinventory_code is null AND wlpn.locator_id is null ';
Line: 10683

            IF inv_mwb_globals.g_inserted_under_org = 'Y' OR inv_mwb_globals.g_inserted_under_org = 'y' THEN
              --don't add the below locator id not null check
              NULL;
Line: 10747

                     query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_serial_attr_query
                     || ') msn ';
Line: 10752

          query_str  := query_str || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_lot_attr_query || ') mln ';
Line: 10763

             || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
             || inv_mwb_globals.g_tree_lot_attr_query
             || ') mln '
             || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
             || inv_mwb_globals.g_tree_serial_attr_query
             || ') msn ';
Line: 10796

           query_str := query_str || ' (select vendor_site_id from po_vendor_sites_all ';
Line: 10882

          IF inv_mwb_globals.g_inserted_under_org = 'Y' OR inv_mwb_globals.g_inserted_under_org = 'y' THEN
                query_str  := query_str || ' AND subinventory_code is null AND locator_id is null ';
Line: 10907

          IF inv_mwb_globals.g_inserted_under_org = 'Y' OR inv_mwb_globals.g_inserted_under_org = 'y' THEN
            --don't add the below locator id not null check
            NULL;
Line: 10948

        query_str         := query_str || ' select license_plate_number lpn, lpn_id, inventory_item_id from wms_license_plate_numbers ';
Line: 10953

          IF inv_mwb_globals.g_inserted_under_org = 'Y' OR inv_mwb_globals.g_inserted_under_org = 'y' THEN
             query_str  := query_str || ' AND subinventory_code is null AND locator_id is null ';
Line: 11182

  /*, inv_mwb_globals.g_inserted_under_org  IN            VARCHAR2 DEFAULT 'N'*/
    x_node_value          IN OUT NOCOPY NUMBER
  , x_node_tbl            IN OUT NOCOPY fnd_apptree.node_tbl_type
  , x_tbl_index           IN OUT NOCOPY NUMBER
  ) IS
    query_str      VARCHAR2(10000);
Line: 11201

    select_str     VARCHAR2(10000) ;
Line: 11233

         inv_mwb_globals.g_inserted_under_org := 1;
Line: 11259

         query_str := ' SELECT distinct msik.concatenated_segments
                             , msik.inventory_item_id
                          FROM po_headers_all pha
                             , po_lines_all pla
                             , mtl_supply ms
                             , mtl_system_items_kfv msik
                         WHERE pha.po_header_id(+) = ms.po_header_id
                           AND pla.po_line_id(+) = ms.po_line_id
                           AND ms.destination_type_code = ''INVENTORY''
                           AND ms.item_id = msik.inventory_item_id
                           AND ms.to_organization_id = msik.organization_id
                           AND ms.supply_type_code IN (''PO'',''SHIPMENT'')
                           AND pha.segment1 IS NOT NULL';
Line: 11429

         select_str := ' SELECT distinct msik.concatenated_segments
                              , msik.inventory_item_id
                           FROM mtl_supply ms
                              , rcv_shipment_lines rsl
                              , rcv_shipment_headers rsh
                              , mtl_system_items_kfv msik ';
Line: 11514

            select_str := select_str || ', rcv_serials_supply rss ';
Line: 11534

            select_str := select_str || ', rcv_lots_supply rss ';
Line: 11552

         query_str := select_str || where_str;
Line: 11555

/*         delete from rtest2;
Line: 11556

         insert into rtest2 values (query_str);
Line: 11682

         select_str := ' SELECT distinct msik.concatenated_segments
                              , msik.inventory_item_id
                           FROM mtl_supply ms
                              , rcv_shipment_lines rsl
                              , rcv_shipment_headers rsh
                              , mtl_system_items_kfv msik ';
Line: 11759

            select_str := select_str || ', rcv_serials_supply rss ';
Line: 11798

            select_str := select_str || ', rcv_lots_supply rls ';
Line: 11816

         query_str := select_str || where_str;
Line: 11818

/*         delete from rtest2;
Line: 11819

         insert into rtest2 values (query_str);
Line: 11962

         select_str := ' SELECT distinct msik.concatenated_segments
                              , msik.inventory_item_id
                           FROM mtl_supply ms
                              , po_requisition_headers_all prha
                              , po_requisition_lines_all prla
                              , mtl_system_items_kfv msik ';
Line: 12023

            select_str := select_str || ', rcv_serials_supply rss ';
Line: 12043

            select_str := select_str || ', rcv_lots_supply rls ';
Line: 12061

         query_str := select_str || where_str;
Line: 12064

/*         delete from rtest2;
Line: 12065

         insert into rtest2 values (query_str);
Line: 12214

        query_str  := query_str || 'SELECT DISTINCT v.inventory_item_id, v.item from ' || table_required;
Line: 12219

           || 'SELECT DISTINCT v.inventory_item_id, v.item from'
           || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_lot_attr_query
           || ') mln, '
           || table_required;
Line: 12369

         query_str := query_str || ' (select vendor_site_id from po_vendor_sites_all ';
Line: 12401

        IF inv_mwb_globals.g_inserted_under_org = 'Y' OR inv_mwb_globals.g_inserted_under_org = 'y' THEN
          --don't add the below locator id not null check
          NULL;
Line: 12414

        IF inv_mwb_globals.g_inserted_under_org = 'Y' OR inv_mwb_globals.g_inserted_under_org = 'y' THEN
            query_str  := query_str || ' AND v.subinventory_code is null AND v.locator_id is null ';
Line: 12425

        query_str  := query_str || ' and EXISTS ( SELECT 1 ' ;
Line: 12480

        query_str  := query_str || 'SELECT DISTINCT v.inventory_item_id, v.item from ' || table_required;
Line: 12486

           || 'SELECT DISTINCT v.inventory_item_id, v.item from'
           || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_serial_attr_query
           || ') msn, '
           || table_required;
Line: 12496

           || 'SELECT DISTINCT v.inventory_item_id, v.item from'
           || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_lot_attr_query
           || ') mln, '
           || table_required;
Line: 12511

           || 'SELECT DISTINCT v.inventory_item_id, v.item from'
           || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_lot_attr_query
           || ') mln, '
           || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_serial_attr_query
           || ') msn, '
           || table_required;
Line: 12674

         query_str := query_str || ' (select vendor_site_id from po_vendor_sites_all ';
Line: 12706

        IF inv_mwb_globals.g_inserted_under_org = 'Y' OR inv_mwb_globals.g_inserted_under_org = 'y' THEN
          --don't add the below locator id not null check
          NULL;
Line: 12718

         IF inv_mwb_globals.g_inserted_under_org = 'Y' OR inv_mwb_globals.g_inserted_under_org = 'y' THEN
            query_str  := query_str || ' AND v.subinventory_code is null AND v.locator_id is null ';
Line: 12729

        query_str  := query_str || ' and EXISTS ( SELECT 1 ' ;
Line: 12764

      query_str  := 'SELECT DISTINCT inventory_item_id, item from( ';
Line: 12780

        query_str  := query_str || 'SELECT v.inventory_item_id inventory_item_id, v.item item from ' || table_required;
Line: 12785

           || 'SELECT v.inventory_item_id inventory_item_id, v.item item from'
           || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_lot_attr_query
           || ') mln, mtl_onhand_total_v v ';
Line: 12915

              || ' ( select null from mtl_system_items msi WHERE ';
Line: 12929

         query_str := query_str || ' (select vendor_site_id from po_vendor_sites_all ';
Line: 12961

        IF inv_mwb_globals.g_inserted_under_org = 'Y' OR inv_mwb_globals.g_inserted_under_org = 'y' THEN
          --don't add the below locator id not null check
          NULL;
Line: 12975

        query_str  := query_str || ' and EXISTS ( SELECT 1 ' ;
Line: 13003

        query_str  := query_str || 'SELECT v.inventory_item_id inventory_item_id, v.item item from mtl_onhand_serial_v v ';
Line: 13009

           || 'SELECT v.inventory_item_id inventory_item_id, v.item item from'
           || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_lot_attr_query
           || ') mln, mtl_onhand_serial_v v ';
Line: 13161

        IF inv_mwb_globals.g_inserted_under_org = 'Y' OR inv_mwb_globals.g_inserted_under_org = 'y' THEN
          --don't add the below locator id not null check
          NULL;
Line: 13182

        query_str  := query_str || ' and EXISTS ( SELECT 1 ' ;
Line: 13235

      query_str  := 'SELECT DISTINCT inventory_item_id, item ';
Line: 13241

        query_str  := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';
Line: 13246

          IF inv_mwb_globals.g_inserted_under_org = 'Y' OR inv_mwb_globals.g_inserted_under_org = 'y' THEN
            query_str  := query_str || ' AND wlpn.subinventory_code is null AND wlpn.locator_id is null ';
Line: 13307

                     query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_serial_attr_query
                     || ') msn ';
Line: 13312

        query_str  := query_str || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_lot_attr_query || ') mln ';
Line: 13323

           || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_lot_attr_query
           || ') mln '
           || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_serial_attr_query
           || ') msn ';
Line: 13455

        IF inv_mwb_globals.g_inserted_under_org = 'Y' OR inv_mwb_globals.g_inserted_under_org = 'y' THEN
          query_str  := query_str || ' AND mol.subinventory_code is null AND mol.locator_id is null ';
Line: 13494

         query_str := query_str || ' (select vendor_site_id from po_vendor_sites_all ';
Line: 13526

        IF inv_mwb_globals.g_inserted_under_org = 'Y' OR inv_mwb_globals.g_inserted_under_org = 'y' THEN
          --don't add the below locator id not null check
          NULL;
Line: 13541

        query_str  := query_str || ' and EXISTS ( SELECT 1 ' ;
Line: 13814

       select_from_str     VARCHAR2(1000);
Line: 13843

            SELECT revision_qty_control_code
              INTO rev_control
              FROM mtl_system_items
             WHERE organization_id = NVL(inv_mwb_globals.g_tree_organization_id
                                       , inv_mwb_globals.g_organization_id)
               AND inventory_item_id = NVL(inv_mwb_globals.g_tree_item_id
                                         , inv_mwb_globals.g_inventory_item_id);
Line: 13858

      select_from_str :=
         ' SELECT DISTINCT rsl.item_revision
                , msik.concatenated_segments
		, msik.inventory_item_id				-- Bug 6350236
             FROM rcv_shipment_lines rsl
                , mtl_system_items_kfv msik ';
Line: 13877

         select_from_str := select_from_str || ' , rcv_serials_supply rss ';
Line: 13885

         select_from_str := select_from_str || ' , rcv_lots_supply rls ';
Line: 13930

      query_str := select_from_str || where_str;
Line: 14046

      SELECT revision_qty_control_code
        INTO rev_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: 14085

        query_str  := query_str || 'SELECT v.item, v.inventory_item_id, v.revision from ' || table_required;		-- Bug 6350236
Line: 14090

           || 'SELECT v.item, v.inventory_item_id, v.revision from'							-- Bug 6350236
           || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_lot_attr_query
           || ') mln, '
           || table_required;
Line: 14214

         query_str := query_str || ' (select vendor_site_id from po_vendor_sites_all ';
Line: 14270

        query_str  := query_str || 'SELECT v.item, v.inventory_item_id, v.revision from ' || table_required;  -- Bug 6350236
Line: 14276

           || 'SELECT v.item, v.inventory_item_id, v.revision from'							-- Bug 6350236
           || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_serial_attr_query
           || ') msn, '
	   || table_required;
Line: 14286

           || 'SELECT v.item, v.inventory_item_id, v.revision from'							-- Bug 6350236
           || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_lot_attr_query
           || ') mln, '
	   || table_required;
Line: 14301

           || 'SELECT v.item, v.inventory_item_id, v.revision from'							-- Bug 6350236
           || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_lot_attr_query
           || ') mln, '
           || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_serial_attr_query
           || ') msn, '
	   || table_required;
Line: 14462

         query_str := query_str || ' (select vendor_site_id from po_vendor_sites_all ';
Line: 14512

      query_str  := 'SELECT item, inventory_item_id, revision from( ';					-- Bug 6350236
Line: 14515

        query_str  := query_str || 'SELECT v.item item, v.inventory_item_id inventory_item_id, v.revision revision from ' || table_required;	-- Bug 6350236
Line: 14520

           || 'SELECT v.item item, v.inventory_item_id inventory_item_id, v.revision revision from'						-- Bug 6350236
           || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_lot_attr_query
           || ') mln, '
           || table_required;
Line: 14647

         query_str := query_str || ' (select vendor_site_id from po_vendor_sites_all ';
Line: 14686

        query_str  := query_str || 'SELECT v.item item, v.inventory_item_id inventory_item_id, v.revision revision from ' || table_required;		-- Bug 6350236
Line: 14692

           || 'SELECT v.item item, v.inventory_item_id inventory_item_id, v.revision revision from'							-- Bug 6350236
           || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_lot_attr_query
           || ') mln, '
	   || table_required;
Line: 14819

         query_str := query_str || ' (select vendor_site_id from po_vendor_sites_all ';
Line: 14870

      query_str  := 'SELECT item, inventory_item_id, revision ';				-- Bug 6350236
Line: 14876

        query_str  := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';
Line: 14936

                     query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_serial_attr_query
                     || ') msn ';
Line: 14941

        query_str  := query_str || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_lot_attr_query || ') mln ';
Line: 14952

           || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_lot_attr_query
           || ') mln '
           || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_serial_attr_query
           || ') msn ';
Line: 14994

         query_str := query_str || ' (select vendor_site_id from po_vendor_sites_all ';
Line: 15335

    select_from_str VARCHAR2(2000);
Line: 15378

            SELECT lot_control_code
                 , serial_number_control_code
              INTO lot_control
                 , serial_control
              FROM mtl_system_items
             WHERE organization_id = NVL(inv_mwb_globals.g_tree_organization_id
                                       , inv_mwb_globals.g_organization_id)
               AND inventory_item_id = NVL(inv_mwb_globals.g_inventory_item_id
                                         , inv_mwb_globals.g_tree_item_id);
Line: 15394

      select_from_str :=
         ' SELECT DISTINCT rls.lot_num
             FROM rcv_shipment_lines rsl
                , mtl_supply ms ';
Line: 15412

         select_from_str := select_from_str || ' , rcv_serials_supply rls ';
Line: 15415

         select_from_str := select_from_str || ' , rcv_lots_supply rls ';
Line: 15469

      query_str := select_from_str || where_str;
Line: 15582

      SELECT lot_control_code
        INTO lot_control
        FROM mtl_system_items
       WHERE organization_id = NVL(inv_mwb_globals.g_tree_organization_id,
				   inv_mwb_globals.g_organization_id)
         AND inventory_item_id = NVL(inv_mwb_globals.g_tree_item_id,
				     inv_mwb_globals.g_inventory_item_id);
Line: 15625

        query_str  := query_str || 'SELECT v.lot_number from ' || table_required;
Line: 15630

           || 'SELECT v.lot_number from'
           || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_lot_attr_query
           || ') mln, '
           || table_required;
Line: 15679

         query_str := query_str || ' (select vendor_site_id from po_vendor_sites_all ';
Line: 15844

        query_str  := query_str || 'SELECT v.lot_number from ' || table_required;
Line: 15850

           || 'SELECT v.lot_number from'
           || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_serial_attr_query
           || ') msn, '
           || table_required;
Line: 15860

           || 'SELECT v.lot_number from'
           || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_lot_attr_query
           || ') mln, '
           || table_required;
Line: 15875

           || 'SELECT v.lot_number from'
           || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_lot_attr_query
           || ') mln, '
           || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_serial_attr_query
           || ') msn, '
           || table_required;
Line: 15931

         query_str := query_str || ' (select vendor_site_id from po_vendor_sites_all ';
Line: 16095

      query_str  := 'SELECT lot_number from( ';
Line: 16098

        query_str  := query_str || 'SELECT v.lot_number lot_number from ' || table_required;
Line: 16103

           || 'SELECT v.lot_number lot_number from'
           || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_lot_attr_query
           || ') mln, '
           || table_required;
Line: 16152

         query_str := query_str || ' (select vendor_site_id from po_vendor_sites_all ';
Line: 16245

         || ' ( select null from mtl_system_items msi WHERE '
         || ' v.organization_id = msi.organization_id and '
         || ' v.inventory_item_id =  msi.inventory_item_id and '
         || ' item_serial_control in (1,6) ) ';
Line: 16298

        query_str  := query_str || 'SELECT v.lot_number from ' || table_required;
Line: 16304

           || 'SELECT v.lot_number from'
           || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_lot_attr_query
           || ') mln, '
           || table_required;
Line: 16468

      query_str  := 'SELECT lot_number  ';
Line: 16474

        query_str  := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';
Line: 16535

                     query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_serial_attr_query
                     || ') msn ';
Line: 16540

        query_str  := query_str || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_lot_attr_query || ') mln ';
Line: 16551

           || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_lot_attr_query
           || ') mln '
           || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_serial_attr_query
           || ') msn ';
Line: 16622

         query_str := query_str || ' (select vendor_site_id from po_vendor_sites_all ';
Line: 16691

           || ' ( select null from mtl_system_items msi WHERE '
           || ' mol.organization_id = msi.organization_id and '
           || ' mol.inventory_item_id =  msi.inventory_item_id and '
           || ' item_serial_control in (1,6) ) ';
Line: 16699

           || ' ( select null from mtl_system_items msi WHERE '
           || ' mol.organization_id = msi.organization_id and '
           || ' mol.inventory_item_id =  msi.inventory_item_id and '
           || ' item_serial_control in (2,5) ) ';
Line: 16983

    select_from_str VARCHAR2(2000);
Line: 17031

      SELECT serial_number_control_code
        INTO serial_control
        FROM mtl_system_items
       WHERE organization_id = NVL(inv_mwb_globals.g_tree_organization_id,
				   inv_mwb_globals.g_organization_id)
         AND inventory_item_id = NVL(inv_mwb_globals.g_inventory_item_id,
				     inv_mwb_globals.g_tree_item_id);
Line: 17047

      select_from_str :=
         ' SELECT DISTINCT rss.serial_num
             FROM rcv_shipment_lines rsl
                , mtl_supply ms
                , rcv_serials_supply rss';
Line: 17110

      query_str := select_from_str || where_str;
Line: 17221

      SELECT serial_number_control_code
        INTO serial_control
        FROM mtl_system_items
       WHERE organization_id = NVL(inv_mwb_globals.g_tree_organization_id,
				   inv_mwb_globals.g_organization_id)
         AND inventory_item_id = NVL(inv_mwb_globals.g_inventory_item_id,
				     inv_mwb_globals.g_tree_item_id);
Line: 17257

        query_str  := query_str || 'SELECT v.serial_number serial_number from ' || table_required;
Line: 17263

           || 'SELECT v.serial_number serial_number from'
           || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_serial_attr_query
           || ') msn, '
           || table_required;
Line: 17273

           || 'SELECT v.serial_number serial_number from'
           || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_lot_attr_query
           || ') mln, '
	   || table_required;
Line: 17288

           || 'SELECT v.serial_number serial_number from'
           || '(SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_lot_attr_query
           || ') mln, '
           || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_serial_attr_query
           || ') msn, '
	   || table_required;
Line: 17462

         query_str := query_str || ' (select vendor_site_id from po_vendor_sites_all ';
Line: 17535

      query_str  := 'SELECT serial_number  ';
Line: 17541

        query_str  := query_str || ', (select outermost_lpn_id from wms_license_plate_numbers wlpn ';
Line: 17602

                     query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_serial_attr_query
                     || ') msn ';
Line: 17607

        query_str  := query_str || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 ' || inv_mwb_globals.g_tree_lot_attr_query || ') mln ';
Line: 17618

           || ', (SELECT lot_number lot_num, parent_lot_number FROM mtl_lot_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_lot_attr_query
           || ') mln '
           || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
           || inv_mwb_globals.g_tree_serial_attr_query
           || ') msn ';
Line: 17766

         query_str := query_str || ' (select vendor_site_id from po_vendor_sites_all ';
Line: 18046

      SELECT DISTINCT grade_control_flag
        INTO grade_control
        FROM mtl_system_items
       WHERE inventory_item_id = NVL(inv_mwb_globals.g_tree_item_id,
				     inv_mwb_globals.g_inventory_item_id)
         AND organization_id = NVL(inv_mwb_globals.g_tree_organization_id,
	                           inv_mwb_globals.g_organization_id);
Line: 18077

       query_str  := query_str || ' SELECT v.grade_code grade_code from ' || table_required;
Line: 18174

        query_str  := query_str || ' and EXISTS ( SELECT 1 ' ;
Line: 18195

      query_str  := query_str || ' SELECT v.grade_code grade_code from ' || table_required;
Line: 18301

        query_str  := query_str || ' and EXISTS ( SELECT 1 ' ;
Line: 18323

      query_str  := query_str || ' SELECT grade_code from ' || table_required;
Line: 18418

        query_str  := query_str || ' and EXISTS ( SELECT 1 ' ;
Line: 18602

      SELECT   fdfcu.form_left_prompt
             , fdfcu.application_column_name
          FROM fnd_descr_flex_col_usage_vl fdfcu, fnd_application_vl fa
         WHERE fdfcu.application_id = fa.application_id
           AND fa.application_short_name = 'INV'
           AND fdfcu.descriptive_flexfield_name = 'MTL_LOT_NUMBERS'
           AND(
               fdfcu.descriptive_flex_context_code IN(
                 SELECT fdfc.descriptive_flex_context_code
                   FROM fnd_descr_flex_contexts_vl fdfc
                  WHERE fdfc.global_flag = 'Y'
                    AND fdfc.descriptive_flexfield_name = 'MTL_LOT_NUMBERS'
                    AND fdfc.application_id = fa.application_id)
               OR fdfcu.descriptive_flex_context_code = inv_mwb_globals.g_mln_context_code
              )
           AND fdfcu.enabled_flag = 'Y'
      ORDER BY fdfcu.column_seq_num;
Line: 18653

      SELECT   fdfcu.form_left_prompt
             , fdfcu.application_column_name
          FROM fnd_descr_flex_col_usage_vl fdfcu, fnd_application_vl fa
         WHERE fdfcu.application_id = fa.application_id
           AND fa.application_short_name = 'INV'
           AND fdfcu.descriptive_flexfield_name = 'MTL_LOT_NUMBERS'
           AND(
               fdfcu.descriptive_flex_context_code IN(
                 SELECT fdfc.descriptive_flex_context_code
                   FROM fnd_descr_flex_contexts_vl fdfc
                  WHERE fdfc.global_flag = 'Y'
                    AND fdfc.descriptive_flexfield_name = 'MTL_LOT_NUMBERS'
                    AND fdfc.application_id = fa.application_id)
               OR fdfcu.descriptive_flex_context_code = inv_mwb_globals.g_mln_context_code
              )
           AND fdfcu.enabled_flag = 'Y'
      ORDER BY fdfcu.column_seq_num;
Line: 18682

    SELECT attribute1
         , attribute2
         , attribute3
         , attribute4
         , attribute5
         , attribute6
         , attribute7
         , attribute8
         , attribute9
         , attribute10
         , attribute11
         , attribute12
         , attribute13
         , attribute14
         , attribute15
         , attribute_category
      INTO l_attribute(1)
         , l_attribute(2)
         , l_attribute(3)
         , l_attribute(4)
         , l_attribute(5)
         , l_attribute(6)
         , l_attribute(7)
         , l_attribute(8)
         , l_attribute(9)
         , l_attribute(10)
         , l_attribute(11)
         , l_attribute(12)
         , l_attribute(13)
         , l_attribute(14)
         , l_attribute(15)
         , l_mln_context_code
      FROM mtl_lot_numbers
     WHERE inventory_item_id = inv_mwb_globals.g_inventory_item_id
       AND organization_id = inv_mwb_globals.g_organization_id
       AND lot_number = inv_mwb_globals.g_tree_lot_number;
Line: 18747

      SELECT   fdfcu.form_left_prompt
             , fdfcu.application_column_name
          FROM fnd_descr_flex_col_usage_vl fdfcu, fnd_application_vl fa
         WHERE fdfcu.application_id = fa.application_id
           AND fa.application_short_name = 'INV'
           AND fdfcu.descriptive_flexfield_name = 'MTL_SERIAL_NUMBERS'
           AND(
               fdfcu.descriptive_flex_context_code IN(
                 SELECT fdfc.descriptive_flex_context_code
                   FROM fnd_descr_flex_contexts_vl fdfc
                  WHERE fdfc.global_flag = 'Y'
                    AND fdfc.descriptive_flexfield_name = 'MTL_SERIAL_NUMBERS'
                    AND fdfc.application_id = fa.application_id)
               OR fdfcu.descriptive_flex_context_code = inv_mwb_globals.g_msn_context_code
              )
           AND fdfcu.enabled_flag = 'Y'
      ORDER BY fdfcu.column_seq_num;
Line: 18798

      SELECT   fdfcu.form_left_prompt
             , fdfcu.application_column_name
          FROM fnd_descr_flex_col_usage_vl fdfcu, fnd_application_vl fa
         WHERE fdfcu.application_id = fa.application_id
           AND fa.application_short_name = 'INV'
           AND fdfcu.descriptive_flexfield_name = 'MTL_SERIAL_NUMBERS'
           AND(
               fdfcu.descriptive_flex_context_code IN(
                 SELECT fdfc.descriptive_flex_context_code
                   FROM fnd_descr_flex_contexts_vl fdfc
                  WHERE fdfc.global_flag = 'Y'
                    AND fdfc.descriptive_flexfield_name = 'MTL_SERIAL_NUMBERS'
                    AND fdfc.application_id = fa.application_id)
               OR fdfcu.descriptive_flex_context_code = inv_mwb_globals.g_msn_context_code
              )
           AND fdfcu.enabled_flag = 'Y'
      ORDER BY fdfcu.column_seq_num;
Line: 18827

    SELECT attribute1
         , attribute2
         , attribute3
         , attribute4
         , attribute5
         , attribute6
         , attribute7
         , attribute8
         , attribute9
         , attribute10
         , attribute11
         , attribute12
         , attribute13
         , attribute14
         , attribute15
         , attribute_category
      INTO l_attribute(1)
         , l_attribute(2)
         , l_attribute(3)
         , l_attribute(4)
         , l_attribute(5)
         , l_attribute(6)
         , l_attribute(7)
         , l_attribute(8)
         , l_attribute(9)
         , l_attribute(10)
         , l_attribute(11)
         , l_attribute(12)
         , l_attribute(13)
         , l_attribute(14)
         , l_attribute(15)
         , l_msn_context_code
      FROM mtl_serial_numbers
     WHERE inventory_item_id = inv_mwb_globals.g_inventory_item_id
       AND current_organization_id = inv_mwb_globals.g_organization_id
       AND serial_number = inv_mwb_globals.g_tree_serial_number;
Line: 18889

		SELECT	organization_id into l_org_id
		FROM	mtl_system_items
		WHERE	inventory_item_id = p_item_id
		AND	rownum = 1;