VIEW: APPS.IGSFV_ST_UNIT_SET_ATT_COST_CNT

Source

View Text - Preformatted

SELECT ucc.HE_SUSA_CC_ID HE_SUSA_CC_ID, ucc.PERSON_ID PERSON_ID, per.PARTY_NUMBER PERSON_NUMBER, per.PERSON_LAST_NAME PERSON_SURNAME, per.PERSON_FIRST_NAME PERSON_GIVEN_NAMES, perp.PERSON_NAME PERSON_FULL_NAME, ucc.COURSE_CD PROGRAM_CODE, ps.TITLE PROGRAM_TITLE, ps.SHORT_TITLE PROGRAM_SHORT_TITLE, ps.ABBREVIATION PROGRAM_ABBREVIATION, ucc.UNIT_SET_CD UNIT_SET_CODE, us.TITLE UNIT_SET_TITLE, us.SHORT_TITLE UNIT_SET_SHORT_TITLE, us.ABBREVIATION UNIT_SET_ABBREVIATION, ucc.SEQUENCE_NUMBER SEQUENCE_NUMBER, ucc.COST_CENTRE SUSA_COST_CENTRE, (SELECT VALUE_DESCRIPTION FROM IGS_HE_CODE_VALUES WHERE CODE_TYPE = 'OSS_COSTCN' AND VALUE = ucc.COST_CENTRE) SUSA_COST_CENTRE_DESC, ucc.SUBJECT SUSA_SUBJ, (SELECT DESCRIPTION FROM IGS_PS_FLD_OF_STUDY_ALL WHERE FIELD_OF_STUDY = ucc.SUBJECT) SUSA_SUBJ_DESC, ucc.PROPORTION SUSA_COST_CENTRE_SUBJ_PROP, ucc.CREATED_BY CREATED_BY, ucc.CREATION_DATE CREATION_DATE, ucc.LAST_UPDATED_BY LAST_UPDATED_BY, ucc.LAST_UPDATE_DATE LAST_UPDATE_DATE FROM IGS_HE_EN_SUSA_CC ucc, HZ_PARTIES per, HZ_PERSON_PROFILES perp, IGS_EN_STDNT_PS_ATT_ALL spa, IGS_PS_VER_ALL ps, IGS_EN_UNIT_SET_ALL us, IGS_AS_SU_SETATMPT susa WHERE per.PARTY_ID = ucc.PERSON_ID AND per.PARTY_ID = perp.PARTY_ID AND perp.CONTENT_SOURCE_TYPE = 'USER_ENTERED' AND SYSDATE BETWEEN perp.EFFECTIVE_START_DATE AND NVL(perp.EFFECTIVE_END_DATE,SYSDATE) AND spa.PERSON_ID = ucc.PERSON_ID AND spa.COURSE_CD = ucc.COURSE_CD AND ps.COURSE_CD = ucc.COURSE_CD AND ps.VERSION_NUMBER = spa.VERSION_NUMBER AND us.UNIT_SET_CD = ucc.UNIT_SET_CD AND us.VERSION_NUMBER = susa.US_VERSION_NUMBER AND susa.PERSON_ID = ucc.PERSON_ID AND susa.COURSE_CD = ucc.COURSE_CD AND susa.UNIT_SET_CD = ucc.UNIT_SET_CD AND susa.SEQUENCE_NUMBER = ucc.SEQUENCE_NUMBER WITH READ ONLY

View Text - HTML Formatted

SELECT UCC.HE_SUSA_CC_ID HE_SUSA_CC_ID
, UCC.PERSON_ID PERSON_ID
, PER.PARTY_NUMBER PERSON_NUMBER
, PER.PERSON_LAST_NAME PERSON_SURNAME
, PER.PERSON_FIRST_NAME PERSON_GIVEN_NAMES
, PERP.PERSON_NAME PERSON_FULL_NAME
, UCC.COURSE_CD PROGRAM_CODE
, PS.TITLE PROGRAM_TITLE
, PS.SHORT_TITLE PROGRAM_SHORT_TITLE
, PS.ABBREVIATION PROGRAM_ABBREVIATION
, UCC.UNIT_SET_CD UNIT_SET_CODE
, US.TITLE UNIT_SET_TITLE
, US.SHORT_TITLE UNIT_SET_SHORT_TITLE
, US.ABBREVIATION UNIT_SET_ABBREVIATION
, UCC.SEQUENCE_NUMBER SEQUENCE_NUMBER
, UCC.COST_CENTRE SUSA_COST_CENTRE
, (SELECT VALUE_DESCRIPTION
FROM IGS_HE_CODE_VALUES
WHERE CODE_TYPE = 'OSS_COSTCN'
AND VALUE = UCC.COST_CENTRE) SUSA_COST_CENTRE_DESC
, UCC.SUBJECT SUSA_SUBJ
, (SELECT DESCRIPTION
FROM IGS_PS_FLD_OF_STUDY_ALL
WHERE FIELD_OF_STUDY = UCC.SUBJECT) SUSA_SUBJ_DESC
, UCC.PROPORTION SUSA_COST_CENTRE_SUBJ_PROP
, UCC.CREATED_BY CREATED_BY
, UCC.CREATION_DATE CREATION_DATE
, UCC.LAST_UPDATED_BY LAST_UPDATED_BY
, UCC.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_HE_EN_SUSA_CC UCC
, HZ_PARTIES PER
, HZ_PERSON_PROFILES PERP
, IGS_EN_STDNT_PS_ATT_ALL SPA
, IGS_PS_VER_ALL PS
, IGS_EN_UNIT_SET_ALL US
, IGS_AS_SU_SETATMPT SUSA
WHERE PER.PARTY_ID = UCC.PERSON_ID
AND PER.PARTY_ID = PERP.PARTY_ID
AND PERP.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
AND SYSDATE BETWEEN PERP.EFFECTIVE_START_DATE
AND NVL(PERP.EFFECTIVE_END_DATE
, SYSDATE)
AND SPA.PERSON_ID = UCC.PERSON_ID
AND SPA.COURSE_CD = UCC.COURSE_CD
AND PS.COURSE_CD = UCC.COURSE_CD
AND PS.VERSION_NUMBER = SPA.VERSION_NUMBER
AND US.UNIT_SET_CD = UCC.UNIT_SET_CD
AND US.VERSION_NUMBER = SUSA.US_VERSION_NUMBER
AND SUSA.PERSON_ID = UCC.PERSON_ID
AND SUSA.COURSE_CD = UCC.COURSE_CD
AND SUSA.UNIT_SET_CD = UCC.UNIT_SET_CD
AND SUSA.SEQUENCE_NUMBER = UCC.SEQUENCE_NUMBER WITH READ ONLY