VIEW: APPS.IGS_HE_PROG_OU_CC_V

Source

View Text - Preformatted

SELECT pcc.ROWID ROW_ID, pcc.HESA_PROG_CC_ID HESA_PROG_CC_ID, pcc.COURSE_CD COURSE_CD, prg.TITLE PROGRAM_TITLE, prg.SHORT_TITLE PROGRAM_SHORT_TITLE, prg.ABBREVIATION PROGRAM_ABBREVIATION, pcc.VERSION_NUMBER VERSION_NUMBER, pcc.ORG_UNIT_CD ORG_UNIT_CD, (SELECT HP.PARTY_NAME FROM HZ_PARTIES HP, IGS_PE_HZ_PARTIES IHP WHERE IHP.OSS_ORG_UNIT_CD = pcc.ORG_UNIT_CD AND IHP.PARTY_ID = HP.PARTY_ID) ORG_UNIT_DESC, pcc.COST_CENTRE COST_CENTRE, (SELECT VALUE_DESCRIPTION FROM IGS_HE_CODE_VALUES WHERE CODE_TYPE = 'OSS_COSTCN' AND VALUE = pcc.COST_CENTRE) COST_CENTRE_DESC, pcc.SUBJECT SUBJECT, (SELECT DESCRIPTION FROM IGS_PS_FLD_OF_STUDY WHERE FIELD_OF_STUDY = pcc.SUBJECT) SUBJECT_DESC, pcc.PROPORTION PROPORTION, pcc.CREATED_BY CREATED_BY, pcc.CREATION_DATE CREATION_DATE, pcc.LAST_UPDATED_BY LAST_UPDATED_BY, pcc.LAST_UPDATE_DATE LAST_UPDATE_DATE, pcc.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM IGS_HE_PROG_OU_CC pcc, IGS_PS_VER_ALL prg WHERE prg.COURSE_CD (+) = pcc.COURSE_CD AND prg.VERSION_NUMBER (+) = pcc.VERSION_NUMBER

View Text - HTML Formatted

SELECT PCC.ROWID ROW_ID
, PCC.HESA_PROG_CC_ID HESA_PROG_CC_ID
, PCC.COURSE_CD COURSE_CD
, PRG.TITLE PROGRAM_TITLE
, PRG.SHORT_TITLE PROGRAM_SHORT_TITLE
, PRG.ABBREVIATION PROGRAM_ABBREVIATION
, PCC.VERSION_NUMBER VERSION_NUMBER
, PCC.ORG_UNIT_CD ORG_UNIT_CD
, (SELECT HP.PARTY_NAME
FROM HZ_PARTIES HP
, IGS_PE_HZ_PARTIES IHP
WHERE IHP.OSS_ORG_UNIT_CD = PCC.ORG_UNIT_CD
AND IHP.PARTY_ID = HP.PARTY_ID) ORG_UNIT_DESC
, PCC.COST_CENTRE COST_CENTRE
, (SELECT VALUE_DESCRIPTION
FROM IGS_HE_CODE_VALUES
WHERE CODE_TYPE = 'OSS_COSTCN'
AND VALUE = PCC.COST_CENTRE) COST_CENTRE_DESC
, PCC.SUBJECT SUBJECT
, (SELECT DESCRIPTION
FROM IGS_PS_FLD_OF_STUDY
WHERE FIELD_OF_STUDY = PCC.SUBJECT) SUBJECT_DESC
, PCC.PROPORTION PROPORTION
, PCC.CREATED_BY CREATED_BY
, PCC.CREATION_DATE CREATION_DATE
, PCC.LAST_UPDATED_BY LAST_UPDATED_BY
, PCC.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PCC.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_HE_PROG_OU_CC PCC
, IGS_PS_VER_ALL PRG
WHERE PRG.COURSE_CD (+) = PCC.COURSE_CD
AND PRG.VERSION_NUMBER (+) = PCC.VERSION_NUMBER