VIEW: APPS.IGSBV_PROG_OFFERING_PATTERNS

Source

View Text - Preformatted

SELECT ofr.COURSE_CD, ofr.VERSION_NUMBER, ofr.CAL_TYPE, ofr.CI_SEQUENCE_NUMBER, ofr.LOCATION_CD, ofr.ATTENDANCE_MODE, ofr.ATTENDANCE_TYPE, ofr.COP_ID, ofr.OFFERED_IND, ofr.CONFIRMED_OFFERING_IND, ofr.ENTRY_POINT_IND, ofr.PRE_ENROL_UNITS_IND, ofr.ENROLLABLE_IND, ofr.IVRS_AVAILABLE_IND, ofr.MIN_ENTRY_ASS_SCORE, ofr.GUARANTEED_ENTRY_ASS_SCR, ofr.MAX_CROSS_FACULTY_CP, ofr.MAX_CROSS_LOCATION_CP, ofr.MAX_CROSS_MODE_CP, ofr.MAX_HIST_CROSS_FACULTY_CP, ofr.GRADING_SCHEMA_CD, ofr.GS_VERSION_NUMBER, ve.TITLE, ty.DESCRIPTION, ins.DESCRIPTION, lo.DESCRIPTION, atm.DESCRIPTION, att.DESCRIPTION, ofr.ADM_ASS_OFFICER_PERSON_ID, ofr.ADM_CONTACT_PERSON_ID, ofr.COO_ID, ofr.CREATED_BY, ofr.CREATION_DATE, ofr.LAST_UPDATED_BY, ofr.LAST_UPDATE_DATE FROM IGS_PS_OFR_PAT ofr, IGS_PS_OFR_INST oi, IGS_PS_OFR_OPT_ALL op, IGS_PS_VER_ALL ve, IGS_CA_TYPE ty, IGS_CA_INST_ALL ins, IGS_AD_LOCATION_ALL lo, IGS_EN_ATD_MODE_ALL atm, IGS_EN_ATD_TYPE_ALL att WHERE ofr.COURSE_CD=oi.COURSE_CD AND ofr.VERSION_NUMBER=oi.VERSION_NUMBER AND ofr.CAL_TYPE=oi.CAL_TYPE AND ofr.CI_SEQUENCE_NUMBER=oi.CI_SEQUENCE_NUMBER AND oi.COURSE_CD=ve.COURSE_CD AND oi.VERSION_NUMBER=ve.VERSION_NUMBER AND oi.CAL_TYPE=ty.CAL_TYPE AND oi.CAL_TYPE=ins.CAL_TYPE AND oi.CI_SEQUENCE_NUMBER=ins.SEQUENCE_NUMBER AND ofr.COURSE_CD =op.COURSE_CD AND ofr.VERSION_NUMBER =op.VERSION_NUMBER AND ofr.CAL_TYPE =op.CAL_TYPE AND ofr.LOCATION_CD =op.LOCATION_CD AND ofr.ATTENDANCE_MODE=op.ATTENDANCE_MODE AND ofr.ATTENDANCE_TYPE=op.ATTENDANCE_TYPE AND op.LOCATION_CD=lo.LOCATION_CD AND op.ATTENDANCE_MODE=atm.ATTENDANCE_MODE AND op.ATTENDANCE_TYPE=att.ATTENDANCE_TYPE WITH READ ONLY

View Text - HTML Formatted

SELECT OFR.COURSE_CD
, OFR.VERSION_NUMBER
, OFR.CAL_TYPE
, OFR.CI_SEQUENCE_NUMBER
, OFR.LOCATION_CD
, OFR.ATTENDANCE_MODE
, OFR.ATTENDANCE_TYPE
, OFR.COP_ID
, OFR.OFFERED_IND
, OFR.CONFIRMED_OFFERING_IND
, OFR.ENTRY_POINT_IND
, OFR.PRE_ENROL_UNITS_IND
, OFR.ENROLLABLE_IND
, OFR.IVRS_AVAILABLE_IND
, OFR.MIN_ENTRY_ASS_SCORE
, OFR.GUARANTEED_ENTRY_ASS_SCR
, OFR.MAX_CROSS_FACULTY_CP
, OFR.MAX_CROSS_LOCATION_CP
, OFR.MAX_CROSS_MODE_CP
, OFR.MAX_HIST_CROSS_FACULTY_CP
, OFR.GRADING_SCHEMA_CD
, OFR.GS_VERSION_NUMBER
, VE.TITLE
, TY.DESCRIPTION
, INS.DESCRIPTION
, LO.DESCRIPTION
, ATM.DESCRIPTION
, ATT.DESCRIPTION
, OFR.ADM_ASS_OFFICER_PERSON_ID
, OFR.ADM_CONTACT_PERSON_ID
, OFR.COO_ID
, OFR.CREATED_BY
, OFR.CREATION_DATE
, OFR.LAST_UPDATED_BY
, OFR.LAST_UPDATE_DATE
FROM IGS_PS_OFR_PAT OFR
, IGS_PS_OFR_INST OI
, IGS_PS_OFR_OPT_ALL OP
, IGS_PS_VER_ALL VE
, IGS_CA_TYPE TY
, IGS_CA_INST_ALL INS
, IGS_AD_LOCATION_ALL LO
, IGS_EN_ATD_MODE_ALL ATM
, IGS_EN_ATD_TYPE_ALL ATT
WHERE OFR.COURSE_CD=OI.COURSE_CD
AND OFR.VERSION_NUMBER=OI.VERSION_NUMBER
AND OFR.CAL_TYPE=OI.CAL_TYPE
AND OFR.CI_SEQUENCE_NUMBER=OI.CI_SEQUENCE_NUMBER
AND OI.COURSE_CD=VE.COURSE_CD
AND OI.VERSION_NUMBER=VE.VERSION_NUMBER
AND OI.CAL_TYPE=TY.CAL_TYPE
AND OI.CAL_TYPE=INS.CAL_TYPE
AND OI.CI_SEQUENCE_NUMBER=INS.SEQUENCE_NUMBER
AND OFR.COURSE_CD =OP.COURSE_CD
AND OFR.VERSION_NUMBER =OP.VERSION_NUMBER
AND OFR.CAL_TYPE =OP.CAL_TYPE
AND OFR.LOCATION_CD =OP.LOCATION_CD
AND OFR.ATTENDANCE_MODE=OP.ATTENDANCE_MODE
AND OFR.ATTENDANCE_TYPE=OP.ATTENDANCE_TYPE
AND OP.LOCATION_CD=LO.LOCATION_CD
AND OP.ATTENDANCE_MODE=ATM.ATTENDANCE_MODE
AND OP.ATTENDANCE_TYPE=ATT.ATTENDANCE_TYPE WITH READ ONLY