VIEW: APPS.IGSFV_PROG_CAL_OFFERINGS

Source

View Text - Preformatted

SELECT UOP.COURSE_CD PROGRAM_CODE, UOP.VERSION_NUMBER, UOP.CAL_TYPE, UOP.LOCATION_CD, UOP.ATTENDANCE_MODE, UOP.ATTENDANCE_TYPE, UOP.FORCED_LOCATION_IND, UOP.FORCED_ATT_MODE_IND, UOP.FORCED_ATT_TYPE_IND, UOP.TIME_LIMITATION, UOP.ENR_OFFICER_PERSON_ID, '_DF:IGS:IGS_PS_PRG_OFR_OPT_FLEX:UOP', UOP.PROGRAM_LENGTH PROGRAM_LENGTH, '_LA:PROGRAM_LENGTH_MEASUREMENT:IGS_LOOKUP_VALUES:IGS_PS_PROGRAM_LENGTH_MESR:MEANING' "_LA:PROGRAM_LENGTH_MEASURE", UOP.DELETE_FLAG DELETE_FLAG, PSV.TITLE PROGRAM_TITLE, CTY.DESCRIPTION CALENDAR_DESCRIPTION, LOC.DESCRIPTION LOCATION_DESCRIPTION, ATD.DESCRIPTION ATTENDANCE_TYPE_DESC, ATM.DESCRIPTION ATTENDANCE_MODE_DESC, HP.PARTY_NAME ENR_OFFICER_PERSON_NAME, UOP.COO_ID, UOP.CREATED_BY, UOP.CREATION_DATE, UOP.LAST_UPDATED_BY, UOP.LAST_UPDATE_DATE FROM IGS_PS_OFR_OPT_ALL UOP, IGS_PS_VER_ALL PSV, IGS_CA_TYPE CTY, IGS_AD_LOCATION_ALL LOC, HZ_PARTIES HP, IGS_EN_ATD_TYPE_ALL ATD, IGS_EN_ATD_MODE_ALL ATM WHERE UOP.COURSE_CD = PSV.COURSE_CD AND UOP.VERSION_NUMBER = PSV.VERSION_NUMBER AND UOP.CAL_TYPE = CTY.CAL_TYPE AND UOP.ENR_OFFICER_PERSON_ID = HP.PARTY_ID(+) AND HP.STATUS(+)='A' AND UOP.LOCATION_CD = LOC.LOCATION_CD AND UOP.ATTENDANCE_TYPE=ATD.ATTENDANCE_TYPE AND UOP.ATTENDANCE_MODE=ATM.ATTENDANCE_MODE WITH READ ONLY

View Text - HTML Formatted

SELECT UOP.COURSE_CD PROGRAM_CODE
, UOP.VERSION_NUMBER
, UOP.CAL_TYPE
, UOP.LOCATION_CD
, UOP.ATTENDANCE_MODE
, UOP.ATTENDANCE_TYPE
, UOP.FORCED_LOCATION_IND
, UOP.FORCED_ATT_MODE_IND
, UOP.FORCED_ATT_TYPE_IND
, UOP.TIME_LIMITATION
, UOP.ENR_OFFICER_PERSON_ID
, '_DF:IGS:IGS_PS_PRG_OFR_OPT_FLEX:UOP'
, UOP.PROGRAM_LENGTH PROGRAM_LENGTH
, '_LA:PROGRAM_LENGTH_MEASUREMENT:IGS_LOOKUP_VALUES:IGS_PS_PROGRAM_LENGTH_MESR:MEANING' "_LA:PROGRAM_LENGTH_MEASURE"
, UOP.DELETE_FLAG DELETE_FLAG
, PSV.TITLE PROGRAM_TITLE
, CTY.DESCRIPTION CALENDAR_DESCRIPTION
, LOC.DESCRIPTION LOCATION_DESCRIPTION
, ATD.DESCRIPTION ATTENDANCE_TYPE_DESC
, ATM.DESCRIPTION ATTENDANCE_MODE_DESC
, HP.PARTY_NAME ENR_OFFICER_PERSON_NAME
, UOP.COO_ID
, UOP.CREATED_BY
, UOP.CREATION_DATE
, UOP.LAST_UPDATED_BY
, UOP.LAST_UPDATE_DATE
FROM IGS_PS_OFR_OPT_ALL UOP
, IGS_PS_VER_ALL PSV
, IGS_CA_TYPE CTY
, IGS_AD_LOCATION_ALL LOC
, HZ_PARTIES HP
, IGS_EN_ATD_TYPE_ALL ATD
, IGS_EN_ATD_MODE_ALL ATM
WHERE UOP.COURSE_CD = PSV.COURSE_CD
AND UOP.VERSION_NUMBER = PSV.VERSION_NUMBER
AND UOP.CAL_TYPE = CTY.CAL_TYPE
AND UOP.ENR_OFFICER_PERSON_ID = HP.PARTY_ID(+)
AND HP.STATUS(+)='A'
AND UOP.LOCATION_CD = LOC.LOCATION_CD
AND UOP.ATTENDANCE_TYPE=ATD.ATTENDANCE_TYPE
AND UOP.ATTENDANCE_MODE=ATM.ATTENDANCE_MODE WITH READ ONLY