Query : Get assets category list

SELECT FCB.category_id, fcb.SEGMENT1 "Major", fcb.SEGMENT2 "Minor",fct.DESCRIPTION
FROM APPS.FA_CATEGORIES_b FCB, APPS.FA_CATEGORIES_TL FCT
WHERE FCT.CATEGORY_ID=FCB.CATEGORY_ID
AND FCB.ENABLED_FLAG='Y'


Or use this:

SELECT parent_flex_value_low "Major",flex_value "Minor", enabled_flag, start_date_active, end_date_active
FROM fnd_flex_value_sets ffvs
, fnd_flex_values_vl ffv
WHERE ffvs.flex_value_set_id = ffv.flex_value_set_id
AND ffvs.flex_value_set_name =
and enabled_flaG='Y'
AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE-1) AND NVL(END_dATE_aCTIVE,SYSDATE+1)