[Home] [Help]
View: IGS_AD_TEST_TYPE_RESULTS_V
View Text
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
Columns
| Name |
| ROW_ID |
| TEST_RESULTS_ID |
| PERSON_ID |
| ADMISSION_TEST_TYPE |
| TEST_DATE |
| COMP_TEST_SCORE |
| DESCRIPTION |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATE_LOGIN |
APPS.IGS_AD_TEST_TYPE_RESULTS_V