SELECT to_char(MCSV.category_id) , MCSV.category_concat_segments FROM mtl_category_set_valid_cats_v MCSV , mtl_default_category_sets_fk_v MDCS WHERE MCSV.category_set_id=MDCS.category_set_id AND MDCS.functional_area_id=7
View Text - HTML Formatted
SELECT TO_CHAR(MCSV.CATEGORY_ID) , MCSV.CATEGORY_CONCAT_SEGMENTS FROM MTL_CATEGORY_SET_VALID_CATS_V MCSV , MTL_DEFAULT_CATEGORY_SETS_FK_V MDCS WHERE MCSV.CATEGORY_SET_ID=MDCS.CATEGORY_SET_ID AND MDCS.FUNCTIONAL_AREA_ID=7