VIEW: APPS.IGS_DA_CNFG_FTR_V

Source

View Text - Preformatted

SELECT dac.rowid row_id , dac.REQUEST_TYPE_ID , dac.CONFIGURE_FLAG , dac.DISPLAY_FLAG , dac.FEATURE_VALUE , (select FEATURE_VALUE_MEANING from igs_da_ftr_values fva WHERE fva.feature_code = dac.feature_code and fva.FEATURE_VALUE = dac.FEATURE_VALUE UNION select dac.FEATURE_VALUE from igs_da_cnfg_ftr dac1 WHERE dac.feature_code IN ('DAT','TIM') ) feature_value_meaning , dac.FORCE_VALUE_FLAG , dac.DEFAULT_VALUE_FLAG , dac.CREATION_DATE , dac.CREATED_BY , dac.LAST_UPDATE_LOGIN , dac.LAST_UPDATED_BY , dac.LAST_UPDATE_DATE , dac.FEATURE_CODE , lkup1.meaning feature_code_meaning , frt.TRANSFER_EVALUATION_IND FROM igs_da_cnfg_ftr dac, igs_lookup_values lkup1, igs_da_ftr_val_map frt WHERE lkup1.lookup_type = 'IGS_DA_RQST_FEATURES' AND dac.FEATURE_CODE = lkup1.lookup_code AND frt.FEATURE_CODE = dac.FEATURE_CODE

View Text - HTML Formatted

SELECT DAC.ROWID ROW_ID
, DAC.REQUEST_TYPE_ID
, DAC.CONFIGURE_FLAG
, DAC.DISPLAY_FLAG
, DAC.FEATURE_VALUE
, (SELECT FEATURE_VALUE_MEANING
FROM IGS_DA_FTR_VALUES FVA
WHERE FVA.FEATURE_CODE = DAC.FEATURE_CODE
AND FVA.FEATURE_VALUE = DAC.FEATURE_VALUE UNION SELECT DAC.FEATURE_VALUE
FROM IGS_DA_CNFG_FTR DAC1
WHERE DAC.FEATURE_CODE IN ('DAT'
, 'TIM') ) FEATURE_VALUE_MEANING
, DAC.FORCE_VALUE_FLAG
, DAC.DEFAULT_VALUE_FLAG
, DAC.CREATION_DATE
, DAC.CREATED_BY
, DAC.LAST_UPDATE_LOGIN
, DAC.LAST_UPDATED_BY
, DAC.LAST_UPDATE_DATE
, DAC.FEATURE_CODE
, LKUP1.MEANING FEATURE_CODE_MEANING
, FRT.TRANSFER_EVALUATION_IND
FROM IGS_DA_CNFG_FTR DAC
, IGS_LOOKUP_VALUES LKUP1
, IGS_DA_FTR_VAL_MAP FRT
WHERE LKUP1.LOOKUP_TYPE = 'IGS_DA_RQST_FEATURES'
AND DAC.FEATURE_CODE = LKUP1.LOOKUP_CODE
AND FRT.FEATURE_CODE = DAC.FEATURE_CODE