--Major Category --
SELECT fc.segment1,(SELECT
ffvt.description
FROM fnd_flex_value_sets ffvs ,
fnd_flex_values ffv ,
fnd_flex_values_tl ffvt
WHERE
ffvs.flex_value_set_id = ffv.flex_value_set_id
and ffv.flex_value_id = ffvt.flex_value_id
AND ffvt.language = USERENV('LANG')
AND ffvs.flex_value_set_name='FA_MAJOR_CATEGORY_VS' --Enter Major Category Value Set Name
AND ffv.flex_value=fc.segment1) DESC
FROM fa_categories_vl
--Minor Category--
SELECT fc.segment1,(SELECT
ffvt.description
FROM fnd_flex_value_sets ffvs ,
fnd_flex_values ffv ,
fnd_flex_values_tl ffvt
WHERE
ffvs.flex_value_set_id = ffv.flex_value_set_id
and ffv.flex_value_id = ffvt.flex_value_id
AND ffvt.language = USERENV('LANG')
AND ffvs.flex_value_set_name='FA_MAJOR_CATEGORY_VS' --Enter Minor Category Value Set Name
AND ffv.flex_value=fc.segment2) DESC
FROM fa_categories_vl