[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | A new view to replace the existing cost center table at program level to allow users to record org unit details along with the cost center details for a program/version |
| Implementation/DBA Data: | Not implemented in this database |
SELECT PCC.ROWID ROW_ID
, PCC.HESA_PROG_CC_ID HESA_PROG_CC_ID
, PCC.COURSE_CD COURSE_CD
, PRG.TITLE PROGRAM_TITLE
, PRG.SHORT_TITLE PROGRAM_SHORT_TITLE
, PRG.ABBREVIATION PROGRAM_ABBREVIATION
, PCC.VERSION_NUMBER VERSION_NUMBER
, PCC.ORG_UNIT_CD ORG_UNIT_CD
, (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 COST_CENTRE
, (SELECT VALUE_DESCRIPTION
FROM IGS_HE_CODE_VALUES
WHERE CODE_TYPE = 'OSS_COSTCN'
AND VALUE = PCC.COST_CENTRE) COST_CENTRE_DESC
, PCC.SUBJECT SUBJECT
, (SELECT DESCRIPTION
FROM IGS_PS_FLD_OF_STUDY
WHERE FIELD_OF_STUDY = PCC.SUBJECT) SUBJECT_DESC
, PCC.PROPORTION PROPORTION
, PCC.CREATED_BY CREATED_BY
, PCC.CREATION_DATE CREATION_DATE
, PCC.LAST_UPDATED_BY LAST_UPDATED_BY
, PCC.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PCC.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
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