APPS.MTL_DEFAULT_CATEGORY_SETS_PKG SQL Statements

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

Line: 81

            select CATEGORY_SET_NAME, DESCRIPTION
            into   :deflt_cat_set.category_set_name, :deflt_cat_set.category_set_description
            from  MTL_CATEGORY_SETS_VL
            where CATEGORY_SET_ID = :deflt_cat_set.category_set_id;

Line: 112

     Select 'X'
     Into buffer
     FROM dual
     WHERE EXISTS (
     SELECT 'X'
     From MTL_SYSTEM_ITEMS_B Item
     Where  Item.INVENTORY_ITEM_FLAG = 'Y'
     And    NOT EXISTS
       ( Select 'X'
         From  MTL_ITEM_CATEGORIES Cat
         Where Cat.INVENTORY_ITEM_ID = Item.INVENTORY_ITEM_ID
         And   Cat.ORGANIZATION_ID   = Item.ORGANIZATION_ID
         And   Cat.CATEGORY_SET_ID   = P_Category_Set_Id
       )
     );

Line: 150

     Select STRUCTURE_ID
     Into   Old_Structure_id
     From   MTL_CATEGORY_SETS_B
     WHERE  CATEGORY_SET_ID = (select category_set_id
                               From   MTL_DEFAULT_CATEGORY_SETS
                               Where  FUNCTIONAL_AREA_ID = 2);

Line: 158

     Select STRUCTURE_ID
     Into   New_Structure_id
     From   MTL_CATEGORY_SETS_B
     WHERE  CATEGORY_SET_ID = P_Category_Set_Id;

Line: 164

           Select count(*)
           Into   Po_Count
           From   Po_Line_Types_b
           where  category_id is NOT NULL
           and rownum < 2;

Line: 171

             Select count(*)
             Into   Po_Count
             From   PO_REQEXPRESS_LINES_ALL
             where  category_id is NOT NULL
             and rownum < 2;

Line: 178

               Select count(*)
               Into   Po_Count
               From   PO_AGENTS
               where  category_id is NOT NULL
               and rownum < 2;

Line: 185

                 Select count(*)
                 Into   Po_Count
                 From   PO_APPROVED_SUPPLIER_LIST
                 where  category_id is NOT NULL
                 and rownum < 2;

Line: 192

                   Select count(*)
                   Into   Po_Count
                   From   PO_ASL_ATTRIBUTES
                   where  category_id is NOT NULL
                   and rownum < 2;

Line: 199

                     Select count(*)
                     Into   Po_Count
                     From   PO_REQUISITION_LINES_ALL
                     where  category_id is NOT NULL
                     and rownum < 2;

Line: 206

                       Select count(*)
                       Into   Po_Count
                       From   PO_LINES_ALL
                       where  category_id is NOT NULL
                       and rownum < 2;

Line: 213

                         Select count(*)
                         Into   Po_Count
                         From   RCV_SHIPMENT_LINES
                         where  category_id is NOT NULL
                         and rownum < 2;

Line: 232

     Select DISTINCT 'X'
     Into buffer
     From MTL_SYSTEM_ITEMS_B Item
     Where  ( Item.PURCHASING_ITEM_FLAG = 'Y' OR
              Item.INTERNAL_ORDER_FLAG = 'Y' )
     And    NOT EXISTS
       ( Select 'X'
         From  MTL_ITEM_CATEGORIES Cat
         Where Cat.INVENTORY_ITEM_ID = Item.INVENTORY_ITEM_ID
         And   Cat.ORGANIZATION_ID   = Item.ORGANIZATION_ID
         And   Cat.CATEGORY_SET_ID   = P_Category_Set_Id
       );

Line: 267

     Select 'X'
     Into buffer
     FROM dual
     WHERE EXISTS (
     SELECT 'X'
     From MTL_SYSTEM_ITEMS_B Item
     Where  Item.MRP_PLANNING_CODE <> 6
     And    NOT EXISTS
       ( Select 'X'
         From  MTL_ITEM_CATEGORIES Cat
         Where Cat.INVENTORY_ITEM_ID = Item.INVENTORY_ITEM_ID
         And   Cat.ORGANIZATION_ID   = Item.ORGANIZATION_ID
         And   Cat.CATEGORY_SET_ID   = P_Category_Set_Id
       )
     );

Line: 310

     Select STRUCTURE_ID
     Into   Old_Structure_id
     From   MTL_CATEGORY_SETS_B
     WHERE  CATEGORY_SET_ID = (select category_set_id
                                From   MTL_DEFAULT_CATEGORY_SETS
                                Where  FUNCTIONAL_AREA_ID = 5);

Line: 318

     Select STRUCTURE_ID
     Into   New_Structure_id
     From   MTL_CATEGORY_SETS_B
     WHERE  CATEGORY_SET_ID = P_Category_Set_Id;

