[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | A new view to replace the existing cost center table at unit level to allow users to record org unit details along with the cost center details for a unit/version |
| Implementation/DBA Data: | Not implemented in this database |
SELECT UCC.ROWID ROW_ID
, UCC.HESA_UNIT_CC_ID HESA_UNIT_CC_ID
, UCC.UNIT_CD UNIT_CD
, UNT.TITLE UNIT_TITLE
, UNT.SHORT_TITLE UNIT_SHORT_TITLE
, UNT.ABBREVIATION UNIT_ABBREVIATION
, UCC.VERSION_NUMBER VERSION_NUMBER
, UCC.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 = UCC.ORG_UNIT_CD
AND IHP.PARTY_ID = HP.PARTY_ID) ORG_UNIT_DESC
, UCC.COST_CENTRE COST_CENTRE
, (SELECT VALUE_DESCRIPTION
FROM IGS_HE_CODE_VALUES
WHERE CODE_TYPE = 'OSS_COSTCN'
AND VALUE = UCC.COST_CENTRE) COST_CENTRE_DESC
, UCC.SUBJECT SUBJECT
, (SELECT DESCRIPTION
FROM IGS_PS_FLD_OF_STUDY
WHERE FIELD_OF_STUDY = UCC.SUBJECT) SUBJECT_DESC
, UCC.PROPORTION PROPORTION
, UCC.CREATED_BY CREATED_BY
, UCC.CREATION_DATE CREATION_DATE
, UCC.LAST_UPDATED_BY LAST_UPDATED_BY
, UCC.LAST_UPDATE_DATE LAST_UPDATE_DATE
, UCC.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_HE_UNT_OU_CC UCC
, IGS_PS_UNIT_VER_ALL UNT
WHERE UNT.UNIT_CD (+) = UCC.UNIT_CD
AND UNT.VERSION_NUMBER (+) = UCC.VERSION_NUMBER