VIEW: APPS.IGS_HE_OU_CC_V

Source

View Text - Preformatted

SELECT oucc.ROWID ROW_ID, oucc.HESA_OU_CC_ID HESA_OU_CC_ID, oucc.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 = oucc.ORG_UNIT_CD AND IHP.PARTY_ID = HP.PARTY_ID) ORG_UNIT_DESC, oucc.COST_CENTRE COST_CENTRE, (SELECT VALUE_DESCRIPTION FROM IGS_HE_CODE_VALUES WHERE CODE_TYPE = 'OSS_COSTCN' AND VALUE = oucc.COST_CENTRE) COST_CENTRE_DESC, oucc.SUBJECT SUBJECT, (SELECT DESCRIPTION FROM IGS_PS_FLD_OF_STUDY WHERE FIELD_OF_STUDY = oucc.SUBJECT) SUBJECT_DESC, oucc.PROPORTION PROPORTION, oucc.CREATED_BY CREATED_BY, oucc.CREATION_DATE CREATION_DATE, oucc.LAST_UPDATED_BY LAST_UPDATED_BY, oucc.LAST_UPDATE_DATE LAST_UPDATE_DATE, oucc.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM IGS_HE_OU_CC oucc

View Text - HTML Formatted

SELECT OUCC.ROWID ROW_ID
, OUCC.HESA_OU_CC_ID HESA_OU_CC_ID
, OUCC.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 = OUCC.ORG_UNIT_CD
AND IHP.PARTY_ID = HP.PARTY_ID) ORG_UNIT_DESC
, OUCC.COST_CENTRE COST_CENTRE
, (SELECT VALUE_DESCRIPTION
FROM IGS_HE_CODE_VALUES
WHERE CODE_TYPE = 'OSS_COSTCN'
AND VALUE = OUCC.COST_CENTRE) COST_CENTRE_DESC
, OUCC.SUBJECT SUBJECT
, (SELECT DESCRIPTION
FROM IGS_PS_FLD_OF_STUDY
WHERE FIELD_OF_STUDY = OUCC.SUBJECT) SUBJECT_DESC
, OUCC.PROPORTION PROPORTION
, OUCC.CREATED_BY CREATED_BY
, OUCC.CREATION_DATE CREATION_DATE
, OUCC.LAST_UPDATED_BY LAST_UPDATED_BY
, OUCC.LAST_UPDATE_DATE LAST_UPDATE_DATE
, OUCC.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_HE_OU_CC OUCC