Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Describes Admission of Application to Institution |
Implementation/DBA Data: | Not implemented in this database |
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