VIEW: APPS.IGSFV_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, pa1.PARTY_NUMBER, pa2.PARTY_NUMBER, pa1.PARTY_NAME, pa2.PARTY_NAME, gr.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, HZ_PARTIES pa1, HZ_PARTIES pa2, IGS_AS_GRD_SCHEMA gr 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 ofr.COO_ID=op.COO_ID AND op.LOCATION_CD=lo.LOCATION_CD AND op.ATTENDANCE_MODE=atm.ATTENDANCE_MODE AND op.ATTENDANCE_TYPE=att.ATTENDANCE_TYPE AND ofr.ADM_CONTACT_PERSON_ID=pa1.PARTY_ID(+) AND ofr.ADM_ASS_OFFICER_PERSON_ID=pa2.PARTY_ID(+) AND pa1.STATUS(+) ='A' AND pa2.STATUS(+)='A' AND ofr.GRADING_SCHEMA_CD=gr.GRADING_SCHEMA_CD(+) AND ofr.GS_VERSION_NUMBER=gr.VERSION_NUMBER(+) 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
, PA1.PARTY_NUMBER
, PA2.PARTY_NUMBER
, PA1.PARTY_NAME
, PA2.PARTY_NAME
, GR.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
, HZ_PARTIES PA1
, HZ_PARTIES PA2
, IGS_AS_GRD_SCHEMA GR
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 OFR.COO_ID=OP.COO_ID
AND OP.LOCATION_CD=LO.LOCATION_CD
AND OP.ATTENDANCE_MODE=ATM.ATTENDANCE_MODE
AND OP.ATTENDANCE_TYPE=ATT.ATTENDANCE_TYPE
AND OFR.ADM_CONTACT_PERSON_ID=PA1.PARTY_ID(+)
AND OFR.ADM_ASS_OFFICER_PERSON_ID=PA2.PARTY_ID(+)
AND PA1.STATUS(+) ='A'
AND PA2.STATUS(+)='A'
AND OFR.GRADING_SCHEMA_CD=GR.GRADING_SCHEMA_CD(+)
AND OFR.GS_VERSION_NUMBER=GR.VERSION_NUMBER(+) WITH READ ONLY