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