VIEW: APPS.IGSBV_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, ypou.CRV_VERSION_NUMBER PROGRAM_VERSION_NUMBER, ypou.CAL_TYPE CALENDAR_TYPE, ypou.LOCATION_CD LOCATION_CODE, ypou.ATTENDANCE_MODE ATTENDANCE_MODE, ypou.ATTENDANCE_TYPE ATTENDANCE_TYPE, ypou.UNIT_SET_CD UNIT_SET_CODE, ypou.US_VERSION_NUMBER UNIT_SET_VERSION_NUMBER, ypou.ORGANIZATION_UNIT ORG_UNIT_CODE, ypcc.COST_CENTRE POOUS_COST_CENTRE, ypcc.SUBJECT POOUS_SUBJ, 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 WHERE ypcc.HESA_POOUS_OU_ID = ypou.HESA_POOUS_OU_ID 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
, YPOU.CRV_VERSION_NUMBER PROGRAM_VERSION_NUMBER
, YPOU.CAL_TYPE CALENDAR_TYPE
, YPOU.LOCATION_CD LOCATION_CODE
, YPOU.ATTENDANCE_MODE ATTENDANCE_MODE
, YPOU.ATTENDANCE_TYPE ATTENDANCE_TYPE
, YPOU.UNIT_SET_CD UNIT_SET_CODE
, YPOU.US_VERSION_NUMBER UNIT_SET_VERSION_NUMBER
, YPOU.ORGANIZATION_UNIT ORG_UNIT_CODE
, YPCC.COST_CENTRE POOUS_COST_CENTRE
, YPCC.SUBJECT POOUS_SUBJ
, 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
WHERE YPCC.HESA_POOUS_OU_ID = YPOU.HESA_POOUS_OU_ID WITH READ ONLY