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 AND A.ID_FLEX_CODE = B.ID_FLEX_CODE AND A.ID_FLEX_NUM = B.ID_FLEX_NUM AND A.SEGMENT_NUM >= B.SEGMENT_NUM AND A.ID_FLEX_CODE = 'GL#' AND A.ID_FLEX_NUM = (SELECT GL.CHART_OF_ACCOUNTS_ID FROM GL_SETS_OF_BOOKS GL , AP_SYSTEM_PARAMETERS AP WHERE GL.SET_OF_BOOKS_ID = AP.SET_OF_BOOKS_ID) GROUP BY A.ID_FLEX_CODE , A.ID_FLEX_NUM , A.SEGMENT_NAME