eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.IGSFV_POOUS_HESA_COST_CENTRES

Source

View Text - Preformatted


SELECT ypcc.HESA_POOUS_CC_ID HESA_POOUS_CC_ID, ypcc.HESA_POOUS_OU_ID HESA_POOUS_OU_ID, ypou.COURSE_CD PROGRAM_CODE, prg.TITLE PROGRAM_TITLE, prg.SHORT_TITLE PROGRAM_SHORT_TITLE, prg.ABBREVIATION PROGRAM_ABBREVIATION, ypou.CRV_VERSION_NUMBER PROGRAM_VERSION_NUMBER, ypou.CAL_TYPE CALENDAR_TYPE, (SELECT DESCRIPTION FROM IGS_CA_TYPE WHERE CAL_TYPE = ypou.CAL_TYPE) CALENDAR_DESC, (SELECT ABBREVIATION FROM IGS_CA_TYPE WHERE CAL_TYPE = ypou.CAL_TYPE) CALENDAR_ABBREVIATION, ypou.LOCATION_CD LOCATION_CODE, (SELECT DESCRIPTION FROM IGS_AD_LOCATION_ALL WHERE LOCATION_CD = ypou.LOCATION_CD) LOCATION_DESC, ypou.ATTENDANCE_MODE ATTENDANCE_MODE, (SELECT DESCRIPTION FROM IGS_EN_ATD_MODE_ALL WHERE ATTENDANCE_MODE = ypou.ATTENDANCE_MODE) ATTENDANCE_MODE_DESC, ypou.ATTENDANCE_TYPE ATTENDANCE_TYPE, (SELECT DESCRIPTION FROM IGS_EN_ATD_TYPE_ALL WHERE ATTENDANCE_TYPE = ypou.ATTENDANCE_TYPE) ATTENDANCE_TYPE_DESC, ypou.UNIT_SET_CD UNIT_SET_CODE, us.TITLE UNIT_SET_TITLE, us.SHORT_TITLE UNIT_SET_SHORT_TITLE, us.ABBREVIATION UNIT_SET_ABBREVIATION, ypou.US_VERSION_NUMBER UNIT_SET_VERSION_NUMBER, ypou.ORGANIZATION_UNIT ORG_UNIT_CODE, (SELECT HP.PARTY_NAME FROM HZ_PARTIES HP, IGS_PE_HZ_PARTIES IHP WHERE IHP.OSS_ORG_UNIT_CD = ypou.ORGANIZATION_UNIT AND IHP.PARTY_ID = HP.PARTY_ID) ORG_UNIT_DESC, ypcc.COST_CENTRE POOUS_COST_CENTRE, (SELECT VALUE_DESCRIPTION FROM IGS_HE_CODE_VALUES WHERE CODE_TYPE = 'OSS_COSTCN' AND VALUE = ypcc.COST_CENTRE) POOUS_COST_CENTRE_DESC, ypcc.SUBJECT POOUS_SUBJ, (SELECT DESCRIPTION FROM IGS_PS_FLD_OF_STUDY WHERE FIELD_OF_STUDY = ypcc.SUBJECT) POOUS_SUBJ_DESC, ypcc.PROPORTION POOUS_COST_CENTRE_SUBJ_PROP, ypcc.CREATED_BY CREATED_BY, ypcc.CREATION_DATE CREATION_DATE, ypcc.LAST_UPDATED_BY LAST_UPDATED_BY, ypcc.LAST_UPDATE_DATE LAST_UPDATE_DATE FROM IGS_HE_POOUS_OU_CC ypcc, IGS_HE_POOUS_OU_ALL ypou, IGS_PS_VER_ALL prg, IGS_EN_UNIT_SET_ALL us WHERE ypcc.HESA_POOUS_OU_ID = ypou.HESA_POOUS_OU_ID AND prg.COURSE_CD (+) = ypou.COURSE_CD AND prg.VERSION_NUMBER (+) = ypou.CRV_VERSION_NUMBER AND us.UNIT_SET_CD (+) = ypou.UNIT_SET_CD AND us.VERSION_NUMBER (+) = ypou.US_VERSION_NUMBER WITH READ ONLY

View Text - HTML Formatted

