This is the base view, which describes reference code or codes related to the unit.
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT UN.UNIT_CD , UN.VERSION_NUMBER , UN.REFERENCE_CD_TYPE , UN.REFERENCE_CD , UN.DESCRIPTION , UNV.TITLE , RE.DESCRIPTION , UN.CREATED_BY , UN.CREATION_DATE , UN.LAST_UPDATED_BY , UN.LAST_UPDATE_DATE FROM IGS_PS_UNIT_REF_CD UN , IGS_PS_UNIT_VER_ALL UNV , IGS_GE_REF_CD_TYPE_ALL RE WHERE UN.UNIT_CD=UNV.UNIT_CD AND UN.VERSION_NUMBER=UNV.VERSION_NUMBER AND UN.REFERENCE_CD_TYPE=RE.REFERENCE_CD_TYPE WITH READ ONLY