View: IGS_RE_THESIS_V

Product:	IGS - Student System
Description:	View created mainly for the thesis maintenance forms to allow easier displaying of derived and virtual columns.
Implementation/DBA Data:	APPS.IGS_RE_THESIS_V

View Text

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

Columns