VIEW: APPS.IGSFV_UNIT_CALENDAR_OFFERINGS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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