VIEW: APPS.IGSFV_PROG_CALENDAR_OFFERINGS

Source

View Text - Preformatted

SELECT OI.COURSE_CD, OI.VERSION_NUMBER, OI.CAL_TYPE, OI.CI_SEQUENCE_NUMBER, OI.CI_START_DT, OI.CI_END_DT, OI.MIN_ENTRY_ASS_SCORE, OI.GUARANTEED_ENTRY_ASS_SCR, VE.TITLE, TY.DESCRIPTION, INS.DESCRIPTION, OI.CREATED_BY, OI.CREATION_DATE, OI.LAST_UPDATED_BY, OI.LAST_UPDATE_DATE FROM IGS_PS_OFR_INST OI, IGS_CA_INST_ALL INS, IGS_CA_TYPE TY, IGS_PS_VER_ALL VE WHERE OI.CAL_TYPE=TY.CAL_TYPE AND OI.COURSE_CD=VE.COURSE_CD AND OI.VERSION_NUMBER=VE.VERSION_NUMBER AND OI.CAL_TYPE=INS.CAL_TYPE AND OI.CI_SEQUENCE_NUMBER=INS.SEQUENCE_NUMBER AND OI.CI_START_DT=INS.START_DT AND OI.CI_END_DT=INS.END_DT WITH READ ONLY

View Text - HTML Formatted

SELECT OI.COURSE_CD
, OI.VERSION_NUMBER
, OI.CAL_TYPE
, OI.CI_SEQUENCE_NUMBER
, OI.CI_START_DT
, OI.CI_END_DT
, OI.MIN_ENTRY_ASS_SCORE
, OI.GUARANTEED_ENTRY_ASS_SCR
, VE.TITLE
, TY.DESCRIPTION
, INS.DESCRIPTION
, OI.CREATED_BY
, OI.CREATION_DATE
, OI.LAST_UPDATED_BY
, OI.LAST_UPDATE_DATE
FROM IGS_PS_OFR_INST OI
, IGS_CA_INST_ALL INS
, IGS_CA_TYPE TY
, IGS_PS_VER_ALL VE
WHERE OI.CAL_TYPE=TY.CAL_TYPE
AND OI.COURSE_CD=VE.COURSE_CD
AND OI.VERSION_NUMBER=VE.VERSION_NUMBER
AND OI.CAL_TYPE=INS.CAL_TYPE
AND OI.CI_SEQUENCE_NUMBER=INS.SEQUENCE_NUMBER
AND OI.CI_START_DT=INS.START_DT
AND OI.CI_END_DT=INS.END_DT WITH READ ONLY