VIEW: APPS.IGS_AD_APPL_ADMAPPL_V

Source

View Text - Preformatted

SELECT aa.ROWID row_id, aa.person_id person_id, p.party_number person_number, p.person_last_name || ',  ' || p.person_title || '  ' || NVL (p.known_as, p.person_first_name) dsp_context_block_name, aa.admission_appl_number admission_appl_number, aa.appl_dt appl_dt, aa.acad_cal_type acad_cal_type, aa.acad_ci_sequence_number acad_ci_sequence_number, ci1.alternate_code acad_alternate_code, ci1.start_dt acad_ci_start_dt, ci1.end_dt acad_ci_end_dt, aa.adm_cal_type adm_cal_type, aa.adm_ci_sequence_number adm_ci_sequence_number, ci2.alternate_code adm_alternate_code, ci2.start_dt adm_ci_start_dt, ci2.end_dt adm_ci_end_dt, aa.admission_cat admission_cat, aa.s_admission_process_type s_admission_process_type, lkup.meaning adm_prc_type_desc, aa.adm_appl_status adm_appl_status, aa.adm_fee_status adm_fee_status, aa.tac_appl_ind tac_appl_ind, ci1.alternate_code || '/' || ci2.alternate_code commencement_period, aa.admission_cat || '/' || lkup.meaning admission_process_cat, aa.adm_appl_status adm_appl_status_display, aa.adm_fee_status adm_fee_status_display, aa.common_app, aa.spcl_grp_1, DECODE(aa.spcl_grp_1,NULL,NULL,(SELECT cc1.name FROM igs_ad_code_classes cc1 WHERE aa.spcl_grp_1 = cc1.code_id AND cc1.CLASS = 'SPECIAL_GROUP1' )) spcl_grp_1_name, DECODE (aa.spcl_grp_1,NULL,NULL,(SELECT cc1.description FROM igs_ad_code_classes cc1 WHERE aa.spcl_grp_1 = cc1.code_id AND cc1.class = 'SPECIAL_GROUP1' )) spcl_grp_1_desc, aa.spcl_grp_2, DECODE(aa.spcl_grp_2,NULL,NULL,(SELECT cc2.name FROM igs_ad_code_classes cc2 WHERE aa.spcl_grp_2 = cc2.code_id AND cc2.CLASS = 'SPECIAL_GROUP2' )) spcl_grp_2_name, DECODE(aa.spcl_grp_2,NULL,NULL,(SELECT cc2.description FROM igs_ad_code_classes cc2 WHERE aa.spcl_grp_2 = cc2.code_id AND cc2.CLASS = 'SPECIAL_GROUP2' )) spcl_grp_2_desc, aa.created_by, aa.creation_date, aa.last_updated_by, aa.last_update_date, aa.last_update_login, aa.application_type, aa.choice_number choice_number, aa.routeb_pref routeb_pref, aa.application_id application_id, aa.alt_appl_id alt_appl_id, aa.appl_fee_amt appl_fee_amt FROM igs_ad_appl aa, igs_ca_inst ci1, igs_ca_inst ci2, hz_parties p, igs_lookup_values lkup WHERE p.party_id = aa.person_id AND ci1.cal_type = aa.acad_cal_type AND ci1.sequence_number = aa.acad_ci_sequence_number AND ci2.cal_type = aa.adm_cal_type AND ci2.sequence_number = aa.adm_ci_sequence_number AND lkup.lookup_type = 'ADMISSION_PROCESS_TYPE' AND aa.s_admission_process_type = lkup.lookup_code

View Text - HTML Formatted

