VIEW: APPS.IGS_PR_RU_OU_V

Source

View Text - Preformatted

SELECT RUO.ROWID ROW_ID, RUO.PROGRESSION_RULE_CAT PROGRESSION_RULE_CAT, RUO.PRA_SEQUENCE_NUMBER PRA_SEQUENCE_NUMBER, RUO.SEQUENCE_NUMBER SEQUENCE_NUMBER, RUO.NUMBER_OF_FAILURES NUMBER_OF_FAILURES, RUO.PROGRESSION_OUTCOME_TYPE PROGRESSION_OUTCOME_TYPE, ROT.POSITIVE_OUTCOME_IND POSITIVE_OUTCOME_IND, RUO.APPLY_AUTOMATICALLY_IND APPLY_AUTOMATICALLY_IND, RUO.PRG_RULE_REPEAT_FAIL_TYPE PRG_RULE_REPEAT_FAIL_TYPE, RUO.OVERRIDE_SHOW_CAUSE_IND OVERRIDE_SHOW_CAUSE_IND, RUO.OVERRIDE_APPEAL_IND OVERRIDE_APPEAL_IND, RUO.DURATION DURATION, RUO.DURATION_TYPE DURATION_TYPE, RUO.RANK RANK, RUO.ENCMB_COURSE_GROUP_CD ENCMB_COURSE_GROUP_CD, RUO.RESTRICTED_ENROLMENT_CP RESTRICTED_ENROLMENT_CP, RUO.RESTRICTED_ATTENDANCE_TYPE RESTRICTED_ATTENDANCE_TYPE, RUO.COMMENTS COMMENTS, RUO.CREATED_BY CREATED_BY, RUO.CREATION_DATE CREATION_DATE, RUO.LAST_UPDATED_BY LAST_UPDATED_BY, RUO.LAST_UPDATE_DATE LAST_UPDATE_DATE, RUO.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ruo.logical_delete_dt LOGICAL_DELETE_DT FROM IGS_PR_RU_OU RUO, IGS_PR_OU_TYPE ROT WHERE RUO.PROGRESSION_OUTCOME_TYPE = ROT.PROGRESSION_OUTCOME_TYPE

View Text - HTML Formatted

SELECT RUO.ROWID ROW_ID
, RUO.PROGRESSION_RULE_CAT PROGRESSION_RULE_CAT
, RUO.PRA_SEQUENCE_NUMBER PRA_SEQUENCE_NUMBER
, RUO.SEQUENCE_NUMBER SEQUENCE_NUMBER
, RUO.NUMBER_OF_FAILURES NUMBER_OF_FAILURES
, RUO.PROGRESSION_OUTCOME_TYPE PROGRESSION_OUTCOME_TYPE
, ROT.POSITIVE_OUTCOME_IND POSITIVE_OUTCOME_IND
, RUO.APPLY_AUTOMATICALLY_IND APPLY_AUTOMATICALLY_IND
, RUO.PRG_RULE_REPEAT_FAIL_TYPE PRG_RULE_REPEAT_FAIL_TYPE
, RUO.OVERRIDE_SHOW_CAUSE_IND OVERRIDE_SHOW_CAUSE_IND
, RUO.OVERRIDE_APPEAL_IND OVERRIDE_APPEAL_IND
, RUO.DURATION DURATION
, RUO.DURATION_TYPE DURATION_TYPE
, RUO.RANK RANK
, RUO.ENCMB_COURSE_GROUP_CD ENCMB_COURSE_GROUP_CD
, RUO.RESTRICTED_ENROLMENT_CP RESTRICTED_ENROLMENT_CP
, RUO.RESTRICTED_ATTENDANCE_TYPE RESTRICTED_ATTENDANCE_TYPE
, RUO.COMMENTS COMMENTS
, RUO.CREATED_BY CREATED_BY
, RUO.CREATION_DATE CREATION_DATE
, RUO.LAST_UPDATED_BY LAST_UPDATED_BY
, RUO.LAST_UPDATE_DATE LAST_UPDATE_DATE
, RUO.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, RUO.LOGICAL_DELETE_DT LOGICAL_DELETE_DT
FROM IGS_PR_RU_OU RUO
, IGS_PR_OU_TYPE ROT
WHERE RUO.PROGRESSION_OUTCOME_TYPE = ROT.PROGRESSION_OUTCOME_TYPE