VIEW: APPS.IGS_RE_THESIS_EXAM_V

Source

View Text - Preformatted

SELECT PERSON_ID, CA_SEQUENCE_NUMBER, THE_SEQUENCE_NUMBER, CREATION_DT, DECODE(NVL(SUBMISSION_DT,SYSDATE),SYSDATE,'N','Y') SUBMITTED_IND, SUBMISSION_DT, THESIS_EXAM_TYPE, THESIS_PANEL_TYPE, TRACKING_ID, THESIS_RESULT_CD, created_by, creation_date, last_updated_by, last_update_date, last_update_login FROM IGS_RE_THESIS_EXAM tex

View Text - HTML Formatted

SELECT PERSON_ID
, CA_SEQUENCE_NUMBER
, THE_SEQUENCE_NUMBER
, CREATION_DT
, DECODE(NVL(SUBMISSION_DT
, SYSDATE)
, SYSDATE
, 'N'
, 'Y') SUBMITTED_IND
, SUBMISSION_DT
, THESIS_EXAM_TYPE
, THESIS_PANEL_TYPE
, TRACKING_ID
, THESIS_RESULT_CD
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS_RE_THESIS_EXAM TEX