View - FND_ID_SEGMENT_NAME_AP_V

 SELECT A.SEGMENT_NAME SEGMENT_NAME

, COUNT(*) SEGMENT_NUM
FROM FND_ID_FLEX_SEGMENTS A
, FND_ID_FLEX_SEGMENTS B
WHERE A.ENABLED_FLAG = 'Y'
AND B.ENABLED_FLAG = A.ENABLED_FLAG