VIEW: APPS.IGS_AD_APPL_INST_MKDES_V

Source

View Text - Preformatted

SELECT apaiav.person_id person_id, apaiav.nominated_course_cd nominated_course_cd, apaiav.sequence_number sequence_number, apaiav.admission_appl_number admission_appl_number, apaiav.acad_cal_type acad_cal_type, apaiav.acad_ci_sequence_number acad_ci_sequence_number, apaiav.adm_cal_type adm_cal_type, apaiav.adm_ci_sequence_number adm_ci_sequence_number, ciapv.acad_alternate_code acad_alternate_code, ciapv.adm_alternate_code adm_alternate_code, aa.admission_cat admission_cat, aa.s_admission_process_type s_admission_process_type, lkupv.meaning s_adm_prcs_type_desc, aa.adm_appl_status adm_appl_status, aa.appl_dt appl_dt, aa.adm_fee_status adm_fee_status, apaiav.adm_doc_status adm_doc_status, apaiav.academic_index academic_index, apaiav.adm_entry_qual_status adm_entry_qual_status, apaiav.predicted_gpa predicted_gpa, apaiav.crv_version_number crv_version_number, apaiav.course_title_display course_title_display, apaiav.location_cd location_cd, apaiav.attendance_mode attendance_mode, apaiav.attendance_type attendance_type, apaiav.unit_set_cd unit_set_cd, apaiav.us_version_number us_version_number, apaiav.expected_completion_yr expected_completion_yr, apaiav.course_rank_set course_rank_set, apaiav.course_rank_schedule course_rank_schedule, apaiav.admission_cd admission_cd, ac.description admission_cd_desc, apaiav.basis_for_admission_type basis_for_admission_type, abfa.description basis_for_admission_type_desc FROM igs_ad_ps_appl_inst_aplinst_v apaiav, igs_ca_inst_adm_perd_v ciapv, igs_ad_appl aa, igs_ad_cd ac, igs_ad_basis_for_ad abfa, igs_lookup_values lkupv WHERE /* Joining the application instance view and calendar relation view */ apaiav.acad_cal_type = ciapv.acad_cal_type AND apaiav.acad_ci_sequence_number = ciapv.acad_ci_sequence_number AND apaiav.adm_cal_type = ciapv.adm_cal_type AND apaiav.adm_ci_sequence_number = ciapv.adm_ci_sequence_number AND /* Joining the application instance view and application session details view */ apaiav.person_id = aa.person_id AND apaiav.admission_appl_number = aa.admission_appl_number AND /* Joining the application instance view and admission code table */ apaiav.admission_cd = ac.admission_cd (+) AND /* Joining the application instance view and Basis for Admission type table */ apaiav.basis_for_admission_type = abfa.basis_for_admission_type (+) AND lkupv.lookup_code (+) = aa.s_admission_process_type AND lkupv.lookup_type (+) = 'ADMISSION_PROCESS_TYPE'

View Text - HTML Formatted

