FND Design Data [Home] [Help]

View: IGSBV_PRG_OFR_OPT_COST_CENTRES

Product: IGS - Student System (Obsolete)
Description: Base View for Program Offering Option Unit Set HESA Details - Cost Center Details
Implementation/DBA Data: Not implemented in this database
View Text

SELECT POC.HESA_POOUS_CC_ID HESA_POOUS_CC_ID
, POC.COURSE_CD PROGRAM_CODE
, POC.CRV_VERSION_NUMBER PROGRAM_VERSION_NUMBER
, POC.CAL_TYPE CALENDAR_TYPE
, POC.LOCATION_CD LOCATION_CODE
, POC.ATTENDANCE_MODE ATTENDANCE_MODE
, POC.ATTENDANCE_TYPE ATTENDANCE_TYPE
, POC.UNIT_SET_CD UNIT_SET_CODE
, POC.US_VERSION_NUMBER UNIT_SET_VERSION_NUMBER
, POC.COST_CENTRE PROGRAM_COST_CENTRE
, POC.SUBJECT PROGRAM_SUBJECT
, POC.PROPORTION PROGRAM_COST_CENTRE_SUBJ_PROP
, POC.CREATED_BY CREATED_BY
, POC.CREATION_DATE CREATION_DATE
, POC.LAST_UPDATED_BY LAST_UPDATED_BY
, POC.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_HE_POOUS_CC_ALL POC WITH READ ONLY

Columns

Name
HESA_POOUS_CC_ID
PROGRAM_CODE
PROGRAM_VERSION_NUMBER
CALENDAR_TYPE
LOCATION_CODE
ATTENDANCE_MODE
ATTENDANCE_TYPE
UNIT_SET_CODE
UNIT_SET_VERSION_NUMBER
PROGRAM_COST_CENTRE
PROGRAM_SUBJECT
PROGRAM_COST_CENTRE_SUBJ_PROP
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE