VIEW: APPS.IGS_RE_THESIS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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