APPS.PO_CATEGORIES_SV1 SQL Statements

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

Line: 24

   SELECT count(*)
     INTO x_temp
     FROM mtl_item_categories mic,
          mtl_categories mcs
    WHERE mic.category_id = mcs.category_id
      AND mic.category_set_id = (SELECT category_set_id
                                   FROM mtl_default_category_sets
                                  WHERE functional_area_id = 2 /* 2=purchasing*/)
      AND mic.category_id = x_category_id
      AND mic.inventory_item_id = x_item_id
      AND mic.organization_id = x_organization_id
      AND sysdate < nvl(mcs.disable_date, sysdate+1)
      AND mcs.enabled_flag = 'Y';

Line: 77

 SELECT category_id
   INTO X_category_id_v
   FROM mtl_categories_kfv mck, mtl_category_sets mcs, mtl_default_category_sets mdcs
  WHERE concatenated_segments = X_category
    AND mck.structure_id = mcs.structure_id
    AND mcs.category_set_id = mdcs.category_set_id
    AND mdcs.functional_area_id = 2;

Line: 90

   select structure_id
   into   x_structure_id
   from   mtl_default_category_sets mdcs,mtl_category_sets_b mcsb
   where  mdcs.functional_area_id = 2  /* 2 = Purchasing */
   and    mdcs.category_set_id = mcsb.category_set_id;

Line: 131

   SELECT	 mcs.default_category_id
   INTO		 X_category_id
   FROM		 mtl_category_sets mcs,
		 mtl_default_category_sets mdcs
   WHERE	 mdcs.functional_area_id = 2  /* 2= purchasing */
   AND		 mdcs.category_set_id = mcs.category_set_id;

Line: 174

     SELECT validate_flag
     INTO x_validate_flag
     FROM mtl_category_sets_v
     WHERE category_set_id=
                (SELECT   category_set_id
                 FROM     mtl_default_category_sets
                 WHERE    functional_area_id = 2   /*** purchasing ***/
                ) ;

Line: 189

     SELECT count(*)
     INTO x_temp
     FROM mtl_categories_vl mcs,
          mtl_category_set_valid_cats mcsvc
    WHERE mcs.category_id = x_category_id
      AND mcs.category_id = mcsvc.category_id
      AND mcsvc.category_set_id =
                (SELECT   category_set_id
                 FROM     mtl_default_category_sets
                 WHERE    functional_area_id = 2   /*** purchasing ***/
                )
      AND sysdate < nvl(mcs.disable_date, sysdate+1)
      AND mcs.enabled_flag = 'Y';

Line: 211

     SELECT count(*)
     INTO x_temp
     FROM mtl_categories_vl mcs
    WHERE mcs.category_id = x_category_id
      AND sysdate < nvl(mcs.disable_date, sysdate+1)
      AND mcs.enabled_flag = 'Y';