VIEW: APPS.IGS_AD_SESSION_DTL_V

Source

View Text - Preformatted

SELECT pepref.row_id, pepref.person_id, pepref.adm_acad_cal_type, cta.description, pepref.adm_acad_ci_sequence_number, cia.alternate_code, cia.start_dt, cia.end_dt, pepref.adm_admission_cat, apcv.ac_description, pepref.adm_s_admission_process_type, apcv.sapt_description, pepref.adm_adm_cal_type, ctb.description, pepref.adm_adm_ci_sequence_number, cib.alternate_code, cib.start_dt, cib.end_dt, pepref.enr_acad_cal_type, pepref.enr_acad_sequence_number, pepref.enr_enrolment_cat, pepref.enr_enr_method_type, pepref.enq_acad_cal_type, pepref.enq_acad_ci_sequence_number, pepref.enq_adm_cal_type, pepref.enq_adm_ci_sequence_number, pepref.server_printer_dflt, pepref.allow_stnd_req_ind, pepref.created_by, pepref.creation_date, pepref.last_updated_by, pepref.last_update_date, pepref.last_update_login FROM igs_pe_pers_prefs pepref, igs_ca_inst cia, igs_ca_type cta, igs_ca_inst cib, igs_ca_type ctb, igs_ad_prcs_cat_admprcs_v apcv WHERE pepref.adm_acad_cal_type = cia.cal_type (+) AND pepref.adm_acad_ci_sequence_number = cia.sequence_number (+) AND pepref.adm_acad_cal_type = cta.cal_type (+) AND pepref.adm_admission_cat = apcv.admission_cat (+) AND pepref.adm_s_admission_process_type = apcv.s_admission_process_type (+) AND pepref.adm_adm_cal_type = cib.cal_type (+) AND pepref.adm_adm_cal_type = ctb.cal_type (+) AND pepref.adm_adm_ci_sequence_number = cib.sequence_number (+)

View Text - HTML Formatted

SELECT PEPREF.ROW_ID
, PEPREF.PERSON_ID
, PEPREF.ADM_ACAD_CAL_TYPE
, CTA.DESCRIPTION
, PEPREF.ADM_ACAD_CI_SEQUENCE_NUMBER
, CIA.ALTERNATE_CODE
, CIA.START_DT
, CIA.END_DT
, PEPREF.ADM_ADMISSION_CAT
, APCV.AC_DESCRIPTION
, PEPREF.ADM_S_ADMISSION_PROCESS_TYPE
, APCV.SAPT_DESCRIPTION
, PEPREF.ADM_ADM_CAL_TYPE
, CTB.DESCRIPTION
, PEPREF.ADM_ADM_CI_SEQUENCE_NUMBER
, CIB.ALTERNATE_CODE
, CIB.START_DT
, CIB.END_DT
, PEPREF.ENR_ACAD_CAL_TYPE
, PEPREF.ENR_ACAD_SEQUENCE_NUMBER
, PEPREF.ENR_ENROLMENT_CAT
, PEPREF.ENR_ENR_METHOD_TYPE
, PEPREF.ENQ_ACAD_CAL_TYPE
, PEPREF.ENQ_ACAD_CI_SEQUENCE_NUMBER
, PEPREF.ENQ_ADM_CAL_TYPE
, PEPREF.ENQ_ADM_CI_SEQUENCE_NUMBER
, PEPREF.SERVER_PRINTER_DFLT
, PEPREF.ALLOW_STND_REQ_IND
, PEPREF.CREATED_BY
, PEPREF.CREATION_DATE
, PEPREF.LAST_UPDATED_BY
, PEPREF.LAST_UPDATE_DATE
, PEPREF.LAST_UPDATE_LOGIN
FROM IGS_PE_PERS_PREFS PEPREF
, IGS_CA_INST CIA
, IGS_CA_TYPE CTA
, IGS_CA_INST CIB
, IGS_CA_TYPE CTB
, IGS_AD_PRCS_CAT_ADMPRCS_V APCV
WHERE PEPREF.ADM_ACAD_CAL_TYPE = CIA.CAL_TYPE (+)
AND PEPREF.ADM_ACAD_CI_SEQUENCE_NUMBER = CIA.SEQUENCE_NUMBER (+)
AND PEPREF.ADM_ACAD_CAL_TYPE = CTA.CAL_TYPE (+)
AND PEPREF.ADM_ADMISSION_CAT = APCV.ADMISSION_CAT (+)
AND PEPREF.ADM_S_ADMISSION_PROCESS_TYPE = APCV.S_ADMISSION_PROCESS_TYPE (+)
AND PEPREF.ADM_ADM_CAL_TYPE = CIB.CAL_TYPE (+)
AND PEPREF.ADM_ADM_CAL_TYPE = CTB.CAL_TYPE (+)
AND PEPREF.ADM_ADM_CI_SEQUENCE_NUMBER = CIB.SEQUENCE_NUMBER (+)