View: IGS_FI_ACCT_SEGS_V

Product:	IGS - Student System
Description:	View to display Account Segments.
Implementation/DBA Data:	APPS.IGS_FI_ACCT_SEGS_V

View Text

SELECT FIFS.APPLICATION_COLUMN_NAME
, FIFS.SEGMENT_NAME
, FIFS.SEGMENT_NUM
, FIFS.FLEX_VALUE_SET_ID
, FFVS.VALIDATION_TYPE
, FIFS.DISPLAY_FLAG
, FIFSD.SEGMENT_NUM
FROM FND_ID_FLEX_SEGMENTS FIFS
, FND_FLEX_VALUE_SETS FFVS
, FND_ID_FLEX_SEGMENTS FIFSD
, FND_FLEX_VALUE_SETS FFVSD
, FND_APPLICATION FAPP
WHERE FAPP.APPLICATION_SHORT_NAME = 'SQLGL'
AND FIFS.APPLICATION_ID = FAPP.APPLICATION_ID
AND FIFSD.APPLICATION_ID = FAPP.APPLICATION_ID AND FIFS.ID_FLEX_CODE = 'GL#'
AND FIFS.ENABLED_FLAG = 'Y'
AND FIFS.ID_FLEX_NUM = IGS_FI_GEN_007.GET_COA_ID
AND FFVS.FLEX_VALUE_SET_ID = FIFS.FLEX_VALUE_SET_ID
AND FFVS.VALIDATION_TYPE = 'D'
AND FFVS.PARENT_FLEX_VALUE_SET_ID = FFVSD.FLEX_VALUE_SET_ID
AND FIFS.ID_FLEX_CODE = FIFSD.ID_FLEX_CODE
AND FIFS.ID_FLEX_NUM = FIFSD.ID_FLEX_NUM
AND FFVSD.FLEX_VALUE_SET_ID = FIFSD.FLEX_VALUE_SET_ID UNION ALL SELECT FIFS.APPLICATION_COLUMN_NAME
, FIFS.SEGMENT_NAME
, FIFS.SEGMENT_NUM
, FIFS.FLEX_VALUE_SET_ID
, FFVS.VALIDATION_TYPE
, FIFS.DISPLAY_FLAG
, TO_NUMBER(NULL)
FROM FND_ID_FLEX_SEGMENTS FIFS
, FND_FLEX_VALUE_SETS FFVS
, FND_ID_FLEX_SEGMENTS FIFSD
, FND_FLEX_VALUE_SETS FFVSD
, FND_APPLICATION FAPP
WHERE FAPP.APPLICATION_SHORT_NAME = 'SQLGL'
AND FIFS.APPLICATION_ID = FAPP.APPLICATION_ID
AND FIFSD.APPLICATION_ID = FAPP.APPLICATION_ID AND FIFS.ID_FLEX_CODE = 'GL#'
AND FIFS.ENABLED_FLAG = 'Y'
AND FIFS.ID_FLEX_NUM = IGS_FI_GEN_007.GET_COA_ID
AND FFVS.FLEX_VALUE_SET_ID = FIFS.FLEX_VALUE_SET_ID
AND FFVS.VALIDATION_TYPE <> 'D'
AND FIFSD.FLEX_VALUE_SET_ID = FFVSD.FLEX_VALUE_SET_ID
AND FFVS.FLEX_VALUE_SET_ID = FFVSD.FLEX_VALUE_SET_ID
AND FIFS.ID_FLEX_CODE = FIFSD.ID_FLEX_CODE
AND FIFS.ID_FLEX_NUM = FIFSD.ID_FLEX_NUM
AND FIFS.SEGMENT_NUM = FIFSD.SEGMENT_NUM

Columns