DBA Data[Home] [Help]

VIEW: APPS.IGS_PR_STDNT_PR_AWD_V

Source

View Text - Preformatted

SELECT SPOA.ROWID ,SPOA.PERSON_ID,SPOA.COURSE_CD,SPOA.SPO_SEQUENCE_NUMBER,SPOA.AWARD_CD, AWD.AWARD_TITLE, SPOA.CREATED_BY,SPOA.CREATION_DATE, SPOA.LAST_UPDATED_BY,SPOA.LAST_UPDATE_DATE,SPOA.LAST_UPDATE_LOGIN FROM IGS_PR_STDNT_PR_AWD SPOA, IGS_PS_AWD AWD WHERE AWD.AWARD_CD = SPOA.AWARD_CD
View Text - HTML Formatted

SELECT SPOA.ROWID
, SPOA.PERSON_ID
, SPOA.COURSE_CD
, SPOA.SPO_SEQUENCE_NUMBER
, SPOA.AWARD_CD
, AWD.AWARD_TITLE
, SPOA.CREATED_BY
, SPOA.CREATION_DATE
, SPOA.LAST_UPDATED_BY
, SPOA.LAST_UPDATE_DATE
, SPOA.LAST_UPDATE_LOGIN
FROM IGS_PR_STDNT_PR_AWD SPOA
, IGS_PS_AWD AWD
WHERE AWD.AWARD_CD = SPOA.AWARD_CD