This view is to be created so that all information about all the feature values that have been defined for the features defined
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT F1.MEANING FEATURE_VALUE_DESC , F1.LOOKUP_CODE FEATURE_VALUE , FVM.FEATURE_CODE FEATURE_NAME FROM IGS_LOOKUPS_VIEW 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 != 'LOV' UNION SELECT ID.ORG_ALTERNATE_ID , ID.ORG_ALTERNATE_ID , FVM.FEATURE_CODE FROM IGS_OR_ORG_ALT_IDS ID , IGS_OR_ORG_ALT_IDTYP TY , IGS_DA_FTR_VAL_MAP FVM WHERE ID.ORG_ALTERNATE_ID_TYPE = TY.ORG_ALTERNATE_ID_TYPE AND FVM.FEATURE_CODE IN ('EOA' , 'RAA') AND ID.ORG_ALTERNATE_ID_TYPE = FND_PROFILE.VALUE('IGS_DA_INST_ALT_ID_TYPE') AND TY.INST_FLAG = 'Y' AND ID.START_DATE <= SYSDATE AND NVL(ID.END_DATE , SYSDATE) >= SYSDATE UNION SELECT ID.NAME , ID.INSTITUTION_CD , FVM.FEATURE_CODE FROM IGS_OR_INSTITUTION_V ID , IGS_DA_FTR_VAL_MAP FVM WHERE ID.INSTITUTION_STATUS = 'ACTIVE' AND FVM.FEATURE_CODE IN ('EOI' , 'RAI') UNION SELECT IA.DESCRIPTION , IA.ALTERNATE_CODE , 'RAY' FROM IGS_CA_INST_ALL IA , IGS_CA_TYPE CT , IGS_CA_STAT CS WHERE 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 SELECT UNIQUE LOCATION , SITE_USE_TYPE , 'PAO' FROM IGS_PE_PARTYSITEUSE_V
[Home] [Help]