VIEW: ORDDATA.ORDDCM_DOCUMENTS

Source

View Text - Preformatted

SELECT  docs.DOC_ID,
        docs.DOC_NAME,
        doc_types.DOC_TYPE,
        docs.CREATE_DATE,
        docs.ORACLE_INSTALL INSTALLED_BY_ORACLE
FROM    ORDDATA.ORDDCM_DOCS_tmp docs, ORDDATA.ORDDCM_DOC_TYPES doc_types
WHERE   docs.DOC_TYPE_ID = doc_types.DOC_TYPE_ID
WITH READ ONLY

View Text - HTML Formatted

SELECT DOCS.DOC_ID
, DOCS.DOC_NAME
, DOC_TYPES.DOC_TYPE
, DOCS.CREATE_DATE
, DOCS.ORACLE_INSTALL INSTALLED_BY_ORACLE FROM ORDDATA.ORDDCM_DOCS_TMP DOCS
, ORDDATA.ORDDCM_DOC_TYPES DOC_TYPES WHERE DOCS.DOC_TYPE_ID = DOC_TYPES.DOC_TYPE_ID WITH READ ONLY