View: IGS_AD_RVGR_INC_EXC_ORG_V

Product:	IGS - Student System
Description:	View where all Application Review Group Include Exclude related information will be recorded for Organization review profile group.
Implementation/DBA Data:	APPS.IGS_AD_RVGR_INC_EXC_ORG_V

View Text

SELECT IE.ROWID
, IE.REVGR_INCL_EXCL_ID
, IE.APPL_REVPROF_REVGR_ID
, IE.INCL_EXCL_IND
, OU.ORG_UNIT_CD
, OU.DESCRIPTION
, IE.CREATED_BY
, IE.CREATION_DATE
, IE.LAST_UPDATED_BY
, IE.LAST_UPDATE_DATE
, IE.LAST_UPDATE_LOGIN
FROM IGS_AD_RVGR_INC_EXC IE
, IGS_OR_UNIT OU
WHERE IE.START_VALUE = OU.ORG_UNIT_CD
AND OU.ORG_STATUS IN ( SELECT OS.ORG_STATUS
FROM IGS_OR_STATUS OS
WHERE OS.S_ORG_STATUS <> 'INACTIVE')
AND OU.INSTITUTION_CD IN ( SELECT INS.INSTITUTION_CD
FROM IGS_OR_INSTITUTION INS
, IGS_OR_INST_STAT IST
WHERE INS.LOCAL_INSTITUTION_IND = 'Y'
AND INS.INSTITUTION_STATUS = IST.INSTITUTION_STATUS
AND IST.S_INSTITUTION_STATUS = 'ACTIVE')

Columns