VIEW: APPS.IGS_AD_TEST_TYPE_RESULTS_V

Source

View Text - Preformatted

SELECT TR.ROWID ROW_ID, TR.TEST_RESULTS_ID, TR.PERSON_ID, TR.ADMISSION_TEST_TYPE, TR.TEST_DATE, TR.COMP_TEST_SCORE, TT.DESCRIPTION, TR.CREATED_BY, TR.CREATION_DATE, TR.LAST_UPDATED_BY, TR.LAST_UPDATE_DATE, TR.LAST_UPDATE_LOGIN FROM IGS_AD_TEST_RESULTS TR, IGS_AD_TEST_TYPE TT WHERE TR.ADMISSION_TEST_TYPE = TT.ADMISSION_TEST_TYPE

View Text - HTML Formatted

SELECT TR.ROWID ROW_ID
, TR.TEST_RESULTS_ID
, TR.PERSON_ID
, TR.ADMISSION_TEST_TYPE
, TR.TEST_DATE
, TR.COMP_TEST_SCORE
, TT.DESCRIPTION
, TR.CREATED_BY
, TR.CREATION_DATE
, TR.LAST_UPDATED_BY
, TR.LAST_UPDATE_DATE
, TR.LAST_UPDATE_LOGIN
FROM IGS_AD_TEST_RESULTS TR
, IGS_AD_TEST_TYPE TT
WHERE TR.ADMISSION_TEST_TYPE = TT.ADMISSION_TEST_TYPE