DBA Data[Home] [Help]

VIEW: APPS.IGSBV_ACAD_UNIT_DISCIPLINES

Source

View Text - Preformatted

SELECT UD.UNIT_CD, UD.VERSION_NUMBER, UD.DISCIPLINE_GROUP_CD, UD.PERCENTAGE, UV.TITLE, DS.DESCRIPTION, UD.CREATED_BY, UD.CREATION_DATE, UD.LAST_UPDATED_BY, UD.LAST_UPDATE_DATE FROM IGS_PS_UNIT_DSCP UD, IGS_PS_UNIT_VER_ALL UV, IGS_PS_DSCP_ALL DS WHERE UD.UNIT_CD = UV.UNIT_CD AND UD.VERSION_NUMBER = UV.VERSION_NUMBER AND UD.DISCIPLINE_GROUP_CD = DS.DISCIPLINE_GROUP_CD with read only
View Text - HTML Formatted

SELECT UD.UNIT_CD
, UD.VERSION_NUMBER
, UD.DISCIPLINE_GROUP_CD
, UD.PERCENTAGE
, UV.TITLE
, DS.DESCRIPTION
, UD.CREATED_BY
, UD.CREATION_DATE
, UD.LAST_UPDATED_BY
, UD.LAST_UPDATE_DATE
FROM IGS_PS_UNIT_DSCP UD
, IGS_PS_UNIT_VER_ALL UV
, IGS_PS_DSCP_ALL DS
WHERE UD.UNIT_CD = UV.UNIT_CD
AND UD.VERSION_NUMBER = UV.VERSION_NUMBER
AND UD.DISCIPLINE_GROUP_CD = DS.DISCIPLINE_GROUP_CD WITH READ ONLY