View: IGSFV_USEC_OCCUR_REFERENCES

Product:	IGS - Student System
Description:	Full View for Unit Section Occurrence Reference
Implementation/DBA Data:	APPS.IGSFV_USEC_OCCUR_REFERENCES

View Text

SELECT UOR.REFERENCE_CODE_TYPE REFERENCE_CODE_TYPE
, UOR.REFERENCE_CODE REFERENCE_CODE
, UOR.REFERENCE_CODE_DESC REFERENCE_CODE_DESCRIPTION
, RCT.DESCRIPTION REFERENCE_TYPE_DESCRIPTION
, UOR.UNIT_SEC_OCCUR_REFERENCE_ID UNIT_SEC_OCCUR_REFERENCE_ID
, UOR. UNIT_SECTION_OCCURRENCE_ID UNIT_SECTION_OCCURRENCE_ID
, UOR.CREATED_BY CREATED_BY
, UOR.CREATION_DATE CREATION_DATE
, UOR.LAST_UPDATED_BY LAST_UPDATED_BY
, UOR.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_PS_USEC_OCUR_REF UOR
, IGS_GE_REF_CD_TYPE_ALL RCT
WHERE UOR.REFERENCE_CODE_TYPE = RCT.REFERENCE_CD_TYPE WITH READ ONLY

Columns