VIEW: APPS.IGS_DA_FTR_VAL_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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