2230: SELECT
2231: NVL(d.category_desc, category_concat_segs) categoryName
2232: FROM
2233: mtl_default_category_sets a ,
2234: mtl_category_sets_b b ,
2235: mtl_categories_v c ,
2236: ENI_PROD_DEN_HRCHY_PARENTS_V d
2237: WHERE
2238: a.functional_area_id in (7,11)
2324: SELECT
2325: NVL(d.concat_cat_parentage, c.description) categoryDescr
2326: FROM
2327: mtl_default_category_sets a ,
2328: mtl_category_sets_b b ,
2329: mtl_categories_v c ,
2330: ENI_PROD_DEN_HRCHY_PARENTS_V d
2331: WHERE
2332: a.functional_area_id in (7,11)