VIEW: APPS.IGSFV_UNIT_STAT_COST_CENTRES

Source

View Text - Preformatted

SELECT ucc.HESA_ST_UV_CC_ID HESA_STATS_UNIT_CC_ID , ucc.UNIT_CD UNIT_CODE , uv.TITLE UNIT_TITLE, uv.SHORT_TITLE UNIT_SHORT_TITLE, uv.ABBREVIATION UNIT_ABBREVIATION , ucc.VERSION_NUMBER UNIT_VERSION_NUMBER , ucc.COST_CENTRE UNIT_COST_CENTRE, ( SELECT VALUE_DESCRIPTION FROM IGS_HE_CODE_VALUES WHERE CODE_TYPE = 'OSS_COSTCN' AND VALUE = ucc.COST_CENTRE ) UNIT_COST_CENTRE_DESC, ucc.SUBJECT UNIT_SUBJECT , ( SELECT DESCRIPTION FROM IGS_PS_FLD_OF_STUDY_ALL WHERE FIELD_OF_STUDY = ucc.SUBJECT ) UNIT_SUBJECT_DESC, ucc.PROPORTION UNIT_COST_CENTRE_SUBJ_PROP , ucc.CREATED_BY CREATED_BY, ucc.CREATION_DATE CREATION_DATE, ucc.LAST_UPDATED_BY LAST_UPDATED_BY, ucc.LAST_UPDATE_DATE LAST_UPDATE_DATE FROM IGS_HE_ST_UV_CC_ALL ucc , IGS_PS_UNIT_VER_ALL uv WHERE ucc.UNIT_CD = uv.UNIT_CD AND ucc.VERSION_NUMBER = uv.VERSION_NUMBER WITH READ ONLY

View Text - HTML Formatted

SELECT UCC.HESA_ST_UV_CC_ID HESA_STATS_UNIT_CC_ID
, UCC.UNIT_CD UNIT_CODE
, UV.TITLE UNIT_TITLE
, UV.SHORT_TITLE UNIT_SHORT_TITLE
, UV.ABBREVIATION UNIT_ABBREVIATION
, UCC.VERSION_NUMBER UNIT_VERSION_NUMBER
, UCC.COST_CENTRE UNIT_COST_CENTRE
, ( SELECT VALUE_DESCRIPTION
FROM IGS_HE_CODE_VALUES
WHERE CODE_TYPE = 'OSS_COSTCN'
AND VALUE = UCC.COST_CENTRE ) UNIT_COST_CENTRE_DESC
, UCC.SUBJECT UNIT_SUBJECT
, ( SELECT DESCRIPTION
FROM IGS_PS_FLD_OF_STUDY_ALL
WHERE FIELD_OF_STUDY = UCC.SUBJECT ) UNIT_SUBJECT_DESC
, UCC.PROPORTION UNIT_COST_CENTRE_SUBJ_PROP
, UCC.CREATED_BY CREATED_BY
, UCC.CREATION_DATE CREATION_DATE
, UCC.LAST_UPDATED_BY LAST_UPDATED_BY
, UCC.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_HE_ST_UV_CC_ALL UCC
, IGS_PS_UNIT_VER_ALL UV
WHERE UCC.UNIT_CD = UV.UNIT_CD
AND UCC.VERSION_NUMBER = UV.VERSION_NUMBER WITH READ ONLY