VIEW: APPS.IGS_PS_UNIT_OFFER_PAT_V

Source

View Text - Preformatted

SELECT uop.rowid row_id, uop.unit_cd unit_cd, uop.version_number version_number, uv.title title, uop.cal_type calendar_type, ci.alternate_code alternate_code, uop.ci_sequence_number ci_sequence_number, uop.ci_start_dt start_dt, uop.ci_end_dt end_dt, uop.waitlist_allowed waitlist_allowed, uop.max_students_per_waitlist max_students_per_waitlist, uop.created_by created_by, uop.creation_date creation_date, uop.last_updated_by last_updated_by, uop.last_update_date last_update_date, uop.last_update_login last_update_login, uop.request_id request_id, uop.program_application_id program_application_id, uop.program_id program_id, uop.program_update_date program_update_date FROM igs_ps_unit_ver uv, igs_ps_unit_ofr_pat uop, igs_ca_inst ci WHERE uv.unit_cd = uop.unit_cd AND uv.version_number = uop.version_number AND ci.cal_type = uop.cal_type AND ci.sequence_number = uop.ci_sequence_number AND uop.delete_flag = 'N'

View Text - HTML Formatted

SELECT UOP.ROWID ROW_ID
, UOP.UNIT_CD UNIT_CD
, UOP.VERSION_NUMBER VERSION_NUMBER
, UV.TITLE TITLE
, UOP.CAL_TYPE CALENDAR_TYPE
, CI.ALTERNATE_CODE ALTERNATE_CODE
, UOP.CI_SEQUENCE_NUMBER CI_SEQUENCE_NUMBER
, UOP.CI_START_DT START_DT
, UOP.CI_END_DT END_DT
, UOP.WAITLIST_ALLOWED WAITLIST_ALLOWED
, UOP.MAX_STUDENTS_PER_WAITLIST MAX_STUDENTS_PER_WAITLIST
, UOP.CREATED_BY CREATED_BY
, UOP.CREATION_DATE CREATION_DATE
, UOP.LAST_UPDATED_BY LAST_UPDATED_BY
, UOP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, UOP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, UOP.REQUEST_ID REQUEST_ID
, UOP.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, UOP.PROGRAM_ID PROGRAM_ID
, UOP.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
FROM IGS_PS_UNIT_VER UV
, IGS_PS_UNIT_OFR_PAT UOP
, IGS_CA_INST CI
WHERE UV.UNIT_CD = UOP.UNIT_CD
AND UV.VERSION_NUMBER = UOP.VERSION_NUMBER
AND CI.CAL_TYPE = UOP.CAL_TYPE
AND CI.SEQUENCE_NUMBER = UOP.CI_SEQUENCE_NUMBER
AND UOP.DELETE_FLAG = 'N'