View: IGSBV_POOUS_HESA_COST_CENTRES

Product:	IGS - Student System
Description:	Base business view to allow queries on Program Offering Option Unit Set HESA Cost Center Details
Implementation/DBA Data:	APPS.IGSBV_POOUS_HESA_COST_CENTRES

View Text

SELECT YPCC.HESA_POOUS_CC_ID HESA_POOUS_CC_ID
, YPCC.HESA_POOUS_OU_ID HESA_POOUS_OU_ID
, YPOU.COURSE_CD PROGRAM_CODE
, YPOU.CRV_VERSION_NUMBER PROGRAM_VERSION_NUMBER
, YPOU.CAL_TYPE CALENDAR_TYPE
, YPOU.LOCATION_CD LOCATION_CODE
, YPOU.ATTENDANCE_MODE ATTENDANCE_MODE
, YPOU.ATTENDANCE_TYPE ATTENDANCE_TYPE
, YPOU.UNIT_SET_CD UNIT_SET_CODE
, YPOU.US_VERSION_NUMBER UNIT_SET_VERSION_NUMBER
, YPOU.ORGANIZATION_UNIT ORG_UNIT_CODE
, YPCC.COST_CENTRE POOUS_COST_CENTRE
, YPCC.SUBJECT POOUS_SUBJ
, YPCC.PROPORTION POOUS_COST_CENTRE_SUBJ_PROP
, YPCC.CREATED_BY CREATED_BY
, YPCC.CREATION_DATE CREATION_DATE
, YPCC.LAST_UPDATED_BY LAST_UPDATED_BY
, YPCC.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_HE_POOUS_OU_CC YPCC
, IGS_HE_POOUS_OU_ALL YPOU
WHERE YPCC.HESA_POOUS_OU_ID = YPOU.HESA_POOUS_OU_ID WITH READ ONLY

Columns