View: IGS_PR_INST_STA_REF_V

Product:	IGS - Student System
Description:	This view is used define the details of what a particular user defined institution statistic type includes and is used for.
Implementation/DBA Data:	APPS.IGS_PR_INST_STA_REF_V

View Text

SELECT ISR.ROWID
, ISR.STAT_TYPE
, ISR.UNIT_REF_CD
, RC.DESCRIPTION
, ISR.INCLUDE_OR_EXCLUDE
, ISR.REFERENCE_CD_TYPE
, ISR.CREATED_BY
, ISR.CREATION_DATE
, ISR.LAST_UPDATED_BY
, ISR.LAST_UPDATE_DATE
, ISR.LAST_UPDATE_LOGIN
FROM IGS_PR_INST_STA_REF ISR
, IGS_GE_REF_CD_TYPE RCT
, IGS_GE_REF_CD RC
WHERE ISR.UNIT_REF_CD = RC.REFERENCE_CD
AND ISR.REFERENCE_CD_TYPE = RC.REFERENCE_CD_TYPE
AND RC.REFERENCE_CD_TYPE = RCT.REFERENCE_CD_TYPE
AND NVL(RCT.CLOSED_IND
, 'N') = 'N'
AND ( RCT.UNIT_FLAG = 'Y' OR RCT.UNIT_SECTION_FLAG = 'Y' OR RCT.UNIT_SECTION_OCCURRENCE_FLAG = 'Y' )
AND RCT.S_REFERENCE_CD_TYPE = 'STATS'

Columns