VIEW: APPS.IGS_PR_STD_PR_OU_V

Source

View Text - Preformatted

SELECT PSPO.ROWID ROW_ID, PSPO.PERSON_ID PERSON_ID, PSPO.COURSE_CD COURSE_CD, PSPO.SEQUENCE_NUMBER SEQUENCE_NUMBER, PSPO.PRG_CAL_TYPE PRG_CAL_TYPE, PSPO.PRG_CI_SEQUENCE_NUMBER PRG_CI_SEQUENCE_NUMBER, PSPO.RULE_CHECK_DT RULE_CHECK_DT, PSPO.PROGRESSION_RULE_CAT PROGRESSION_RULE_CAT, PSPO.PRA_SEQUENCE_NUMBER PRA_SEQUENCE_NUMBER, PSPO.PRO_SEQUENCE_NUMBER PRO_SEQUENCE_NUMBER, PSPO.PROGRESSION_OUTCOME_TYPE PROGRESSION_OUTCOME_TYPE, PSPO.DURATION DURATION, PSPO.DURATION_TYPE DURATION_TYPE, PSPO.DECISION_STATUS DECISION_STATUS, PSPO.DECISION_DT DECISION_DT, PSPO.DECISION_ORG_UNIT_CD DECISION_ORG_UNIT_CD, PSPO.DECISION_OU_START_DT DECISION_OU_START_DT, PSPO.APPLIED_DT APPLIED_DT, PSPO.SHOW_CAUSE_EXPIRY_DT SHOW_CAUSE_EXPIRY_DT, PSPO.SHOW_CAUSE_DT SHOW_CAUSE_DT, PSPO.SHOW_CAUSE_OUTCOME_DT SHOW_CAUSE_OUTCOME_DT, PSPO.SHOW_CAUSE_OUTCOME_TYPE SHOW_CAUSE_OUTCOME_TYPE, PSPO.APPEAL_EXPIRY_DT APPEAL_EXPIRY_DT, PSPO.APPEAL_DT APPEAL_DT, PSPO.APPEAL_OUTCOME_DT APPEAL_OUTCOME_DT, PSPO.APPEAL_OUTCOME_TYPE APPEAL_OUTCOME_TYPE, PSPO.ENCMB_COURSE_GROUP_CD ENCMB_COURSE_GROUP_CD, PSPO.RESTRICTED_ENROLMENT_CP RESTRICTED_ENROLMENT_CP, PSPO.RESTRICTED_ATTENDANCE_TYPE RESTRICTED_ATTENDANCE_TYPE, PSPO.COMMENTS COMMENTS, PSPO.SHOW_CAUSE_COMMENTS SHOW_CAUSE_COMMENTS, PSPO.APPEAL_COMMENTS APPEAL_COMMENTS, PSPO.CREATED_BY CREATED_BY, PSPO.CREATION_DATE CREATION_DATE, PSPO.EXPIRY_DT EXPIRY_DT, PSPO.PRO_PRA_SEQUENCE_NUMBER PRO_PRA_SEQUENCE_NUMBER, PSPO.LAST_UPDATED_BY LAST_UPDATED_BY, PSPO.LAST_UPDATE_DATE LAST_UPDATE_DATE, PSPO.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, POT.POSITIVE_OUTCOME_IND POSITIVE_OUTCOME_IND FROM IGS_PR_STDNT_PR_OU PSPO , IGS_PR_OU_TYPE POT WHERE PSPO.PROGRESSION_OUTCOME_TYPE = POT.PROGRESSION_OUTCOME_TYPE

View Text - HTML Formatted

SELECT PSPO.ROWID ROW_ID
, PSPO.PERSON_ID PERSON_ID
, PSPO.COURSE_CD COURSE_CD
, PSPO.SEQUENCE_NUMBER SEQUENCE_NUMBER
, PSPO.PRG_CAL_TYPE PRG_CAL_TYPE
, PSPO.PRG_CI_SEQUENCE_NUMBER PRG_CI_SEQUENCE_NUMBER
, PSPO.RULE_CHECK_DT RULE_CHECK_DT
, PSPO.PROGRESSION_RULE_CAT PROGRESSION_RULE_CAT
, PSPO.PRA_SEQUENCE_NUMBER PRA_SEQUENCE_NUMBER
, PSPO.PRO_SEQUENCE_NUMBER PRO_SEQUENCE_NUMBER
, PSPO.PROGRESSION_OUTCOME_TYPE PROGRESSION_OUTCOME_TYPE
, PSPO.DURATION DURATION
, PSPO.DURATION_TYPE DURATION_TYPE
, PSPO.DECISION_STATUS DECISION_STATUS
, PSPO.DECISION_DT DECISION_DT
, PSPO.DECISION_ORG_UNIT_CD DECISION_ORG_UNIT_CD
, PSPO.DECISION_OU_START_DT DECISION_OU_START_DT
, PSPO.APPLIED_DT APPLIED_DT
, PSPO.SHOW_CAUSE_EXPIRY_DT SHOW_CAUSE_EXPIRY_DT
, PSPO.SHOW_CAUSE_DT SHOW_CAUSE_DT
, PSPO.SHOW_CAUSE_OUTCOME_DT SHOW_CAUSE_OUTCOME_DT
, PSPO.SHOW_CAUSE_OUTCOME_TYPE SHOW_CAUSE_OUTCOME_TYPE
, PSPO.APPEAL_EXPIRY_DT APPEAL_EXPIRY_DT
, PSPO.APPEAL_DT APPEAL_DT
, PSPO.APPEAL_OUTCOME_DT APPEAL_OUTCOME_DT
, PSPO.APPEAL_OUTCOME_TYPE APPEAL_OUTCOME_TYPE
, PSPO.ENCMB_COURSE_GROUP_CD ENCMB_COURSE_GROUP_CD
, PSPO.RESTRICTED_ENROLMENT_CP RESTRICTED_ENROLMENT_CP
, PSPO.RESTRICTED_ATTENDANCE_TYPE RESTRICTED_ATTENDANCE_TYPE
, PSPO.COMMENTS COMMENTS
, PSPO.SHOW_CAUSE_COMMENTS SHOW_CAUSE_COMMENTS
, PSPO.APPEAL_COMMENTS APPEAL_COMMENTS
, PSPO.CREATED_BY CREATED_BY
, PSPO.CREATION_DATE CREATION_DATE
, PSPO.EXPIRY_DT EXPIRY_DT
, PSPO.PRO_PRA_SEQUENCE_NUMBER PRO_PRA_SEQUENCE_NUMBER
, PSPO.LAST_UPDATED_BY LAST_UPDATED_BY
, PSPO.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PSPO.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, POT.POSITIVE_OUTCOME_IND POSITIVE_OUTCOME_IND
FROM IGS_PR_STDNT_PR_OU PSPO
, IGS_PR_OU_TYPE POT
WHERE PSPO.PROGRESSION_OUTCOME_TYPE = POT.PROGRESSION_OUTCOME_TYPE