VIEW: APPS.IGS_DA_REQ_FTRS_V

Source

View Text - Preformatted

SELECT drf.rowid, drf.batch_id, drf.feature_code, lkv1.meaning, drf.feature_value, (select FEATURE_VALUE_MEANING from igs_da_ftr_values fva where fva.feature_code = drf.feature_code and fva.FEATURE_VALUE = drf.FEATURE_VALUE UNION select drf.FEATURE_VALUE from igs_da_cnfg_ftr dac1 WHERE drf.feature_code IN ('DAT','TIM') ) feature_value_meaning, drf.creation_date, drf.created_by, drf.last_update_login, drf.last_updated_by, drf.last_update_date FROM igs_da_req_ftrs drf, igs_da_ftr_val_map dfvm, igs_lookup_values lkv1 WHERE drf.feature_code = dfvm.feature_code AND lkv1.lookup_type = 'IGS_DA_RQST_FEATURES' AND lkv1.lookup_code = drf.feature_code

View Text - HTML Formatted

SELECT DRF.ROWID
, DRF.BATCH_ID
, DRF.FEATURE_CODE
, LKV1.MEANING
, DRF.FEATURE_VALUE
, (SELECT FEATURE_VALUE_MEANING
FROM IGS_DA_FTR_VALUES FVA
WHERE FVA.FEATURE_CODE = DRF.FEATURE_CODE
AND FVA.FEATURE_VALUE = DRF.FEATURE_VALUE UNION SELECT DRF.FEATURE_VALUE
FROM IGS_DA_CNFG_FTR DAC1
WHERE DRF.FEATURE_CODE IN ('DAT'
, 'TIM') ) FEATURE_VALUE_MEANING
, DRF.CREATION_DATE
, DRF.CREATED_BY
, DRF.LAST_UPDATE_LOGIN
, DRF.LAST_UPDATED_BY
, DRF.LAST_UPDATE_DATE
FROM IGS_DA_REQ_FTRS DRF
, IGS_DA_FTR_VAL_MAP DFVM
, IGS_LOOKUP_VALUES LKV1
WHERE DRF.FEATURE_CODE = DFVM.FEATURE_CODE
AND LKV1.LOOKUP_TYPE = 'IGS_DA_RQST_FEATURES'
AND LKV1.LOOKUP_CODE = DRF.FEATURE_CODE