[Home] [Help]
View: IGS_RE_THESIS_RESULT_V
View Text
SELECT RES.ROWID ROW_ID
, RES.THESIS_RESULT_CD THESIS_RESULT_CD
, RES.DESCRIPTION DESCRIPTION
, RES.S_THESIS_RESULT_CD S_THESIS_RESULT_CD
, RES.CLOSED_IND CLOSED_IND
, RES.COMMENTS COMMENTS
, RES.CREATED_BY CREATED_BY
, RES.CREATION_DATE CREATION_DATE
, RES.LAST_UPDATED_BY LAST_UPDATED_BY
, RES.LAST_UPDATE_DATE LAST_UPDATE_DATE
, RES.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LKUP.MEANING MEANING
, LKUP.FINAL_RESULT_IND FINAL_RESULT_IND FROM IGS_RE_THESIS_RESULT RES
, IGS_LOOKUPS_VIEW LKUP
WHERE LKUP.LOOKUP_TYPE = 'THESIS_RESULT'
AND LKUP.LOOKUP_CODE = RES.S_THESIS_RESULT_CD
Columns
| Name |
| ROW_ID |
| THESIS_RESULT_CD |
| DESCRIPTION |
| S_THESIS_RESULT_CD |
| CLOSED_IND |
| COMMENTS |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATE_LOGIN |
| MEANING |
| FINAL_RESULT_IND |