VIEW: APPS.IGS_PR_RU_OU

Source

View Text - Preformatted

SELECT tab.rowid row_id, tab.progression_rule_cat progression_rule_cat, tab.pra_sequence_number pra_sequence_number, tab.sequence_number sequence_number, tab.number_of_failures number_of_failures, tab.progression_outcome_type progression_outcome_type, tab.apply_automatically_ind apply_automatically_ind, tab.prg_rule_repeat_fail_type prg_rule_repeat_fail_type, tab.override_show_cause_ind override_show_cause_ind, tab.override_appeal_ind override_appeal_ind, tab.duration duration, tab.duration_type duration_type, tab.rank rank, tab.encmb_course_group_cd encmb_course_group_cd, tab.restricted_enrolment_cp restricted_enrolment_cp, tab.restricted_attendance_type restricted_attendance_type, tab.comments comments, tab.created_by created_by, tab.creation_date creation_date, tab.last_updated_by last_updated_by, tab.last_update_date last_update_date, tab.last_update_login last_update_login , tab.logical_delete_dt, tab.org_id org_id FROM igs_pr_ru_ou_all tab WHERE NVL (tab.org_id , NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)

View Text - HTML Formatted

SELECT TAB.ROWID ROW_ID
, TAB.PROGRESSION_RULE_CAT PROGRESSION_RULE_CAT
, TAB.PRA_SEQUENCE_NUMBER PRA_SEQUENCE_NUMBER
, TAB.SEQUENCE_NUMBER SEQUENCE_NUMBER
, TAB.NUMBER_OF_FAILURES NUMBER_OF_FAILURES
, TAB.PROGRESSION_OUTCOME_TYPE PROGRESSION_OUTCOME_TYPE
, TAB.APPLY_AUTOMATICALLY_IND APPLY_AUTOMATICALLY_IND
, TAB.PRG_RULE_REPEAT_FAIL_TYPE PRG_RULE_REPEAT_FAIL_TYPE
, TAB.OVERRIDE_SHOW_CAUSE_IND OVERRIDE_SHOW_CAUSE_IND
, TAB.OVERRIDE_APPEAL_IND OVERRIDE_APPEAL_IND
, TAB.DURATION DURATION
, TAB.DURATION_TYPE DURATION_TYPE
, TAB.RANK RANK
, TAB.ENCMB_COURSE_GROUP_CD ENCMB_COURSE_GROUP_CD
, TAB.RESTRICTED_ENROLMENT_CP RESTRICTED_ENROLMENT_CP
, TAB.RESTRICTED_ATTENDANCE_TYPE RESTRICTED_ATTENDANCE_TYPE
, TAB.COMMENTS COMMENTS
, TAB.CREATED_BY CREATED_BY
, TAB.CREATION_DATE CREATION_DATE
, TAB.LAST_UPDATED_BY LAST_UPDATED_BY
, TAB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TAB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TAB.LOGICAL_DELETE_DT
, TAB.ORG_ID ORG_ID
FROM IGS_PR_RU_OU_ALL TAB
WHERE NVL (TAB.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)