eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: CN.CN_COPY_REQUESTS_ALL#

Source

View Text - Preformatted


select EXP_IMP_REQUEST_ID EXP_IMP_REQUEST_ID, ORG_ID ORG_ID, REQUEST_NAME REQUEST_NAME, OBJECT_TYPE OBJECT_TYPE, STATUS_CODE STATUS_CODE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, COMPLETION_DATE COMPLETION_DATE, PREFIX_INFO PREFIX_INFO, CHANGE_DATE_FLAG CHANGE_DATE_FLAG, CHANGE_START_DATE CHANGE_START_DATE, CHANGE_END_DATE CHANGE_END_DATE, REQUEST_ID REQUEST_ID, OPERATION OPERATION, FILE_CONTENT_BLOB FILE_CONTENT_BLOB, FILE_CONTENT_CLOB FILE_CONTENT_CLOB, REQ_SUBMISSION_DATE REQ_SUBMISSION_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, FILE_CONTENT_XMLTYPE FILE_CONTENT_XMLTYPE from "CN"."CN_COPY_REQUESTS_ALL"

View Text - HTML Formatted

SELECT EXP_IMP_REQUEST_ID EXP_IMP_REQUEST_ID
, ORG_ID ORG_ID
, REQUEST_NAME REQUEST_NAME
, OBJECT_TYPE OBJECT_TYPE
, STATUS_CODE STATUS_CODE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, COMPLETION_DATE COMPLETION_DATE
, PREFIX_INFO PREFIX_INFO
, CHANGE_DATE_FLAG CHANGE_DATE_FLAG
, CHANGE_START_DATE CHANGE_START_DATE
, CHANGE_END_DATE CHANGE_END_DATE
, REQUEST_ID REQUEST_ID
, OPERATION OPERATION
, FILE_CONTENT_BLOB FILE_CONTENT_BLOB
, FILE_CONTENT_CLOB FILE_CONTENT_CLOB
, REQ_SUBMISSION_DATE REQ_SUBMISSION_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, FILE_CONTENT_XMLTYPE FILE_CONTENT_XMLTYPE
FROM "CN"."CN_COPY_REQUESTS_ALL"