VIEW: APPS.IGF_AP_APPL_SETUP_V

Source

View Text - Preformatted

SELECT DISTINCT ias.org_id, ias.ci_cal_type, ias.ci_sequence_number, cal.start_dt, cal.end_dt, cal.alternate_code, ias.application_code, ias.application_name, ias.active_flag From igs_ca_inst cal, igf_ap_appl_setup ias WHERE ias.ci_cal_type = cal.cal_type AND ias.ci_sequence_number = cal.sequence_number

View Text - HTML Formatted

SELECT DISTINCT IAS.ORG_ID
, IAS.CI_CAL_TYPE
, IAS.CI_SEQUENCE_NUMBER
, CAL.START_DT
, CAL.END_DT
, CAL.ALTERNATE_CODE
, IAS.APPLICATION_CODE
, IAS.APPLICATION_NAME
, IAS.ACTIVE_FLAG
FROM IGS_CA_INST CAL
, IGF_AP_APPL_SETUP IAS
WHERE IAS.CI_CAL_TYPE = CAL.CAL_TYPE
AND IAS.CI_SEQUENCE_NUMBER = CAL.SEQUENCE_NUMBER