VIEW: APPS.IGSFV_PRG_OFR_OPT_COST_CENTRES

Source

View Text - Preformatted

SELECT poc.HESA_POOUS_CC_ID HESA_POOUS_CC_ID, poc.COURSE_CD PROGRAM_CODE , ps.TITLE PROGRAM_TITLE, ps.SHORT_TITLE PROGRAM_SHORT_TITLE, ps.ABBREVIATION PROGRAM_ABBREVIATION, poc.CRV_VERSION_NUMBER PROGRAM_VERSION_NUMBER, poc.CAL_TYPE CALENDAR_TYPE, ca.DESCRIPTION CALENDAR_DESC , ca.ABBREVIATION CALENDAR_ABBREVIATION, poc.LOCATION_CD LOCATION_CODE, ( SELECT DESCRIPTION FROM IGS_AD_LOCATION_ALL WHERE LOCATION_CD = poc.LOCATION_CD) LOCATION_DESC , poc.ATTENDANCE_MODE ATTENDANCE_MODE, ( SELECT DESCRIPTION FROM IGS_EN_ATD_MODE_ALL WHERE ATTENDANCE_MODE = poc.ATTENDANCE_MODE ) ATTENDANCE_MODE_DESC , poc.ATTENDANCE_TYPE ATTENDANCE_TYPE, ( SELECT DESCRIPTION FROM IGS_EN_ATD_TYPE_ALL WHERE ATTENDANCE_TYPE = poc.ATTENDANCE_TYPE ) ATTENDANCE_TYPE_DESC, poc.UNIT_SET_CD UNIT_SET_CODE, en.TITLE UNIT_SET_TITLE, en.SHORT_TITLE UNIT_SET_SHORT_TITLE, en.ABBREVIATION UNIT_SET_ABBREVIATION, poc.US_VERSION_NUMBER UNIT_SET_VERSION_NUMBER, poc.COST_CENTRE PROGRAM_COST_CENTRE, ( SELECT VALUE_DESCRIPTION FROM IGS_HE_CODE_VALUES WHERE CODE_TYPE = 'OSS_COSTCN' AND VALUE = poc.COST_CENTRE ) PROGRAM_COST_CENTRE_DESC, poc.SUBJECT PROGRAM_SUBJECT , ( SELECT DESCRIPTION FROM IGS_PS_FLD_OF_STUDY_ALL WHERE FIELD_OF_STUDY = poc.SUBJECT ) PROGRAM_SUBJECT_DESC, poc.PROPORTION PROGRAM_COST_CENTRE_SUBJ_PROP, poc.CREATED_BY CREATED_BY, poc.CREATION_DATE CREATION_DATE, poc.LAST_UPDATED_BY LAST_UPDATED_BY, poc.LAST_UPDATE_DATE LAST_UPDATE_DATE FROM IGS_HE_POOUS_CC_ALL poc, IGS_PS_VER_ALL ps , IGS_EN_UNIT_SET_ALL en ,IGS_CA_TYPE ca WHERE poc.COURSE_CD = ps.COURSE_CD AND poc.CRV_VERSION_NUMBER = ps.VERSION_NUMBER AND poc.UNIT_SET_CD = en.UNIT_SET_cd AND poc.US_VERSION_NUMBER = en.VERSION_NUMBER AND poc.cal_type = ca.CAL_TYPE WITH READ ONLY

View Text - HTML Formatted

SELECT POC.HESA_POOUS_CC_ID HESA_POOUS_CC_ID
, POC.COURSE_CD PROGRAM_CODE
, PS.TITLE PROGRAM_TITLE
, PS.SHORT_TITLE PROGRAM_SHORT_TITLE
, PS.ABBREVIATION PROGRAM_ABBREVIATION
, POC.CRV_VERSION_NUMBER PROGRAM_VERSION_NUMBER
, POC.CAL_TYPE CALENDAR_TYPE
, CA.DESCRIPTION CALENDAR_DESC
, CA.ABBREVIATION CALENDAR_ABBREVIATION
, POC.LOCATION_CD LOCATION_CODE
, ( SELECT DESCRIPTION
FROM IGS_AD_LOCATION_ALL
WHERE LOCATION_CD = POC.LOCATION_CD) LOCATION_DESC
, POC.ATTENDANCE_MODE ATTENDANCE_MODE
, ( SELECT DESCRIPTION
FROM IGS_EN_ATD_MODE_ALL
WHERE ATTENDANCE_MODE = POC.ATTENDANCE_MODE ) ATTENDANCE_MODE_DESC
, POC.ATTENDANCE_TYPE ATTENDANCE_TYPE
, ( SELECT DESCRIPTION
FROM IGS_EN_ATD_TYPE_ALL
WHERE ATTENDANCE_TYPE = POC.ATTENDANCE_TYPE ) ATTENDANCE_TYPE_DESC
, POC.UNIT_SET_CD UNIT_SET_CODE
, EN.TITLE UNIT_SET_TITLE
, EN.SHORT_TITLE UNIT_SET_SHORT_TITLE
, EN.ABBREVIATION UNIT_SET_ABBREVIATION
, POC.US_VERSION_NUMBER UNIT_SET_VERSION_NUMBER
, POC.COST_CENTRE PROGRAM_COST_CENTRE
, ( SELECT VALUE_DESCRIPTION
FROM IGS_HE_CODE_VALUES
WHERE CODE_TYPE = 'OSS_COSTCN'
AND VALUE = POC.COST_CENTRE ) PROGRAM_COST_CENTRE_DESC
, POC.SUBJECT PROGRAM_SUBJECT
, ( SELECT DESCRIPTION
FROM IGS_PS_FLD_OF_STUDY_ALL
WHERE FIELD_OF_STUDY = POC.SUBJECT ) PROGRAM_SUBJECT_DESC
, POC.PROPORTION PROGRAM_COST_CENTRE_SUBJ_PROP
, POC.CREATED_BY CREATED_BY
, POC.CREATION_DATE CREATION_DATE
, POC.LAST_UPDATED_BY LAST_UPDATED_BY
, POC.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_HE_POOUS_CC_ALL POC
, IGS_PS_VER_ALL PS
, IGS_EN_UNIT_SET_ALL EN
, IGS_CA_TYPE CA
WHERE POC.COURSE_CD = PS.COURSE_CD
AND POC.CRV_VERSION_NUMBER = PS.VERSION_NUMBER
AND POC.UNIT_SET_CD = EN.UNIT_SET_CD
AND POC.US_VERSION_NUMBER = EN.VERSION_NUMBER
AND POC.CAL_TYPE = CA.CAL_TYPE WITH READ ONLY