[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT PAA.PERSON_ID
, P.PARTY_NUMBER
, PP.PERSON_NAME
, PAA.ADMISSION_APPL_NUMBER
, PAA.NOMINATED_COURSE_CD
, PSV.TITLE
, PAA.ACAI_SEQUENCE_NUMBER
, PAA.UNIT_CD
, PSU.TITLE
, PAA.UV_VERSION_NUMBER
, CI.DESCRIPTION
, PAA.CAL_TYPE
, PAA.CI_SEQUENCE_NUMBER
, PAA.LOCATION_CD
, L.DESCRIPTION
, PAA.UNIT_CLASS
, ASU.DESCRIPTION
, PAA.UNIT_MODE
, ASM.DESCRIPTION
, PAA.ADM_UNIT_OUTCOME_STATUS
, OUS.DESCRIPTION
, PAA.ASS_TRACKING_ID
, TR.TRACKING_STATUS
, TR.TRACKING_TYPE
, PAA.RULE_WAIVED_DT
, PAA.RULE_WAIVED_PERSON_ID
, P1.PARTY_NUMBER
, PP1.PERSON_NAME
, PAA.SUP_UNIT_CD
, PSU1.TITLE
, PAA.SUP_UV_VERSION_NUMBER
, PAA.CREATED_BY
, PAA.CREATION_DATE
, PAA.LAST_UPDATED_BY
, PAA.LAST_UPDATE_DATE
FROM IGS_AD_PS_APLINSTUNT_ALL PAA
, IGS_AD_UNIT_OU_STAT OUS
, IGS_PS_VER_ALL PSV
, IGS_AD_PS_APPL_INST_ALL INST
, IGS_CA_INST_ALL CI
, HZ_PARTIES P
, HZ_PERSON_PROFILES PP
, IGS_AD_LOCATION_ALL L
, IGS_PS_UNIT_VER_ALL PSU
, IGS_AS_UNIT_MODE ASM
, IGS_AS_UNIT_CLASS_ALL ASU
, IGS_TR_ITEM_ALL TR
, HZ_PARTIES P1
, HZ_PERSON_PROFILES PP1
, IGS_PS_UNIT_VER_ALL PSU1
WHERE PAA.ADM_UNIT_OUTCOME_STATUS = OUS.ADM_UNIT_OUTCOME_STATUS
AND PAA.UNIT_CD = PSU.UNIT_CD
AND PAA.UV_VERSION_NUMBER = PSU.VERSION_NUMBER
AND PAA.ASS_TRACKING_ID = TR.TRACKING_ID(+)
AND INST.NOMINATED_COURSE_CD = PSV.COURSE_CD
AND PAA.NOMINATED_COURSE_CD = INST.NOMINATED_COURSE_CD
AND PAA.PERSON_ID = INST.PERSON_ID
AND PAA.ADMISSION_APPL_NUMBER = INST.ADMISSION_APPL_NUMBER
AND PAA.ACAI_SEQUENCE_NUMBER = INST.SEQUENCE_NUMBER
AND INST.CRV_VERSION_NUMBER = PSV.VERSION_NUMBER
AND PAA.UNIT_CLASS = ASU.UNIT_CLASS(+)
AND PAA.UNIT_MODE = ASM.UNIT_MODE(+)
AND PAA.LOCATION_CD = L.LOCATION_CD(+)
AND PAA.SUP_UV_VERSION_NUMBER = PSU1.VERSION_NUMBER(+)
AND PAA.SUP_UNIT_CD = PSU1.UNIT_CD(+)
AND PAA.CAL_TYPE = CI.CAL_TYPE(+)
AND PAA.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER(+)
AND PAA.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 PAA.RULE_WAIVED_PERSON_ID = P1.PARTY_ID(+)
AND P1.PARTY_ID = PP1.PARTY_ID(+)
AND PP1.CONTENT_SOURCE_TYPE(+) = 'USER_ENTERED'
AND SYSDATE BETWEEN PP1.EFFECTIVE_START_DATE(+)
AND NVL(PP1.EFFECTIVE_END_DATE
, SYSDATE) WITH READ ONLY