View: IGSBV_ST_UNIT_SET_ATT_COST_CNT

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

View Text

SELECT UCC.HE_SUSA_CC_ID HE_SUSA_CC_ID
, UCC.PERSON_ID PERSON_ID
, PER.PARTY_NUMBER PERSON_NUMBER
, UCC.COURSE_CD PROGRAM_CODE
, UCC.UNIT_SET_CD UNIT_SET_CODE
, UCC.SEQUENCE_NUMBER SEQUENCE_NUMBER
, UCC.COST_CENTRE SUSA_COST_CENTRE
, UCC.SUBJECT SUSA_SUBJ
, UCC.PROPORTION SUSA_COST_CENTRE_SUBJ_PROP
, UCC.CREATED_BY CREATED_BY
, UCC.CREATION_DATE CREATION_DATE
, UCC.LAST_UPDATED_BY LAST_UPDATED_BY
, UCC.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_HE_EN_SUSA_CC UCC
, HZ_PARTIES PER
WHERE PER.PARTY_ID = UCC.PERSON_ID WITH READ ONLY

Columns