APPS.EGO_CATG_MAP_UTIL_PKG SQL Statements

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

Line: 20

   SELECT
         catg_map_id, target_catg_id
   FROM EGO_CATG_MAP_DTLS
   WHERE source_catg_id = cp_category_id
   AND ROWNUM = 1;

Line: 29

   SELECT
         target_catg_set_id
   FROM EGO_CATG_MAP_HDRS_B
   WHERE catg_map_id = cp_catg_map_id;*/

Line: 39

   SELECT
         target_catg_id,target_catg_set_id
   FROM EGO_CATG_MAP_DTLS det, EGO_CATG_MAP_HDRS_B hdr
   WHERE det.catg_map_id = hdr.catg_map_id
   AND source_catg_id = cp_category_id
   AND ENABLED_FLAG = 'Y'
   AND ROWNUM = 1;

Line: 60

/*Bug 7184385, changed select to get correct category_id passed a gpc_id */
select mck.category_id into l_category_id
from mtl_categories_kfv mck,
mtl_category_sets mcs,
mtl_default_category_sets_fk_v mdcs
where mdcs.functional_area_id = 21
and mdcs.category_set_id = mcs.category_set_id
and mcs.structure_id = mck.structure_id
and mck.segment2 = to_char(p_gpc_id);

Line: 97

   SELECT
         target_catg_id
   FROM EGO_CATG_MAP_DTLS det, EGO_CATG_MAP_HDRS_B hdr
   WHERE det.catg_map_id = hdr.catg_map_id
   AND source_catg_id = cp_category_id
   AND target_catg_set_id = -1
   AND ENABLED_FLAG = 'Y'
   AND ROWNUM = 1;

Line: 108

   SELECT CATEGORY_ID
   INTO l_category_id
   FROM mtl_categories_kfv
   WHERE SEGMENT2 = P_GPC_ID
   AND ROWNUM = 1;