VIEW: APPS.FND_ID_SEGMENT_NAME_AP_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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