Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT PCC.HESA_PROG_CC_ID HESA_PROG_CC_ID
, PCC.COURSE_CD PROGRAM_CODE
, PRG.TITLE PROGRAM_TITLE
, PRG.SHORT_TITLE PROGRAM_SHORT_TITLE
, PRG.ABBREVIATION PROGRAM_ABBREVIATION
, PCC.VERSION_NUMBER PROGRAM_VERSION_NUMBER
, PCC.ORG_UNIT_CD ORG_UNIT_CODE
, (SELECT HP.PARTY_NAME
FROM HZ_PARTIES HP
, IGS_PE_HZ_PARTIES IHP
WHERE IHP.OSS_ORG_UNIT_CD = PCC.ORG_UNIT_CD
AND IHP.PARTY_ID = HP.PARTY_ID) ORG_UNIT_DESC
, PCC.COST_CENTRE PROGRAM_COST_CENTRE
, (SELECT VALUE_DESCRIPTION
FROM IGS_HE_CODE_VALUES
WHERE CODE_TYPE = 'OSS_COSTCN'
AND VALUE = PCC.COST_CENTRE) PROGRAM_COST_CENTRE_DESC
, PCC.SUBJECT PROGRAM_SUBJ
, (SELECT DESCRIPTION
FROM IGS_PS_FLD_OF_STUDY
WHERE FIELD_OF_STUDY = PCC.SUBJECT) PROGRAM_SUBJ_DESC
, PCC.PROPORTION PROGRAM_COST_CENTRE_PROP
, PCC.CREATED_BY CREATED_BY
, PCC.CREATION_DATE CREATION_DATE
, PCC.LAST_UPDATED_BY LAST_UPDATED_BY
, PCC.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_HE_PROG_OU_CC PCC
, IGS_PS_VER_ALL PRG
WHERE PRG.COURSE_CD(+) = PCC.COURSE_CD
AND PRG.VERSION_NUMBER(+) = PCC.VERSION_NUMBER WITH READ ONLY