VIEW: APPS.IGSFV_AD_ADM_APPL

Source

View Text - Preformatted

SELECT apl.PERSON_ID, p.PARTY_NUMBER, pp.PERSON_NAME, apl.ADMISSION_APPL_NUMBER, apl.APPL_DT, ci2.ALTERNATE_CODE, apl.ACAD_CAL_TYPE, apl.ACAD_CI_SEQUENCE_NUMBER, ci1.ALTERNATE_CODE, apl.ADM_CAL_TYPE, apl.ADM_CI_SEQUENCE_NUMBER, apl.ADMISSION_CAT, ac.DESCRIPTION, '_LA:apl.S_ADMISSION_PROCESS_TYPE:IGS_LOOKUP_VALUES:ADMISSION_PROCESS_TYPE:MEANING', apl.ADM_APPL_STATUS, ast.DESCRIPTION, apl.ADM_FEE_STATUS, fst.DESCRIPTION, '_LA:apl.TAC_APPL_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING', apl.SPCL_GRP_1, cc1.NAME, cc1.DESCRIPTION, apl.SPCL_GRP_2, cc2.NAME, cc2.DESCRIPTION, '_LA:apl.COMMON_APP:IGS_LOOKUP_VALUES:YES_NO:MEANING', apl.APPLICATION_TYPE, apt.DESCRIPTION, apl.CHOICE_NUMBER, apl.ROUTEB_PREF, apl.APPLICATION_ID, apl.ALT_APPL_ID, apl.created_by, apl.creation_date, apl.last_updated_by, apl.last_update_date FROM igs_ad_appl_all apl, IGS_AD_CAT_ALL ac, HZ_PARTIES P, HZ_PERSON_PROFILES PP, igs_ad_ss_appl_typ apt, igs_ca_inst_all ci1, igs_ca_inst_all ci2, igs_ad_appl_stat ast, igs_ad_fee_stat fst, igs_ad_code_classes cc1, igs_ad_code_classes cc2 WHERE apl.ADMISSION_CAT = ac.ADMISSION_CAT AND apl.PERSON_ID = p.PARTY_ID AND P.PARTY_ID = PP.PARTY_ID AND PP.CONTENT_SOURCE_TYPE (+) = 'USER_ENTERED' AND SYSDATE BETWEEN PP.EFFECTIVE_START_DATE AND NVL(PP.EFFECTIVE_END_DATE,SYSDATE) AND apl.APPLICATION_TYPE = apt.ADMISSION_APPLICATION_TYPE(+) AND ci1.CAL_TYPE = apl.ADM_CAL_TYPE AND ci1.SEQUENCE_NUMBER = apl.ADM_CI_SEQUENCE_NUMBER AND ci2.CAL_TYPE = apl.ACAD_CAL_TYPE AND ci2.SEQUENCE_NUMBER = apl.ACAD_CI_SEQUENCE_NUMBER AND apl.ADM_APPL_STATUS = ast.ADM_APPL_STATUS AND apl.ADM_FEE_STATUS = fst.ADM_FEE_STATUS AND apl.SPCL_GRP_1 = cc1.CODE_ID(+) AND apl.SPCL_GRP_2 = cc2.CODE_ID(+) WITH READ ONLY

View Text - HTML Formatted

SELECT APL.PERSON_ID
, P.PARTY_NUMBER
, PP.PERSON_NAME
, APL.ADMISSION_APPL_NUMBER
, APL.APPL_DT
, CI2.ALTERNATE_CODE
, APL.ACAD_CAL_TYPE
, APL.ACAD_CI_SEQUENCE_NUMBER
, CI1.ALTERNATE_CODE
, APL.ADM_CAL_TYPE
, APL.ADM_CI_SEQUENCE_NUMBER
, APL.ADMISSION_CAT
, AC.DESCRIPTION
, '_LA:APL.S_ADMISSION_PROCESS_TYPE:IGS_LOOKUP_VALUES:ADMISSION_PROCESS_TYPE:MEANING'
, APL.ADM_APPL_STATUS
, AST.DESCRIPTION
, APL.ADM_FEE_STATUS
, FST.DESCRIPTION
, '_LA:APL.TAC_APPL_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, APL.SPCL_GRP_1
, CC1.NAME
, CC1.DESCRIPTION
, APL.SPCL_GRP_2
, CC2.NAME
, CC2.DESCRIPTION
, '_LA:APL.COMMON_APP:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, APL.APPLICATION_TYPE
, APT.DESCRIPTION
, APL.CHOICE_NUMBER
, APL.ROUTEB_PREF
, APL.APPLICATION_ID
, APL.ALT_APPL_ID
, APL.CREATED_BY
, APL.CREATION_DATE
, APL.LAST_UPDATED_BY
, APL.LAST_UPDATE_DATE
FROM IGS_AD_APPL_ALL APL
, IGS_AD_CAT_ALL AC
, HZ_PARTIES P
, HZ_PERSON_PROFILES PP
, IGS_AD_SS_APPL_TYP APT
, IGS_CA_INST_ALL CI1
, IGS_CA_INST_ALL CI2
, IGS_AD_APPL_STAT AST
, IGS_AD_FEE_STAT FST
, IGS_AD_CODE_CLASSES CC1
, IGS_AD_CODE_CLASSES CC2
WHERE APL.ADMISSION_CAT = AC.ADMISSION_CAT
AND APL.PERSON_ID = P.PARTY_ID
AND P.PARTY_ID = PP.PARTY_ID
AND PP.CONTENT_SOURCE_TYPE (+) = 'USER_ENTERED'
AND SYSDATE BETWEEN PP.EFFECTIVE_START_DATE
AND NVL(PP.EFFECTIVE_END_DATE
, SYSDATE)
AND APL.APPLICATION_TYPE = APT.ADMISSION_APPLICATION_TYPE(+)
AND CI1.CAL_TYPE = APL.ADM_CAL_TYPE
AND CI1.SEQUENCE_NUMBER = APL.ADM_CI_SEQUENCE_NUMBER
AND CI2.CAL_TYPE = APL.ACAD_CAL_TYPE
AND CI2.SEQUENCE_NUMBER = APL.ACAD_CI_SEQUENCE_NUMBER
AND APL.ADM_APPL_STATUS = AST.ADM_APPL_STATUS
AND APL.ADM_FEE_STATUS = FST.ADM_FEE_STATUS
AND APL.SPCL_GRP_1 = CC1.CODE_ID(+)
AND APL.SPCL_GRP_2 = CC2.CODE_ID(+) WITH READ ONLY