Line: 325

         /* Select count(*)
          Into   co_Count
          From   Po_Line_Types_b
          where  category_id is NOT NULL
          and rownum < 2;

Line: 332

             Select count(*)
             Into   co_Count
             From   CST_AP_VARIANCE_BATCHES
             where  category_id is NOT NULL
             and rownum < 2;

Line: 339

               Select count(*)
               Into   co_Count
               From   CST_COST_TYPE_HISTORY
               where  category_id is NOT NULL
               and rownum < 2;

Line: 346

                 Select count(*)
                 Into   co_Count
                 From   CST_COST_UPDATES
                 where  category_id is NOT NULL
                 and rownum < 2;

Line: 353

                  Select count(*)
                  Into   co_Count
                  From   CST_ITEM_OVERHEAD_DEFAULTS
                  where  category_id is NOT NULL
                  and rownum < 2;

Line: 360

                    Select count(*)
                    Into   co_Count
                    From   CST_ITEM_OVERHEAD_DEFAULTS_EFC
                    where  category_id is NOT NULL
                    and rownum < 2;

Line: 372

                          l_dyn_sql     := ' Select count(*)                      '||
                                           ' From   CST_MATERIAL_OVHD_RULES       '||
                                           ' where  category_id is NOT NULL       '||
                                           ' and rownum < 2';

Line: 385

                         Select count(*)
                         Into   co_Count
                         From   CST_SC_ROLLUP_HISTORY
                         where  category_id is NOT NULL
                         and rownum < 2;

Line: 404

     Select DISTINCT 'X'
     Into buffer
     From MTL_SYSTEM_ITEMS_B Item
     Where  Item.COSTING_ENABLED_FLAG = 'Y'
     And    NOT EXISTS
       ( Select 'X'
         From  MTL_ITEM_CATEGORIES Cat
         Where Cat.INVENTORY_ITEM_ID = Item.INVENTORY_ITEM_ID
         And   Cat.ORGANIZATION_ID   = Item.ORGANIZATION_ID
         And   Cat.CATEGORY_SET_ID   = P_Category_Set_Id
      );

Line: 438

     Select 'X'
     Into buffer
     FROM dual
     WHERE EXISTS (
     SELECT 'X'
     From MTL_SYSTEM_ITEMS_B Item
     Where  Item.ENG_ITEM_FLAG = 'Y'
     And    NOT EXISTS
       ( Select 'X'
         From  MTL_ITEM_CATEGORIES Cat
         Where Cat.INVENTORY_ITEM_ID = Item.INVENTORY_ITEM_ID
         And   Cat.ORGANIZATION_ID   = Item.ORGANIZATION_ID
         And   Cat.CATEGORY_SET_ID   = P_Category_Set_Id
       )
     );

Line: 471

     Select 'X'
     Into buffer
     FROM dual
     WHERE EXISTS (
     SELECT 'X'
     From MTL_SYSTEM_ITEMS_B Item
     Where  Item.CUSTOMER_ORDER_FLAG = 'Y'
     And    NOT EXISTS
       ( Select 'X'
         From  MTL_ITEM_CATEGORIES Cat
         Where Cat.INVENTORY_ITEM_ID = Item.INVENTORY_ITEM_ID
         And   Cat.ORGANIZATION_ID   = Item.ORGANIZATION_ID
         And   Cat.CATEGORY_SET_ID   = P_Category_Set_Id
       )
     );

Line: 520

      SELECT  DECODE( COUNT(*), 0, 0, -1 )
        INTO  l_count
      FROM  MTL_SYSTEM_ITEMS_B  Item
      WHERE
         Item.EAM_ITEM_TYPE IS NOT NULL
         AND  NOT EXISTS
              ( SELECT 'X'
                FROM  MTL_ITEM_CATEGORIES  Cat
                WHERE
                        Cat.INVENTORY_ITEM_ID = Item.INVENTORY_ITEM_ID
                   AND  Cat.ORGANIZATION_ID   = Item.ORGANIZATION_ID
                   AND  Cat.CATEGORY_SET_ID   = P_Category_Set_Id
              );

Line: 545

      SELECT  DECODE( COUNT(*), 0, 0, -1 )
        INTO  l_count
      FROM  MTL_SYSTEM_ITEMS_B  Item
      WHERE
         Item.CONTRACT_ITEM_TYPE_CODE IN ('SERVICE', 'WARRANTY')
         AND  NOT EXISTS
              ( SELECT 'X'
                FROM  MTL_ITEM_CATEGORIES  Cat
                WHERE
                        Cat.INVENTORY_ITEM_ID = Item.INVENTORY_ITEM_ID
                   AND  Cat.ORGANIZATION_ID   = Item.ORGANIZATION_ID
                   AND  Cat.CATEGORY_SET_ID   = P_Category_Set_Id
              );

Line: 569

      SELECT DECODE( COUNT(*), 0, 0, -1 )
        INTO l_count
      FROM  MTL_SYSTEM_ITEMS_B  Item
      WHERE
         Item.CONTRACT_ITEM_TYPE_CODE IN ('SERVICE', 'WARRANTY', 'SUBSCRIPTION', 'USAGE')
         AND  NOT EXISTS
              ( SELECT 'X'
                FROM  MTL_ITEM_CATEGORIES  Cat
                WHERE
                        Cat.INVENTORY_ITEM_ID = Item.INVENTORY_ITEM_ID
                   AND  Cat.ORGANIZATION_ID   = Item.ORGANIZATION_ID
                   AND  Cat.CATEGORY_SET_ID   = P_Category_Set_Id
              );

Line: 594

     Select 'X'
     Into buffer
     FROM dual
     WHERE EXISTS (
     SELECT 'X'
     From MTL_SYSTEM_ITEMS_B Item
     Where  ( Item.CUSTOMER_ORDER_FLAG = 'Y' OR
              Item.INTERNAL_ORDER_FLAG = 'Y' )
     And    NOT EXISTS
       ( Select 'X'
         From  MTL_ITEM_CATEGORIES Cat
         Where Cat.INVENTORY_ITEM_ID = Item.INVENTORY_ITEM_ID
         And   Cat.ORGANIZATION_ID   = Item.ORGANIZATION_ID
         And   Cat.CATEGORY_SET_ID   = P_Category_Set_Id
       )
     );

Line: 629

        Select 'X'
        Into buffer
        From    MTL_ITEM_CATEGORIES Cat,
                MTL_DEFAULT_CATEGORY_SETS DefCat
        Where DefCat.FUNCTIONAL_AREA_ID   = 12
          And DefCat.CATEGORY_SET_ID  = Cat.CATEGORY_SET_ID
          And NOT EXISTS
               ( Select 'X'
                   From  MTL_ITEM_CATEGORIES Cat1
                  Where   Cat1.INVENTORY_ITEM_ID = Cat.INVENTORY_ITEM_ID
                    And   Cat1.ORGANIZATION_ID   = Cat.ORGANIZATION_ID
                    And   Cat1.CATEGORY_SET_ID   = P_Category_Set_Id
                )
          And rownum=1;

Line: 660

        Select 'X'
        Into buffer
        From    MTL_ITEM_CATEGORIES Cat,
                MTL_DEFAULT_CATEGORY_SETS DefCat
        Where DefCat.FUNCTIONAL_AREA_ID   = 21
          And DefCat.CATEGORY_SET_ID  = Cat.CATEGORY_SET_ID
          And NOT EXISTS
               ( Select 'X'
                   From  MTL_ITEM_CATEGORIES Cat1
                  Where   Cat1.INVENTORY_ITEM_ID = Cat.INVENTORY_ITEM_ID
                    And   Cat1.ORGANIZATION_ID   = Cat.ORGANIZATION_ID
                    And   Cat1.CATEGORY_SET_ID   = P_Category_Set_Id
                )
          And rownum=1;

Line: 693

   SELECT structure_id
     INTO old_structure_id
     FROM mtl_category_sets_b
    WHERE category_set_id = (SELECT category_set_id
                               FROM mtl_default_category_sets
                              WHERE functional_area_id = 19);

Line: 702

   SELECT structure_id
     INTO new_structure_id
     FROM mtl_category_sets_b
    WHERE category_set_id = P_Category_Set_Id;

Line: 709

      SELECT COUNT (*)
        INTO opm_count
        FROM cm_cmpt_mtl
       WHERE cost_category_id IS NOT NULL AND ROWNUM < 2;

Line: 716

         SELECT COUNT (*)
           INTO opm_count
           FROM cm_whse_eff
          WHERE cost_category_id IS NOT NULL AND ROWNUM < 2;

Line: 723

            SELECT COUNT (*)
              INTO opm_count
              FROM cm_whse_src
             WHERE cost_category_id IS NOT NULL AND ROWNUM < 2;

Line: 730

               SELECT COUNT (*)
                 INTO opm_count
                 FROM gmf_burden_percentages
                WHERE cost_category_id IS NOT NULL AND ROWNUM < 2;

Line: 737

                  SELECT COUNT (*)
                    INTO opm_count
                    FROM gmf_lot_costed_items
                   WHERE cost_category_id IS NOT NULL AND ROWNUM < 2;

Line: 752

   SELECT 'X'
     INTO buffer
     FROM DUAL
    WHERE EXISTS
             (SELECT 'X'
                FROM mtl_system_items_b item
               WHERE item.process_costing_enabled_flag = 'Y'
                     AND item.organization_id IN (SELECT ood.organization_id
                                                    FROM org_organization_definitions ood
                                                   WHERE ood.inventory_enabled_flag = 'Y')
                     AND NOT EXISTS
                                (SELECT 'X'
                                   FROM mtl_item_categories cat
                                  WHERE     cat.inventory_item_id = item.inventory_item_id
                                        AND cat.organization_id = item.organization_id
                                        AND cat.category_set_id = P_Category_Set_Id));