[Home] [Help]
View: IGS_FI_ACCT_SEGS_V
Product: | IGS - Student System (Obsolete) |
Description: | View to display Account Segments. |
Implementation/DBA Data: |
Not implemented in this database
|
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
Name |
SEGMENT |
SEGMENT_NAME |
SEGMENT_NUM |
FLEX_VALUE_SET_ID |
VALIDATION_TYPE |
DISPLAY_FLAG |
INDEPENDENT_SEGMENT_NUM |