View: IGSBV_PROGRAM_OFFERINGS

Product:	IGS - Student System
Description:	This is a base view, which describes an offerings of a university program within a calendar type.
Implementation/DBA Data:	APPS.IGSBV_PROGRAM_OFFERINGS

View Text

SELECT OFR.COURSE_CD
, OFR.VERSION_NUMBER
, OFR.CAL_TYPE
, VE.TITLE
, TY.DESCRIPTION
, OFR.CREATED_BY
, OFR.CREATION_DATE
, OFR.LAST_UPDATED_BY
, OFR.LAST_UPDATE_DATE
FROM IGS_PS_OFR_ALL OFR
, IGS_CA_TYPE TY
, IGS_PS_VER_ALL VE
WHERE OFR.CAL_TYPE = TY.CAL_TYPE
AND OFR.COURSE_CD = VE.COURSE_CD
AND OFR.VERSION_NUMBER =VE.VERSION_NUMBER WITH READ ONLY

Columns