VIEW: AMS.AMS_DLG_INTERACTIONS#

Source

View Text - Preformatted

select INTERACTION_ID INTERACTION_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, OBJECT_TYPE OBJECT_TYPE, OBJECT_ID OBJECT_ID, START_DATE_TIME START_DATE_TIME, SOURCE_CODE SOURCE_CODE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, SOURCE_CODE_ID SOURCE_CODE_ID, END_DATE_TIME END_DATE_TIME, RESULT_ID RESULT_ID, REASON_ID REASON_ID, OUTCOME_ID OUTCOME_ID, PARTY_ID PARTY_ID, RESOURCE_ID RESOURCE_ID, ACTIVE_FLAG ACTIVE_FLAG, SYNCHRONIZED_FLAG SYNCHRONIZED_FLAG, RELATED_SOURCE_CODE RELATED_SOURCE_CODE, TOUCH_POINT_TYPE TOUCH_POINT_TYPE, SECURITY_GROUP_ID SECURITY_GROUP_ID from "AMS"."AMS_DLG_INTERACTIONS"

View Text - HTML Formatted

SELECT INTERACTION_ID INTERACTION_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, OBJECT_TYPE OBJECT_TYPE
, OBJECT_ID OBJECT_ID
, START_DATE_TIME START_DATE_TIME
, SOURCE_CODE SOURCE_CODE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SOURCE_CODE_ID SOURCE_CODE_ID
, END_DATE_TIME END_DATE_TIME
, RESULT_ID RESULT_ID
, REASON_ID REASON_ID
, OUTCOME_ID OUTCOME_ID
, PARTY_ID PARTY_ID
, RESOURCE_ID RESOURCE_ID
, ACTIVE_FLAG ACTIVE_FLAG
, SYNCHRONIZED_FLAG SYNCHRONIZED_FLAG
, RELATED_SOURCE_CODE RELATED_SOURCE_CODE
, TOUCH_POINT_TYPE TOUCH_POINT_TYPE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
FROM "AMS"."AMS_DLG_INTERACTIONS"