[Home] [Help]
View: IGSBV_PROG_HESA_COST_CENTRES
Product: | IGS - Student System |
Description: | Base business view to allow queries on Program HESA Cost Center Details |
Implementation/DBA Data: |
APPS.IGSBV_PROG_HESA_COST_CENTRES
|
View Text
SELECT PCC.HESA_PROG_CC_ID HESA_PROG_CC_ID
, PCC.COURSE_CD PROGRAM_CODE
, PCC.VERSION_NUMBER PROGRAM_VERSION_NUMBER
, PCC.ORG_UNIT_CD ORG_UNIT_CODE
, PCC.COST_CENTRE PROGRAM_COST_CENTRE
, PCC.SUBJECT PROGRAM_SUBJ
, 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 WITH READ ONLY
Columns
Name |
HESA_PROG_CC_ID |
PROGRAM_CODE |
PROGRAM_VERSION_NUMBER |
ORG_UNIT_CODE |
PROGRAM_COST_CENTRE |
PROGRAM_SUBJ |
PROGRAM_COST_CENTRE_PROP |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |