View: IGSBV_UNIT_CALENDAR_OFFERINGS

Product:	IGS - Student System
Description:	This is a base view, which describes Unit Offerring Pattern of a unit offering option.
Implementation/DBA Data:	APPS.IGSBV_UNIT_CALENDAR_OFFERINGS

View Text

SELECT UN.UNIT_CD
, UN.VERSION_NUMBER
, UN.CAL_TYPE
, UN.CI_SEQUENCE_NUMBER
, UN.CI_START_DT
, UN.CI_END_DT
, UN.WAITLIST_ALLOWED
, UN.MAX_STUDENTS_PER_WAITLIST
, UN.ABORT_FLAG
, UT.TITLE
, TY.DESCRIPTION
, INS.DESCRIPTION
, UN.CREATED_BY
, UN.CREATION_DATE
, UN.LAST_UPDATED_BY
, UN.LAST_UPDATE_DATE
FROM IGS_PS_UNIT_OFR_PAT_ALL UN
, IGS_CA_TYPE TY
, IGS_PS_UNIT_VER_ALL UT
, IGS_CA_INST_ALL INS
WHERE UN.CAL_TYPE=TY.CAL_TYPE
AND UN.UNIT_CD=UT.UNIT_CD
AND UN.VERSION_NUMBER=UT.VERSION_NUMBER
AND UN.CI_SEQUENCE_NUMBER=INS.SEQUENCE_NUMBER
AND UN.CAL_TYPE=INS.CAL_TYPE
AND UN.DELETE_FLAG = 'N' WITH READ ONLY

Columns