VIEW: IEM.IEM_RT_INTERACTIONS#

Source

View Text - Preformatted

select RT_INTERACTION_ID RT_INTERACTION_ID, CUSTOMER_ID CUSTOMER_ID, INTERACTION_ID INTERACTION_ID, RESOURCE_ID RESOURCE_ID, STATUS STATUS, TYPE TYPE, EXPIRE EXPIRE, 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, SECURITY_GROUP_ID SECURITY_GROUP_ID, SERVICE_REQUEST_ID SERVICE_REQUEST_ID, SERVICE_REQUEST_ACTION SERVICE_REQUEST_ACTION, CONTACT_ID CONTACT_ID, MC_PARAMETER_ID MC_PARAMETER_ID, IH_CREATOR IH_CREATOR, INB_TAG_ID INB_TAG_ID, PARENT_INTERACTION_ID PARENT_INTERACTION_ID, ACTION_ID ACTION_ID, ACTION_ITEM_ID ACTION_ITEM_ID, REASON_ID REASON_ID, RESULT_ID RESULT_ID, OUTCOME_ID OUTCOME_ID, TO_RESOURCE_ID TO_RESOURCE_ID, APPLICATION_ID APPLICATION_ID, RESPONSIBILITY_ID RESPONSIBILITY_ID, LEAD_ID LEAD_ID, LEAD_ACTION LEAD_ACTION, SPV_RESOURCE_ID SPV_RESOURCE_ID, RELATIONSHIP_ID RELATIONSHIP_ID from "IEM"."IEM_RT_INTERACTIONS"

View Text - HTML Formatted

SELECT RT_INTERACTION_ID RT_INTERACTION_ID
, CUSTOMER_ID CUSTOMER_ID
, INTERACTION_ID INTERACTION_ID
, RESOURCE_ID RESOURCE_ID
, STATUS STATUS
, TYPE TYPE
, EXPIRE EXPIRE
, 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
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, SERVICE_REQUEST_ID SERVICE_REQUEST_ID
, SERVICE_REQUEST_ACTION SERVICE_REQUEST_ACTION
, CONTACT_ID CONTACT_ID
, MC_PARAMETER_ID MC_PARAMETER_ID
, IH_CREATOR IH_CREATOR
, INB_TAG_ID INB_TAG_ID
, PARENT_INTERACTION_ID PARENT_INTERACTION_ID
, ACTION_ID ACTION_ID
, ACTION_ITEM_ID ACTION_ITEM_ID
, REASON_ID REASON_ID
, RESULT_ID RESULT_ID
, OUTCOME_ID OUTCOME_ID
, TO_RESOURCE_ID TO_RESOURCE_ID
, APPLICATION_ID APPLICATION_ID
, RESPONSIBILITY_ID RESPONSIBILITY_ID
, LEAD_ID LEAD_ID
, LEAD_ACTION LEAD_ACTION
, SPV_RESOURCE_ID SPV_RESOURCE_ID
, RELATIONSHIP_ID RELATIONSHIP_ID
FROM "IEM"."IEM_RT_INTERACTIONS"