VIEW: APPS.IGSFV_PRG_UK_STAT_COST_CENTRES

Source

View Text - Preformatted

SELECT pc.HE_PROG_CC_ID HESA_STATS_PROGRAM_CC_ID, pc.COURSE_CD PROGRAM_CODE, ps.TITLE PROGRAM_TITLE, ps.SHORT_TITLE PROGRAM_SHORT_TITLE , ps.ABBREVIATION PROGRAM_ABBREVIATION, pc.VERSION_NUMBER PROGRAM_VERSION_NUMBER, pc.COST_CENTRE PROGRAM_COST_CENTRE, ( SELECT VALUE_DESCRIPTION FROM IGS_HE_CODE_VALUES WHERE CODE_TYPE = 'OSS_COSTCN' AND VALUE = pc.COST_CENTRE ) PROGRAM_COST_CENTRE_DESC, pc.SUBJECT PROGRAM_SUBJECT, ( SELECT DESCRIPTION FROM IGS_PS_FLD_OF_STUDY_ALL WHERE FIELD_OF_STUDY= pc.SUBJECT ) PROGRAM_SUBJECT_DESC, pc.PROPORTION PROGRAM_COST_CENTRE_SUBJ_PROP, pc.CREATED_BY CREATED_BY, pc.CREATION_DATE CREATION_DATE, pc.LAST_UPDATED_BY LAST_UPDATED_BY, pc.LAST_UPDATE_DATE LAST_UPDATE_DATE FROM IGS_HE_ST_PROG_CC pc, IGS_PS_VER_ALL ps WHERE pc.COURSE_CD = ps.COURSE_CD AND pc.VERSION_NUMBER = ps.VERSION_NUMBER WITH READ ONLY

View Text - HTML Formatted

SELECT PC.HE_PROG_CC_ID HESA_STATS_PROGRAM_CC_ID
, PC.COURSE_CD PROGRAM_CODE
, PS.TITLE PROGRAM_TITLE
, PS.SHORT_TITLE PROGRAM_SHORT_TITLE
, PS.ABBREVIATION PROGRAM_ABBREVIATION
, PC.VERSION_NUMBER PROGRAM_VERSION_NUMBER
, PC.COST_CENTRE PROGRAM_COST_CENTRE
, ( SELECT VALUE_DESCRIPTION
FROM IGS_HE_CODE_VALUES
WHERE CODE_TYPE = 'OSS_COSTCN'
AND VALUE = PC.COST_CENTRE ) PROGRAM_COST_CENTRE_DESC
, PC.SUBJECT PROGRAM_SUBJECT
, ( SELECT DESCRIPTION
FROM IGS_PS_FLD_OF_STUDY_ALL
WHERE FIELD_OF_STUDY= PC.SUBJECT ) PROGRAM_SUBJECT_DESC
, PC.PROPORTION PROGRAM_COST_CENTRE_SUBJ_PROP
, PC.CREATED_BY CREATED_BY
, PC.CREATION_DATE CREATION_DATE
, PC.LAST_UPDATED_BY LAST_UPDATED_BY
, PC.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_HE_ST_PROG_CC PC
, IGS_PS_VER_ALL PS
WHERE PC.COURSE_CD = PS.COURSE_CD
AND PC.VERSION_NUMBER = PS.VERSION_NUMBER WITH READ ONLY