SELECT APAIAV.PERSON_ID PERSON_ID
, APAIAV.NOMINATED_COURSE_CD NOMINATED_COURSE_CD
, APAIAV.SEQUENCE_NUMBER SEQUENCE_NUMBER
, APAIAV.ADMISSION_APPL_NUMBER ADMISSION_APPL_NUMBER
, APAIAV.ACAD_CAL_TYPE ACAD_CAL_TYPE
, APAIAV.ACAD_CI_SEQUENCE_NUMBER ACAD_CI_SEQUENCE_NUMBER
, APAIAV.ADM_CAL_TYPE ADM_CAL_TYPE
, APAIAV.ADM_CI_SEQUENCE_NUMBER ADM_CI_SEQUENCE_NUMBER
, CIAPV.ACAD_ALTERNATE_CODE ACAD_ALTERNATE_CODE
, CIAPV.ADM_ALTERNATE_CODE ADM_ALTERNATE_CODE
, AA.ADMISSION_CAT ADMISSION_CAT
, AA.S_ADMISSION_PROCESS_TYPE S_ADMISSION_PROCESS_TYPE
, LKUPV.MEANING S_ADM_PRCS_TYPE_DESC
, AA.ADM_APPL_STATUS ADM_APPL_STATUS
, AA.APPL_DT APPL_DT
, AA.ADM_FEE_STATUS ADM_FEE_STATUS
, APAIAV.ADM_DOC_STATUS ADM_DOC_STATUS
, APAIAV.ACADEMIC_INDEX ACADEMIC_INDEX
, APAIAV.ADM_ENTRY_QUAL_STATUS ADM_ENTRY_QUAL_STATUS
, APAIAV.PREDICTED_GPA PREDICTED_GPA
, APAIAV.CRV_VERSION_NUMBER CRV_VERSION_NUMBER
, APAIAV.COURSE_TITLE_DISPLAY COURSE_TITLE_DISPLAY
, APAIAV.LOCATION_CD LOCATION_CD
, APAIAV.ATTENDANCE_MODE ATTENDANCE_MODE
, APAIAV.ATTENDANCE_TYPE ATTENDANCE_TYPE
, APAIAV.UNIT_SET_CD UNIT_SET_CD
, APAIAV.US_VERSION_NUMBER US_VERSION_NUMBER
, APAIAV.EXPECTED_COMPLETION_YR EXPECTED_COMPLETION_YR
, APAIAV.COURSE_RANK_SET COURSE_RANK_SET
, APAIAV.COURSE_RANK_SCHEDULE COURSE_RANK_SCHEDULE
, APAIAV.ADMISSION_CD ADMISSION_CD
, AC.DESCRIPTION ADMISSION_CD_DESC
, APAIAV.BASIS_FOR_ADMISSION_TYPE BASIS_FOR_ADMISSION_TYPE
, ABFA.DESCRIPTION BASIS_FOR_ADMISSION_TYPE_DESC
FROM IGS_AD_PS_APPL_INST_APLINST_V APAIAV
, IGS_CA_INST_ADM_PERD_V CIAPV
, IGS_AD_APPL AA
, IGS_AD_CD AC
, IGS_AD_BASIS_FOR_AD ABFA
, IGS_LOOKUP_VALUES LKUPV
WHERE /* JOINING THE APPLICATION INSTANCE VIEW
AND CALENDAR RELATION VIEW */ APAIAV.ACAD_CAL_TYPE = CIAPV.ACAD_CAL_TYPE
AND APAIAV.ACAD_CI_SEQUENCE_NUMBER = CIAPV.ACAD_CI_SEQUENCE_NUMBER
AND APAIAV.ADM_CAL_TYPE = CIAPV.ADM_CAL_TYPE
AND APAIAV.ADM_CI_SEQUENCE_NUMBER = CIAPV.ADM_CI_SEQUENCE_NUMBER
AND /* JOINING THE APPLICATION INSTANCE VIEW
AND APPLICATION SESSION DETAILS VIEW */ APAIAV.PERSON_ID = AA.PERSON_ID
AND APAIAV.ADMISSION_APPL_NUMBER = AA.ADMISSION_APPL_NUMBER
AND /* JOINING THE APPLICATION INSTANCE VIEW
AND ADMISSION CODE TABLE */ APAIAV.ADMISSION_CD = AC.ADMISSION_CD (+)
AND /* JOINING THE APPLICATION INSTANCE VIEW
AND BASIS FOR ADMISSION TYPE TABLE */ APAIAV.BASIS_FOR_ADMISSION_TYPE = ABFA.BASIS_FOR_ADMISSION_TYPE (+)
AND LKUPV.LOOKUP_CODE (+) = AA.S_ADMISSION_PROCESS_TYPE
AND LKUPV.LOOKUP_TYPE (+) = 'ADMISSION_PROCESS_TYPE'