View: IGS_AD_APL_RVPF_RSL_V

Product:	IGS - Student System
Description:	View where all Rating Scale related information corresponding to an Application Review Profile will be recorded.
Implementation/DBA Data:	APPS.IGS_AD_APL_RVPF_RSL_V

View Text

SELECT RS.ROWID
, RS.APPL_REVPROF_RTSCALE_ID
, RS.APPL_REV_PROFILE_ID
, RS.RATING_TYPE_ID
, CC.NAME
, CC.DESCRIPTION
, RS.RATING_SCALE_ID
, ARS.RATING_SCALE_NAME
, ARS.DESCRIPTION
, RS.CREATED_BY
, RS.CREATION_DATE
, RS.LAST_UPDATED_BY
, RS.LAST_UPDATE_DATE
, RS.LAST_UPDATE_LOGIN
FROM IGS_AD_APL_RVPF_RSL RS
, IGS_AD_RATING_SCALES_V ARS
, IGS_AD_CODE_CLASSES CC
WHERE RS.RATING_TYPE_ID = CC.CODE_ID
AND NVL(CC.CLOSED_IND
, 'N') <> 'Y'
AND RS.RATING_SCALE_ID = ARS. RATING_SCALE_ID
AND NVL(ARS.CLOSED_IND
, 'N') <> 'Y'

Columns