View: IGS_DA_FTR_VALUES

View Text

SELECT F1.MEANING FEATURE_VALUE_MEANING
, F1.LOOKUP_CODE FEATURE_VALUE
, FVM.FEATURE_CODE FEATURE_CODE
, FVM.TRANSFER_EVALUATION_IND TRANSFER_EVALUATION_IND
, FVM.FEATURE_VAL_TYPE FEATURE_VAL_TYPE
FROM FND_LOOKUP_VALUES_VL F1
, IGS_DA_FTR_VAL_MAP FVM
WHERE FVM.FEATURE_VAL_TYPE = F1.LOOKUP_TYPE
AND SYSDATE <= NVL (F1.END_DATE_ACTIVE
, SYSDATE)
AND FVM.FEATURE_VAL_TYPE NOT IN ('LOV'
, 'DATE_PICKER'
, 'TEXT_FIELD')
AND F1.VIEW_APPLICATION_ID = 8405
AND F1.LOOKUP_TYPE IN ( 'IGS_DA_RQST_TYPE'
, 'IGS_DA_COM_OVRIDES'
, 'IGS_DA_DPMASKS'
, 'IGS_DA_EVAL_TRANS_UNTS'
, 'IGS_DA_LINE_TYPE'
, 'IGS_DA_PROD_DMPS'
, 'IGS_DA_REF_ARTICS'
, 'IGS_DA_RPT_FORMAT'
, 'IGS_DA_RPT_SIZES'
, 'IGS_DA_SRVR_NAMES'
, 'YES_NO'
, 'IGS_DA_PROD_RPTS' ) UNION ALL SELECT HP.PARTY_NAME
, HP.PARTY_NUMBER
, FVM.FEATURE_CODE
, FVM.TRANSFER_EVALUATION_IND
, FVM.FEATURE_VAL_TYPE
FROM HZ_PARTIES HP
, IGS_PE_HZ_PARTIES IHP
, IGS_DA_FTR_VAL_MAP FVM
WHERE FVM.FEATURE_CODE IN ('EOI'
, 'RAI')
AND HP.PARTY_ID = IHP.PARTY_ID
AND IHP.INST_ORG_IND = 'I'
AND IHP.OI_INSTITUTION_STATUS = 'ACTIVE' UNION ALL SELECT IA.DESCRIPTION
, IA.ALTERNATE_CODE
, FVM.FEATURE_CODE
, FVM.TRANSFER_EVALUATION_IND
, FVM.FEATURE_VAL_TYPE
FROM IGS_DA_FTR_VAL_MAP FVM
, IGS_CA_INST_ALL IA
, IGS_CA_TYPE CT
, IGS_CA_STAT CS
WHERE FVM.FEATURE_CODE IN ('RAY'
, 'TRM')
AND IA.CAL_TYPE = CT.CAL_TYPE
AND CT.S_CAL_CAT = 'LOAD'
AND IA.CAL_STATUS = CS.CAL_STATUS
AND CS.S_CAL_STATUS = 'ACTIVE'
AND IA.ALTERNATE_CODE IS NOT NULL UNION ALL SELECT UNIQUE FL.MEANING
, FL.LOOKUP_CODE
, FVM.FEATURE_CODE
, FVM.TRANSFER_EVALUATION_IND
, FVM.FEATURE_VAL_TYPE
FROM IGS_DA_FTR_VAL_MAP FVM
, FND_LOOKUP_VALUES_VL FL
, HZ_PARTY_SITE_USES PSU
WHERE FVM.FEATURE_CODE = 'PAO'
AND FL.LOOKUP_TYPE = 'PARTY_SITE_USE_CODE'
AND FL.VIEW_APPLICATION_ID = 222
AND FL.SECURITY_GROUP_ID = 0
AND PSU.SITE_USE_TYPE = FL.LOOKUP_CODE

Columns