View: IGSFV_USEC_ALLOC_RESPS

Product:	IGS - Student System
Description:	This is the full view which describes the sponsorship information for a unit section.
Implementation/DBA Data:	APPS.IGSFV_USEC_ALLOC_RESPS

View Text

SELECT US.UNIT_SECTION_SPONSORSHIP_ID
, US.UOO_ID UNIT_SECTION_ID
, US.ORGANIZATION_CODE
, US.SPONSORSHIP_PERCENTAGE
, UN.UNIT_CD UNIT_CODE
, UN.VERSION_NUMBER
, UN.CAL_TYPE CALENDAR_TYPE
, UN.CI_SEQUENCE_NUMBER CAL_INST_SEQUENCE_NUMBER
, UN.LOCATION_CD LOCATION_CODE
, UN.UNIT_CLASS
, US.CREATED_BY
, US.CREATION_DATE
, US.LAST_UPDATED_BY
, US.LAST_UPDATE_DATE
FROM IGS_PS_USEC_SPNSRSHP US
, IGS_PS_UNIT_OFR_OPT_ALL UN
WHERE US.UOO_ID = UN.UOO_ID WITH READ ONLY

Columns