VIEW: APPS.IGS_AD_PERD_AD_CAT_V

Source

View Text - Preformatted

SELECT apac.rowid ROW_ID, apac.adm_cal_type, apac.adm_ci_sequence_number, apac.admission_cat, apac.ci_start_dt, apac.ci_end_dt, apac.created_by, apac.creation_date, apac.last_updated_by, apac.last_update_date, apac.last_update_login, apac.request_id, apac.program_application_id, apac.program_id, apac.program_update_date, ct.description, ci.cal_status, ac.description admission_cat_desc FROM igs_ad_perd_ad_cat apac, igs_ca_inst ci, igs_ca_type ct, igs_ad_cat ac WHERE ( ct.cal_type = apac.adm_cal_type OR ( ct.cal_type IS NULL AND apac.adm_cal_type IS NULL)) AND ci.cal_type = ct.cal_type AND ci.sequence_number = apac.adm_ci_sequence_number AND ac.admission_cat = apac.admission_cat

View Text - HTML Formatted

SELECT APAC.ROWID ROW_ID
, APAC.ADM_CAL_TYPE
, APAC.ADM_CI_SEQUENCE_NUMBER
, APAC.ADMISSION_CAT
, APAC.CI_START_DT
, APAC.CI_END_DT
, APAC.CREATED_BY
, APAC.CREATION_DATE
, APAC.LAST_UPDATED_BY
, APAC.LAST_UPDATE_DATE
, APAC.LAST_UPDATE_LOGIN
, APAC.REQUEST_ID
, APAC.PROGRAM_APPLICATION_ID
, APAC.PROGRAM_ID
, APAC.PROGRAM_UPDATE_DATE
, CT.DESCRIPTION
, CI.CAL_STATUS
, AC.DESCRIPTION ADMISSION_CAT_DESC
FROM IGS_AD_PERD_AD_CAT APAC
, IGS_CA_INST CI
, IGS_CA_TYPE CT
, IGS_AD_CAT AC
WHERE ( CT.CAL_TYPE = APAC.ADM_CAL_TYPE OR ( CT.CAL_TYPE IS NULL
AND APAC.ADM_CAL_TYPE IS NULL))
AND CI.CAL_TYPE = CT.CAL_TYPE
AND CI.SEQUENCE_NUMBER = APAC.ADM_CI_SEQUENCE_NUMBER
AND AC.ADMISSION_CAT = APAC.ADMISSION_CAT