Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT URF.ROWID ROW_ID
, URF.UNIT_REPEAT_FAMILY_ID UNIT_REPEAT_FAMILY_ID
, URF.UNIT_CODE UNIT_CODE
, URF.UNIT_VERSION_NUMBER UNIT_VERSION_NUMBER
, URF.REPEAT_FMLY_UNIT_CODE REPEAT_FMLY_UNIT_CODE
, URF.REPEAT_FMLY_UNIT_VERSION_NUM REPEAT_FMLY_UNIT_VERSION_NUM
, UV.TITLE UNIT_TITLE
, URF.CREATED_BY CREATED_BY
, URF.CREATION_DATE CREATION_DATE
, URF.LAST_UPDATED_BY LAST_UPDATED_BY
, URF.LAST_UPDATE_DATE LAST_UPDATE_DATE
, URF.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PS_UNT_REPT_FMLY URF
, IGS_PS_UNIT_VER UV
WHERE URF.REPEAT_FMLY_UNIT_CODE = UV.UNIT_CD
AND URF.REPEAT_FMLY_UNIT_VERSION_NUM = UV.VERSION_NUMBER