VIEW: APPS.IGS_DA_FTR_VALUES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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