[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Full business view to allow queries on Org Unit HESA Cost Center Details |
| Implementation/DBA Data: | Not implemented in this database |
SELECT OUCC.HESA_OU_CC_ID HESA_OU_CC_ID
, OUCC.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 = OUCC.ORG_UNIT_CD
AND IHP.PARTY_ID = HP.PARTY_ID) ORG_UNIT_DESC
, OUCC.COST_CENTRE ORG_UNIT_COST_CENTRE
, (SELECT VALUE_DESCRIPTION
FROM IGS_HE_CODE_VALUES
WHERE CODE_TYPE = 'OSS_COSTCN'
AND VALUE = OUCC.COST_CENTRE) ORG_UNIT_COST_CENTRE_DESC
, OUCC.SUBJECT ORG_UNIT_SUBJ
, (SELECT DESCRIPTION
FROM IGS_PS_FLD_OF_STUDY
WHERE FIELD_OF_STUDY = OUCC.SUBJECT) ORG_UNIT_SUBJ_DESC
, OUCC.PROPORTION ORG_UNIT_COST_CENTRE_SUBJ_PROP
, OUCC.CREATED_BY CREATED_BY
, OUCC.CREATION_DATE CREATION_DATE
, OUCC.LAST_UPDATED_BY LAST_UPDATED_BY
, OUCC.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_HE_OU_CC OUCC WITH READ ONLY