VIEW: APPS.IGSFV_PR_STDNT_PR_OU

Source

View Text - Preformatted

SELECT HP1.PARTY_NAME, HP1.PARTY_NUMBER, CRV.TITLE, SPO.COURSE_CD, SPO.PRG_CAL_TYPE, SPO.PRG_CI_SEQUENCE_NUMBER, CI.DESCRIPTION, SPO.RULE_CHECK_DT, SPO.PROGRESSION_RULE_CAT, PRGC.DESCRIPTION, SPO.PROGRESSION_OUTCOME_TYPE, POT.DESCRIPTION, SPO.DURATION, SPO.DURATION_TYPE, SPO.DECISION_STATUS, SPO.DECISION_DT, SPO.DECISION_ORG_UNIT_CD, SPO.DECISION_OU_START_DT, HP2.PARTY_NAME, SPO.APPLIED_DT, SPO.EXPIRY_DT, SPO.SHOW_CAUSE_EXPIRY_DT, SPO.SHOW_CAUSE_DT, SPO.SHOW_CAUSE_OUTCOME_DT, SPO.SHOW_CAUSE_OUTCOME_TYPE, SPO.SHOW_CAUSE_COMMENTS, SPO.APPEAL_EXPIRY_DT, SPO.APPEAL_DT, SPO.APPEAL_OUTCOME_DT, SPO.APPEAL_OUTCOME_TYPE, SPO.APPEAL_COMMENTS, SPO.ENCMB_COURSE_GROUP_CD, CGR.DESCRIPTION, SPO.RESTRICTED_ENROLMENT_CP, SPO.RESTRICTED_ATTENDANCE_TYPE, ATT.DESCRIPTION, SPO.COMMENTS, SPO.SEQUENCE_NUMBER, SPO.PERSON_ID, SPO.PRA_SEQUENCE_NUMBER, SPO.PRO_PRA_SEQUENCE_NUMBER, SPO.PRO_SEQUENCE_NUMBER, SPO.CREATED_BY, SPO.CREATION_DATE, SPO.LAST_UPDATED_BY, SPO.LAST_UPDATE_DATE FROM IGS_PR_STDNT_PR_OU_ALL SPO, IGS_EN_STDNT_PS_ATT_ALL SCA, HZ_PARTIES HP1, HZ_PARTIES HP2, IGS_PS_VER_ALL CRV, IGS_CA_INST_ALL CI, IGS_PR_OU_TYPE_ALL POT, IGS_PR_RU_CAT PRGC, IGS_PS_GRP_ALL CGR, IGS_EN_ATD_TYPE_ALL ATT, igs_pe_hz_parties ipz WHERE SPO.PERSON_ID = HP1.PARTY_ID AND SPO.PERSON_ID = SCA.PERSON_ID AND SPO.COURSE_CD = SCA.COURSE_CD AND SCA.COURSE_CD = CRV.COURSE_CD AND SCA.VERSION_NUMBER = CRV.VERSION_NUMBER AND SPO.PRG_CAL_TYPE = CI.CAL_TYPE (+) AND SPO.PRG_CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER (+) AND SPO.PROGRESSION_RULE_CAT = PRGC.PROGRESSION_RULE_CAT (+) AND SPO.PROGRESSION_OUTCOME_TYPE = POT.PROGRESSION_OUTCOME_TYPE (+) AND SPO.DECISION_ORG_UNIT_CD = ipz.oss_org_unit_cd(+) AND ipz.party_id = hp2.party_id(+) AND SPO.ENCMB_COURSE_GROUP_CD = CGR.COURSE_GROUP_CD (+) AND SPO.RESTRICTED_ATTENDANCE_TYPE = ATT.ATTENDANCE_TYPE (+) WITH READ ONLY

View Text - HTML Formatted

SELECT HP1.PARTY_NAME
, HP1.PARTY_NUMBER
, CRV.TITLE
, SPO.COURSE_CD
, SPO.PRG_CAL_TYPE
, SPO.PRG_CI_SEQUENCE_NUMBER
, CI.DESCRIPTION
, SPO.RULE_CHECK_DT
, SPO.PROGRESSION_RULE_CAT
, PRGC.DESCRIPTION
, SPO.PROGRESSION_OUTCOME_TYPE
, POT.DESCRIPTION
, SPO.DURATION
, SPO.DURATION_TYPE
, SPO.DECISION_STATUS
, SPO.DECISION_DT
, SPO.DECISION_ORG_UNIT_CD
, SPO.DECISION_OU_START_DT
, HP2.PARTY_NAME
, SPO.APPLIED_DT
, SPO.EXPIRY_DT
, SPO.SHOW_CAUSE_EXPIRY_DT
, SPO.SHOW_CAUSE_DT
, SPO.SHOW_CAUSE_OUTCOME_DT
, SPO.SHOW_CAUSE_OUTCOME_TYPE
, SPO.SHOW_CAUSE_COMMENTS
, SPO.APPEAL_EXPIRY_DT
, SPO.APPEAL_DT
, SPO.APPEAL_OUTCOME_DT
, SPO.APPEAL_OUTCOME_TYPE
, SPO.APPEAL_COMMENTS
, SPO.ENCMB_COURSE_GROUP_CD
, CGR.DESCRIPTION
, SPO.RESTRICTED_ENROLMENT_CP
, SPO.RESTRICTED_ATTENDANCE_TYPE
, ATT.DESCRIPTION
, SPO.COMMENTS
, SPO.SEQUENCE_NUMBER
, SPO.PERSON_ID
, SPO.PRA_SEQUENCE_NUMBER
, SPO.PRO_PRA_SEQUENCE_NUMBER
, SPO.PRO_SEQUENCE_NUMBER
, SPO.CREATED_BY
, SPO.CREATION_DATE
, SPO.LAST_UPDATED_BY
, SPO.LAST_UPDATE_DATE
FROM IGS_PR_STDNT_PR_OU_ALL SPO
, IGS_EN_STDNT_PS_ATT_ALL SCA
, HZ_PARTIES HP1
, HZ_PARTIES HP2
, IGS_PS_VER_ALL CRV
, IGS_CA_INST_ALL CI
, IGS_PR_OU_TYPE_ALL POT
, IGS_PR_RU_CAT PRGC
, IGS_PS_GRP_ALL CGR
, IGS_EN_ATD_TYPE_ALL ATT
, IGS_PE_HZ_PARTIES IPZ
WHERE SPO.PERSON_ID = HP1.PARTY_ID
AND SPO.PERSON_ID = SCA.PERSON_ID
AND SPO.COURSE_CD = SCA.COURSE_CD
AND SCA.COURSE_CD = CRV.COURSE_CD
AND SCA.VERSION_NUMBER = CRV.VERSION_NUMBER
AND SPO.PRG_CAL_TYPE = CI.CAL_TYPE (+)
AND SPO.PRG_CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER (+)
AND SPO.PROGRESSION_RULE_CAT = PRGC.PROGRESSION_RULE_CAT (+)
AND SPO.PROGRESSION_OUTCOME_TYPE = POT.PROGRESSION_OUTCOME_TYPE (+)
AND SPO.DECISION_ORG_UNIT_CD = IPZ.OSS_ORG_UNIT_CD(+)
AND IPZ.PARTY_ID = HP2.PARTY_ID(+)
AND SPO.ENCMB_COURSE_GROUP_CD = CGR.COURSE_GROUP_CD (+)
AND SPO.RESTRICTED_ATTENDANCE_TYPE = ATT.ATTENDANCE_TYPE (+) WITH READ ONLY