[Home] [Help]
| Product: | IGS - Student System |
|---|---|
| Description: | |
| Implementation/DBA Data: |
APPS.IGS_RE_THESIS_EXAM_V
|
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