VIEW: APPS.IGSFV_UK_PRG_OFR_OPT_ORG_UNITS

Source

View Text - Preformatted

SELECT pou.HESA_POOUS_OU_ID HESA_POOUS_OU_ID , pou.COURSE_CD PROGRAM_CODE , ps.TITLE PROGRAM_TITLE, ps.SHORT_TITLE PROGRAM_SHORT_TITLE, ps.ABBREVIATION PROGRAM_ABBREVIATION , pou.CRV_VERSION_NUMBER PROGRAM_VERSION_NUMBER, pou.CAL_TYPE CALENDAR_TYPE , ca.DESCRIPTION CALENDAR_DESC, ca.ABBREVIATION CALENDAR_ABBREVIATION, pou.LOCATION_CD LOCATION_CODE , ( SELECT DESCRIPTION FROM IGS_AD_LOCATION_ALL WHERE LOCATION_CD = pou.LOCATION_CD) LOCATION_DESC , pou.ATTENDANCE_MODE ATTENDANCE_MODE, ( SELECT DESCRIPTION FROM IGS_EN_ATD_MODE_ALL WHERE ATTENDANCE_MODE = pou.ATTENDANCE_MODE ) ATTENDANCE_MODE_DESC, pou.ATTENDANCE_TYPE ATTENDANCE_TYPE, ( SELECT DESCRIPTION FROM IGS_EN_ATD_TYPE_ALL WHERE ATTENDANCE_TYPE = pou.ATTENDANCE_TYPE ) ATTENDANCE_TYPE_DESC , pou.UNIT_SET_CD UNIT_SET_CODE, en.TITLE UNIT_SET_TITLE , en.SHORT_TITLE UNIT_SET_SHORT_TITLE, en.ABBREVIATION UNIT_SET_ABBREVIATION , pou.US_VERSION_NUMBER UNIT_SET_VERSION_NUMBER, pou.ORGANIZATION_UNIT ORGANIZATION_UNIT_CODE , ( SELECT HP.PARTY_NAME FROM HZ_PARTIES HP, IGS_PE_HZ_PARTIES IHP WHERE IHP.OSS_ORG_UNIT_CD = pou.ORGANIZATION_UNIT AND IHP.PARTY_ID = HP.PARTY_ID) ORGANIZATION_UNIT_NAME, pou.PROPORTION ORGANIZATION_UNIT_PROP , pou.CREATED_BY CREATED_BY, pou.CREATION_DATE CREATION_DATE, pou.LAST_UPDATED_BY LAST_UPDATED_BY, pou.LAST_UPDATE_DATE LAST_UPDATE_DATE FROM IGS_HE_POOUS_OU_ALL pou, IGS_PS_VER_ALL ps , IGS_EN_UNIT_SET_ALL en ,IGS_CA_TYPE ca WHERE pou.COURSE_CD = ps.COURSE_CD AND pou.CRV_VERSION_NUMBER = ps.VERSION_NUMBER AND pou.UNIT_SET_CD = en.UNIT_SET_cd AND pou.US_VERSION_NUMBER = en.VERSION_NUMBER AND pou.cal_type = ca.CAL_TYPE WITH READ ONLY

View Text - HTML Formatted

SELECT POU.HESA_POOUS_OU_ID HESA_POOUS_OU_ID
, POU.COURSE_CD PROGRAM_CODE
, PS.TITLE PROGRAM_TITLE
, PS.SHORT_TITLE PROGRAM_SHORT_TITLE
, PS.ABBREVIATION PROGRAM_ABBREVIATION
, POU.CRV_VERSION_NUMBER PROGRAM_VERSION_NUMBER
, POU.CAL_TYPE CALENDAR_TYPE
, CA.DESCRIPTION CALENDAR_DESC
, CA.ABBREVIATION CALENDAR_ABBREVIATION
, POU.LOCATION_CD LOCATION_CODE
, ( SELECT DESCRIPTION
FROM IGS_AD_LOCATION_ALL
WHERE LOCATION_CD = POU.LOCATION_CD) LOCATION_DESC
, POU.ATTENDANCE_MODE ATTENDANCE_MODE
, ( SELECT DESCRIPTION
FROM IGS_EN_ATD_MODE_ALL
WHERE ATTENDANCE_MODE = POU.ATTENDANCE_MODE ) ATTENDANCE_MODE_DESC
, POU.ATTENDANCE_TYPE ATTENDANCE_TYPE
, ( SELECT DESCRIPTION
FROM IGS_EN_ATD_TYPE_ALL
WHERE ATTENDANCE_TYPE = POU.ATTENDANCE_TYPE ) ATTENDANCE_TYPE_DESC
, POU.UNIT_SET_CD UNIT_SET_CODE
, EN.TITLE UNIT_SET_TITLE
, EN.SHORT_TITLE UNIT_SET_SHORT_TITLE
, EN.ABBREVIATION UNIT_SET_ABBREVIATION
, POU.US_VERSION_NUMBER UNIT_SET_VERSION_NUMBER
, POU.ORGANIZATION_UNIT ORGANIZATION_UNIT_CODE
, ( SELECT HP.PARTY_NAME
FROM HZ_PARTIES HP
, IGS_PE_HZ_PARTIES IHP
WHERE IHP.OSS_ORG_UNIT_CD = POU.ORGANIZATION_UNIT
AND IHP.PARTY_ID = HP.PARTY_ID) ORGANIZATION_UNIT_NAME
, POU.PROPORTION ORGANIZATION_UNIT_PROP
, POU.CREATED_BY CREATED_BY
, POU.CREATION_DATE CREATION_DATE
, POU.LAST_UPDATED_BY LAST_UPDATED_BY
, POU.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_HE_POOUS_OU_ALL POU
, IGS_PS_VER_ALL PS
, IGS_EN_UNIT_SET_ALL EN
, IGS_CA_TYPE CA
WHERE POU.COURSE_CD = PS.COURSE_CD
AND POU.CRV_VERSION_NUMBER = PS.VERSION_NUMBER
AND POU.UNIT_SET_CD = EN.UNIT_SET_CD
AND POU.US_VERSION_NUMBER = EN.VERSION_NUMBER
AND POU.CAL_TYPE = CA.CAL_TYPE WITH READ ONLY