SELECT YPCC.HESA_POOUS_CC_ID HESA_POOUS_CC_ID
, YPCC.HESA_POOUS_OU_ID HESA_POOUS_OU_ID
, YPOU.COURSE_CD PROGRAM_CODE
, PRG.TITLE PROGRAM_TITLE
, PRG.SHORT_TITLE PROGRAM_SHORT_TITLE
, PRG.ABBREVIATION PROGRAM_ABBREVIATION
, YPOU.CRV_VERSION_NUMBER PROGRAM_VERSION_NUMBER
, YPOU.CAL_TYPE CALENDAR_TYPE
, (SELECT DESCRIPTION
FROM IGS_CA_TYPE
WHERE CAL_TYPE = YPOU.CAL_TYPE) CALENDAR_DESC
, (SELECT ABBREVIATION
FROM IGS_CA_TYPE
WHERE CAL_TYPE = YPOU.CAL_TYPE) CALENDAR_ABBREVIATION
, YPOU.LOCATION_CD LOCATION_CODE
, (SELECT DESCRIPTION
FROM IGS_AD_LOCATION_ALL
WHERE LOCATION_CD = YPOU.LOCATION_CD) LOCATION_DESC
, YPOU.ATTENDANCE_MODE ATTENDANCE_MODE
, (SELECT DESCRIPTION
FROM IGS_EN_ATD_MODE_ALL
WHERE ATTENDANCE_MODE = YPOU.ATTENDANCE_MODE) ATTENDANCE_MODE_DESC
, YPOU.ATTENDANCE_TYPE ATTENDANCE_TYPE
, (SELECT DESCRIPTION
FROM IGS_EN_ATD_TYPE_ALL
WHERE ATTENDANCE_TYPE = YPOU.ATTENDANCE_TYPE) ATTENDANCE_TYPE_DESC
, YPOU.UNIT_SET_CD UNIT_SET_CODE
, US.TITLE UNIT_SET_TITLE
, US.SHORT_TITLE UNIT_SET_SHORT_TITLE
, US.ABBREVIATION UNIT_SET_ABBREVIATION
, YPOU.US_VERSION_NUMBER UNIT_SET_VERSION_NUMBER
, YPOU.ORGANIZATION_UNIT ORG_UNIT_CODE
, (SELECT HP.PARTY_NAME
FROM HZ_PARTIES HP
, IGS_PE_HZ_PARTIES IHP
WHERE IHP.OSS_ORG_UNIT_CD = YPOU.ORGANIZATION_UNIT
AND IHP.PARTY_ID = HP.PARTY_ID) ORG_UNIT_DESC
, YPCC.COST_CENTRE POOUS_COST_CENTRE
, (SELECT VALUE_DESCRIPTION
FROM IGS_HE_CODE_VALUES
WHERE CODE_TYPE = 'OSS_COSTCN'
AND VALUE = YPCC.COST_CENTRE) POOUS_COST_CENTRE_DESC
, YPCC.SUBJECT POOUS_SUBJ
, (SELECT DESCRIPTION
FROM IGS_PS_FLD_OF_STUDY
WHERE FIELD_OF_STUDY = YPCC.SUBJECT) POOUS_SUBJ_DESC
, YPCC.PROPORTION POOUS_COST_CENTRE_SUBJ_PROP
, YPCC.CREATED_BY CREATED_BY
, YPCC.CREATION_DATE CREATION_DATE
, YPCC.LAST_UPDATED_BY LAST_UPDATED_BY
, YPCC.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_HE_POOUS_OU_CC YPCC
, IGS_HE_POOUS_OU_ALL YPOU
, IGS_PS_VER_ALL PRG
, IGS_EN_UNIT_SET_ALL US
WHERE YPCC.HESA_POOUS_OU_ID = YPOU.HESA_POOUS_OU_ID
AND PRG.COURSE_CD (+) = YPOU.COURSE_CD
AND PRG.VERSION_NUMBER (+) = YPOU.CRV_VERSION_NUMBER
AND US.UNIT_SET_CD (+) = YPOU.UNIT_SET_CD
AND US.VERSION_NUMBER (+) = YPOU.US_VERSION_NUMBER WITH READ ONLY