VIEW: APPS.IGS_HE_ST_SPU_DTLS_V

Source

View Text - Preformatted

SELECT A.ROWID ROW_ID ,A.HESA_ST_SPAU_ID ,A.COURSE_CD ,A.VERSION_NUMBER ,A.PERSON_ID ,A.QUALIFICATION_LEVEL ,B.AWARD_TITLE ,A.NUMBER_OF_QUAL ,A.TARIFF_SCORE ,A.CREATED_BY ,A.CREATION_DATE ,A.LAST_UPDATE_DATE ,A.LAST_UPDATED_BY ,A.LAST_UPDATE_LOGIN FROM IGS_HE_ST_SPA_UT A, IGS_PS_AWD B WHERE B.AWARD_CD (+) = A.QUALIFICATION_LEVEL

View Text - HTML Formatted

SELECT A.ROWID ROW_ID
, A.HESA_ST_SPAU_ID
, A.COURSE_CD
, A.VERSION_NUMBER
, A.PERSON_ID
, A.QUALIFICATION_LEVEL
, B.AWARD_TITLE
, A.NUMBER_OF_QUAL
, A.TARIFF_SCORE
, A.CREATED_BY
, A.CREATION_DATE
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_LOGIN
FROM IGS_HE_ST_SPA_UT A
, IGS_PS_AWD B
WHERE B.AWARD_CD (+) = A.QUALIFICATION_LEVEL