eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.IGS_RE_THESIS_RESULT_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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