VIEW: APPS.IGS_RE_THESIS

Source

View Text - Preformatted

SELECT tab.rowid row_id, tab.org_id org_id, tab.person_id person_id, tab.ca_sequence_number ca_sequence_number, tab.sequence_number sequence_number, tab.title title, tab.final_title_ind final_title_ind, tab.short_title short_title, tab.abbreviated_title abbreviated_title, tab.thesis_result_cd thesis_result_cd, tab.expected_submission_dt expected_submission_dt, tab.library_lodgement_dt library_lodgement_dt, tab.library_catalogue_number library_catalogue_number, tab.embargo_expiry_dt embargo_expiry_dt, tab.thesis_format thesis_format, tab.logical_delete_dt logical_delete_dt, tab.embargo_details embargo_details, tab.thesis_topic thesis_topic, tab.citation citation, tab.comments comments, tab.created_by created_by, tab.creation_date creation_date, tab.last_updated_by last_updated_by, tab.last_update_date last_update_date, tab.last_update_login last_update_login FROM igs_re_thesis_all tab WHERE NVL (tab.org_id , NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)

View Text - HTML Formatted

SELECT TAB.ROWID ROW_ID
, TAB.ORG_ID ORG_ID
, TAB.PERSON_ID PERSON_ID
, TAB.CA_SEQUENCE_NUMBER CA_SEQUENCE_NUMBER
, TAB.SEQUENCE_NUMBER SEQUENCE_NUMBER
, TAB.TITLE TITLE
, TAB.FINAL_TITLE_IND FINAL_TITLE_IND
, TAB.SHORT_TITLE SHORT_TITLE
, TAB.ABBREVIATED_TITLE ABBREVIATED_TITLE
, TAB.THESIS_RESULT_CD THESIS_RESULT_CD
, TAB.EXPECTED_SUBMISSION_DT EXPECTED_SUBMISSION_DT
, TAB.LIBRARY_LODGEMENT_DT LIBRARY_LODGEMENT_DT
, TAB.LIBRARY_CATALOGUE_NUMBER LIBRARY_CATALOGUE_NUMBER
, TAB.EMBARGO_EXPIRY_DT EMBARGO_EXPIRY_DT
, TAB.THESIS_FORMAT THESIS_FORMAT
, TAB.LOGICAL_DELETE_DT LOGICAL_DELETE_DT
, TAB.EMBARGO_DETAILS EMBARGO_DETAILS
, TAB.THESIS_TOPIC THESIS_TOPIC
, TAB.CITATION CITATION
, TAB.COMMENTS COMMENTS
, TAB.CREATED_BY CREATED_BY
, TAB.CREATION_DATE CREATION_DATE
, TAB.LAST_UPDATED_BY LAST_UPDATED_BY
, TAB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TAB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_RE_THESIS_ALL TAB
WHERE NVL (TAB.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)