Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT USRRC.ROWID ROW_ID
, USRRC.UNIT_SECTION_REQ_REF_CD_ID UNIT_SECTION_REQ_REF_CD_ID
, USRRC.UNIT_SECTION_REFERENCE_ID UNIT_SECTION_REFERENCE_ID
, NULL REFERENCE_CODE_ID
, USRRC.REFERENCE_CD_TYPE REFERENCE_CD_TYPE
, RCT.DESCRIPTION REFERENCE_CODE_TYPE_DESC
, USRRC.REFERENCE_CODE REFERENCE_CODE
, USRRC.REFERENCE_CODE_DESC REFERENCE_CODE_DESC
, USRRC.CREATED_BY CREATED_BY
, USRRC.CREATION_DATE CREATION_DATE
, USRRC.LAST_UPDATED_BY LAST_UPDATED_BY
, USRRC.LAST_UPDATE_DATE LAST_UPDATE_DATE
, USRRC.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PS_US_REQ_REF_CD USRRC
, IGS_GE_REF_CD_TYPE RCT
WHERE USRRC.REFERENCE_CD_TYPE = RCT.REFERENCE_CD_TYPE