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: CS.CS_CALLS#

Source

View Text - Preformatted


select CALL_ID CALL_ID, SOURCE_OBJECT_ID SOURCE_OBJECT_ID, SOURCE_OBJECT_CODE SOURCE_OBJECT_CODE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CONTACT_ID CONTACT_ID, CONTACT_NAME CONTACT_NAME, CONTACT_PHONE_ID CONTACT_PHONE_ID, CONTACT_PHONE_NUM CONTACT_PHONE_NUM, CONTACT_PHONE_EXT CONTACT_PHONE_EXT, CONTACT_FAX_ID CONTACT_FAX_ID, CONTACT_FAX_NUM CONTACT_FAX_NUM, CONTACT_EMAIL_ADDR CONTACT_EMAIL_ADDR, CALL_DATE_TIME CALL_DATE_TIME, DURATION DURATION, COMMENT_ID COMMENT_ID, ENTERED_BY_ID ENTERED_BY_ID, FOLLOWUP_FLAG FOLLOWUP_FLAG, FOLLOWUP_DATE FOLLOWUP_DATE, FOLLOWUP_TYPE FOLLOWUP_TYPE, CALL_TYPE_CODE CALL_TYPE_CODE, CALL_RESULT_CODE CALL_RESULT_CODE, CREATED_BY_CUSTOMER CREATED_BY_CUSTOMER, OUTGOING_CALL_FLAG OUTGOING_CALL_FLAG, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, CONTEXT CONTEXT from "CS"."CS_CALLS"

View Text - HTML Formatted

SELECT CALL_ID CALL_ID
, SOURCE_OBJECT_ID SOURCE_OBJECT_ID
, SOURCE_OBJECT_CODE SOURCE_OBJECT_CODE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CONTACT_ID CONTACT_ID
, CONTACT_NAME CONTACT_NAME
, CONTACT_PHONE_ID CONTACT_PHONE_ID
, CONTACT_PHONE_NUM CONTACT_PHONE_NUM
, CONTACT_PHONE_EXT CONTACT_PHONE_EXT
, CONTACT_FAX_ID CONTACT_FAX_ID
, CONTACT_FAX_NUM CONTACT_FAX_NUM
, CONTACT_EMAIL_ADDR CONTACT_EMAIL_ADDR
, CALL_DATE_TIME CALL_DATE_TIME
, DURATION DURATION
, COMMENT_ID COMMENT_ID
, ENTERED_BY_ID ENTERED_BY_ID
, FOLLOWUP_FLAG FOLLOWUP_FLAG
, FOLLOWUP_DATE FOLLOWUP_DATE
, FOLLOWUP_TYPE FOLLOWUP_TYPE
, CALL_TYPE_CODE CALL_TYPE_CODE
, CALL_RESULT_CODE CALL_RESULT_CODE
, CREATED_BY_CUSTOMER CREATED_BY_CUSTOMER
, OUTGOING_CALL_FLAG OUTGOING_CALL_FLAG
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, CONTEXT CONTEXT
FROM "CS"."CS_CALLS"