VIEW: APPS.IGS_PS_OFR_PAT_V

Source

View Text - Preformatted

SELECT cop.course_cd, cop.version_number, cop.cal_type, cop.ci_sequence_number, ci.alternate_code, ci.start_dt, ci.end_dt, ci.cal_status, cop.location_cd, cop.attendance_mode, cop.attendance_type, cop.entry_point_ind, cop.adm_contact_person_id, cop.adm_ass_officer_person_id, crv.title, crv.course_status, crv.course_type, CRV.STD_FT_COMPLETION_TIME, CRV.STD_PT_COMPLETION_TIME, crv.credit_points_required, crv.std_annual_load, crv.course_total_eftsu, cop.CREATED_BY, cop.CREATION_DATE, cop.LAST_UPDATED_BY, cop.LAST_UPDATE_DATE, cop.LAST_UPDATE_LOGIN FROM IGS_PS_OFR_PAT cop, IGS_CA_INST ci, IGS_PS_VER crv WHERE cop.cal_type = ci.cal_type AND cop.ci_sequence_number = ci.sequence_number AND crv.course_cd = cop.course_cd AND crv.version_number = cop.version_number

View Text - HTML Formatted

SELECT COP.COURSE_CD
, COP.VERSION_NUMBER
, COP.CAL_TYPE
, COP.CI_SEQUENCE_NUMBER
, CI.ALTERNATE_CODE
, CI.START_DT
, CI.END_DT
, CI.CAL_STATUS
, COP.LOCATION_CD
, COP.ATTENDANCE_MODE
, COP.ATTENDANCE_TYPE
, COP.ENTRY_POINT_IND
, COP.ADM_CONTACT_PERSON_ID
, COP.ADM_ASS_OFFICER_PERSON_ID
, CRV.TITLE
, CRV.COURSE_STATUS
, CRV.COURSE_TYPE
, CRV.STD_FT_COMPLETION_TIME
, CRV.STD_PT_COMPLETION_TIME
, CRV.CREDIT_POINTS_REQUIRED
, CRV.STD_ANNUAL_LOAD
, CRV.COURSE_TOTAL_EFTSU
, COP.CREATED_BY
, COP.CREATION_DATE
, COP.LAST_UPDATED_BY
, COP.LAST_UPDATE_DATE
, COP.LAST_UPDATE_LOGIN
FROM IGS_PS_OFR_PAT COP
, IGS_CA_INST CI
, IGS_PS_VER CRV
WHERE COP.CAL_TYPE = CI.CAL_TYPE
AND COP.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND CRV.COURSE_CD = COP.COURSE_CD
AND CRV.VERSION_NUMBER = COP.VERSION_NUMBER