SELECT AA.ROWID ROW_ID
, AA.PERSON_ID PERSON_ID
, P.PARTY_NUMBER PERSON_NUMBER
, P.PERSON_LAST_NAME || '
, ' || P.PERSON_TITLE || ' ' || NVL (P.KNOWN_AS
, P.PERSON_FIRST_NAME) DSP_CONTEXT_BLOCK_NAME
, AA.ADMISSION_APPL_NUMBER ADMISSION_APPL_NUMBER
, AA.APPL_DT APPL_DT
, AA.ACAD_CAL_TYPE ACAD_CAL_TYPE
, AA.ACAD_CI_SEQUENCE_NUMBER ACAD_CI_SEQUENCE_NUMBER
, CI1.ALTERNATE_CODE ACAD_ALTERNATE_CODE
, CI1.START_DT ACAD_CI_START_DT
, CI1.END_DT ACAD_CI_END_DT
, AA.ADM_CAL_TYPE ADM_CAL_TYPE
, AA.ADM_CI_SEQUENCE_NUMBER ADM_CI_SEQUENCE_NUMBER
, CI2.ALTERNATE_CODE ADM_ALTERNATE_CODE
, CI2.START_DT ADM_CI_START_DT
, CI2.END_DT ADM_CI_END_DT
, AA.ADMISSION_CAT ADMISSION_CAT
, AA.S_ADMISSION_PROCESS_TYPE S_ADMISSION_PROCESS_TYPE
, LKUP.MEANING ADM_PRC_TYPE_DESC
, AA.ADM_APPL_STATUS ADM_APPL_STATUS
, AA.ADM_FEE_STATUS ADM_FEE_STATUS
, AA.TAC_APPL_IND TAC_APPL_IND
, CI1.ALTERNATE_CODE || '/' || CI2.ALTERNATE_CODE COMMENCEMENT_PERIOD
, AA.ADMISSION_CAT || '/' || LKUP.MEANING ADMISSION_PROCESS_CAT
, AA.ADM_APPL_STATUS ADM_APPL_STATUS_DISPLAY
, AA.ADM_FEE_STATUS ADM_FEE_STATUS_DISPLAY
, AA.COMMON_APP
, AA.SPCL_GRP_1
, DECODE(AA.SPCL_GRP_1
, NULL
, NULL
, (SELECT CC1.NAME
FROM IGS_AD_CODE_CLASSES CC1
WHERE AA.SPCL_GRP_1 = CC1.CODE_ID
AND CC1.CLASS = 'SPECIAL_GROUP1' )) SPCL_GRP_1_NAME
, DECODE (AA.SPCL_GRP_1
, NULL
, NULL
, (SELECT CC1.DESCRIPTION
FROM IGS_AD_CODE_CLASSES CC1
WHERE AA.SPCL_GRP_1 = CC1.CODE_ID
AND CC1.CLASS = 'SPECIAL_GROUP1' )) SPCL_GRP_1_DESC
, AA.SPCL_GRP_2
, DECODE(AA.SPCL_GRP_2
, NULL
, NULL
, (SELECT CC2.NAME
FROM IGS_AD_CODE_CLASSES CC2
WHERE AA.SPCL_GRP_2 = CC2.CODE_ID
AND CC2.CLASS = 'SPECIAL_GROUP2' )) SPCL_GRP_2_NAME
, DECODE(AA.SPCL_GRP_2
, NULL
, NULL
, (SELECT CC2.DESCRIPTION
FROM IGS_AD_CODE_CLASSES CC2
WHERE AA.SPCL_GRP_2 = CC2.CODE_ID
AND CC2.CLASS = 'SPECIAL_GROUP2' )) SPCL_GRP_2_DESC
, AA.CREATED_BY
, AA.CREATION_DATE
, AA.LAST_UPDATED_BY
, AA.LAST_UPDATE_DATE
, AA.LAST_UPDATE_LOGIN
, AA.APPLICATION_TYPE
, AA.CHOICE_NUMBER CHOICE_NUMBER
, AA.ROUTEB_PREF ROUTEB_PREF
, AA.APPLICATION_ID APPLICATION_ID
, AA.ALT_APPL_ID ALT_APPL_ID
, AA.APPL_FEE_AMT APPL_FEE_AMT
FROM IGS_AD_APPL AA
, IGS_CA_INST CI1
, IGS_CA_INST CI2
, HZ_PARTIES P
, IGS_LOOKUP_VALUES LKUP
WHERE P.PARTY_ID = AA.PERSON_ID
AND CI1.CAL_TYPE = AA.ACAD_CAL_TYPE
AND CI1.SEQUENCE_NUMBER = AA.ACAD_CI_SEQUENCE_NUMBER
AND CI2.CAL_TYPE = AA.ADM_CAL_TYPE
AND CI2.SEQUENCE_NUMBER = AA.ADM_CI_SEQUENCE_NUMBER
AND LKUP.LOOKUP_TYPE = 'ADMISSION_PROCESS_TYPE'
AND AA.S_ADMISSION_PROCESS_TYPE = LKUP.LOOKUP_CODE