eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: APPS.IGS_PR_RU_APPL

Source

View Text - Preformatted


SELECT tab.rowid row_id, tab.progression_rule_cat progression_rule_cat, tab.sequence_number sequence_number, tab.s_relation_type s_relation_type, tab.progression_rule_cd progression_rule_cd, tab.reference_cd reference_cd, tab.rul_sequence_number rul_sequence_number, tab.attendance_type attendance_type, tab.ou_org_unit_cd ou_org_unit_cd, tab.ou_start_dt ou_start_dt, tab.course_type course_type, tab.crv_course_cd crv_course_cd, tab.crv_version_number crv_version_number, tab.sca_person_id sca_person_id, tab.sca_course_cd sca_course_cd, tab.pro_progression_rule_cat pro_progression_rule_cat, tab.pro_pra_sequence_number pro_pra_sequence_number, tab.pro_sequence_number pro_sequence_number, tab.spo_person_id spo_person_id, tab.spo_course_cd spo_course_cd, tab.spo_sequence_number spo_sequence_number, tab.logical_delete_dt logical_delete_dt, tab.message message, 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.org_id org_id, tab.MIN_CP MIN_CP, tab.MAX_CP MAX_CP, NVL(rc.POSITIVE_RULE_IND,'N') POSITIVE_RULE_IND, tab.IGS_PR_CLASS_STD_ID IGS_PR_CLASS_STD_ID, cs.CLASS_STANDING CLASS_STANDING FROM igs_pr_ru_appl_all tab, igs_pr_ru_cat rc, IGS_PR_CLASS_STD cs 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) AND cs.IGS_PR_CLASS_STD_ID(+) = tab.IGS_PR_CLASS_STD_ID AND rc. PROGRESSION_RULE_CAT = tab.progression_rule_cat

View Text - HTML Formatted

SELECT TAB.ROWID ROW_ID
, TAB.PROGRESSION_RULE_CAT PROGRESSION_RULE_CAT
, TAB.SEQUENCE_NUMBER SEQUENCE_NUMBER
, TAB.S_RELATION_TYPE S_RELATION_TYPE
, TAB.PROGRESSION_RULE_CD PROGRESSION_RULE_CD
, TAB.REFERENCE_CD REFERENCE_CD
, TAB.RUL_SEQUENCE_NUMBER RUL_SEQUENCE_NUMBER
, TAB.ATTENDANCE_TYPE ATTENDANCE_TYPE
, TAB.OU_ORG_UNIT_CD OU_ORG_UNIT_CD
, TAB.OU_START_DT OU_START_DT
, TAB.COURSE_TYPE COURSE_TYPE
, TAB.CRV_COURSE_CD CRV_COURSE_CD
, TAB.CRV_VERSION_NUMBER CRV_VERSION_NUMBER
, TAB.SCA_PERSON_ID SCA_PERSON_ID
, TAB.SCA_COURSE_CD SCA_COURSE_CD
, TAB.PRO_PROGRESSION_RULE_CAT PRO_PROGRESSION_RULE_CAT
, TAB.PRO_PRA_SEQUENCE_NUMBER PRO_PRA_SEQUENCE_NUMBER
, TAB.PRO_SEQUENCE_NUMBER PRO_SEQUENCE_NUMBER
, TAB.SPO_PERSON_ID SPO_PERSON_ID
, TAB.SPO_COURSE_CD SPO_COURSE_CD
, TAB.SPO_SEQUENCE_NUMBER SPO_SEQUENCE_NUMBER
, TAB.LOGICAL_DELETE_DT LOGICAL_DELETE_DT
, TAB.MESSAGE MESSAGE
, 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.ORG_ID ORG_ID
, TAB.MIN_CP MIN_CP
, TAB.MAX_CP MAX_CP
, NVL(RC.POSITIVE_RULE_IND
, 'N') POSITIVE_RULE_IND
, TAB.IGS_PR_CLASS_STD_ID IGS_PR_CLASS_STD_ID
, CS.CLASS_STANDING CLASS_STANDING
FROM IGS_PR_RU_APPL_ALL TAB
, IGS_PR_RU_CAT RC
, IGS_PR_CLASS_STD CS
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)
AND CS.IGS_PR_CLASS_STD_ID(+) = TAB.IGS_PR_CLASS_STD_ID
AND RC. PROGRESSION_RULE_CAT = TAB.PROGRESSION_RULE_CAT