VIEW: APPS.IGSFV_PROGRAM_OFFERINGS

Source

View Text - Preformatted

SELECT ofr.COURSE_CD, ofr.VERSION_NUMBER, ofr.CAL_TYPE, '_DF:IGS:IGS_PS_PRG_OFR_FLEX:OFR', 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

View Text - HTML Formatted

SELECT OFR.COURSE_CD
, OFR.VERSION_NUMBER
, OFR.CAL_TYPE
, '_DF:IGS:IGS_PS_PRG_OFR_FLEX:OFR'
, 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