View: FND_ID_SEGMENT_NAME_AP_V

Product:	AP - Payables
Description:	(Release 10SC Only)
Implementation/DBA Data:	APPS.FND_ID_SEGMENT_NAME_AP_V

View Text

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

Columns