Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This is the full view, which describes the relation between unit sections reference and reference codes |
Implementation/DBA Data: | Not implemented in this database |
SELECT US.REFERENCE_CODE_TYPE
, US.REFERENCE_CODE
, US.REFERENCE_CODE_DESC
, US.UNIT_SECTION_REFERENCE_CD_ID USEC_REFERENCE_CODE_ID
, NULL REFERENCE_CODE_ID
, US.UNIT_SECTION_REFERENCE_ID
, RE.DESCRIPTION REFERENCE_CODE_TYPE_DESC
, NULL REFERENCE_DESCRIPTION
, USR.TITLE UNIT_SECTION_REFERENCE_TITLE
, US.CREATED_BY
, US.CREATION_DATE
, US.LAST_UPDATED_BY
, US.LAST_UPDATE_DATE
FROM IGS_PS_USEC_REF_CD US
, IGS_GE_REF_CD_TYPE RE
, IGS_PS_USEC_REF USR
WHERE US.REFERENCE_CODE_TYPE=RE.REFERENCE_CD_TYPE
AND US.UNIT_SECTION_REFERENCE_ID = USR.UNIT_SECTION_REFERENCE_ID WITH READ ONLY