[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | View created mainly for the thesis maintenance forms to allow easier displaying of derived and virtual columns. |
| Implementation/DBA Data: | Not implemented in this database |
SELECT PERSON_ID
, CA_SEQUENCE_NUMBER
, SEQUENCE_NUMBER
, TITLE
, FINAL_TITLE_IND
, SHORT_TITLE
, ABBREVIATED_TITLE
, IGS_RE_GEN_002.RESP_GET_THE_STATUS(THES.PERSON_ID
, THES.CA_SEQUENCE_NUMBER
, THES.SEQUENCE_NUMBER
, 'Y'
, THES.LOGICAL_DELETE_DT
, THES.THESIS_RESULT_CD) AS THESIS_STATUS
, THESIS_RESULT_CD
, EXPECTED_SUBMISSION_DT
, LIBRARY_LODGEMENT_DT
, LIBRARY_CATALOGUE_NUMBER
, EMBARGO_EXPIRY_DT
, THESIS_FORMAT
, DECODE(NVL(LOGICAL_DELETE_DT
, NULL)
, NULL
, 'N'
, 'Y') LOGICAL_DELETE_INCLUDE_IND
, LOGICAL_DELETE_DT
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, EMBARGO_DETAILS
, THESIS_TOPIC
, CITATION
, COMMENTS
FROM IGS_RE_THESIS THES