VIEW: APPS.IGS_FI_ACCT_SEGS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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