Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT ARR.APPL_REVPROF_RTSCALE_ID
, ARR.APPL_REV_PROFILE_ID
, ARP.REVIEW_PROFILE_NAME
, ARR.RATING_TYPE_ID
, CC.NAME
, CC.DESCRIPTION
, ARR.RATING_SCALE_ID
, RS.RATING_SCALE_NAME
, RS.DESCRIPTION
, ARR.CREATED_BY
, ARR.CREATION_DATE
, ARR.LAST_UPDATED_BY
, ARR.LAST_UPDATE_DATE
FROM IGS_AD_APL_RVPF_RSL ARR
, IGS_AD_APL_REV_PRF_ALL ARP
, IGS_AD_RATING_SCALES RS
, IGS_AD_CODE_CLASSES CC
WHERE ARR.RATING_TYPE_ID = CC.CODE_ID(+)
AND ARR.RATING_SCALE_ID = RS.RATING_SCALE_ID
AND ARR.APPL_REV_PROFILE_ID = ARP.APPL_REV_PROFILE_ID WITH READ ONLY