FND Design Data [Home] [Help]

Table: JTF_IH_INTERACTIONS

Product: JTF - CRM Foundation
Description: A contact point between a customer, customer system or potential customer and a single human or automated agent (Handler and Handler Resource). An Interaction can be timed and has an outcome and result that can be tracked. Multiple Intera
Implementation/DBA Data: TableJTF.JTF_IH_INTERACTIONS
Primary Key: JTF_IH_INTERACTIONS_PK
  1. ColumnINTERACTION_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
JTF_IH_INTERACTIONS FK Joins to TableHZ_PARTIES JTF_IH_INTERACTIONS.PARTY_ID
JTF_IH_INTERACTIONS FK Joins to TableJTF_IH_OUTCOMES_B JTF_IH_INTERACTIONS.OUTCOME_ID
JTF_IH_INTERACTIONS FK Joins to TableJTF_IH_REASONS_B JTF_IH_INTERACTIONS.REASON_ID
JTF_IH_INTERACTIONS FK Joins to TableJTF_IH_RESULTS_B JTF_IH_INTERACTIONS.RESULT_ID
JTF_IH_INTERACTIONS FK Joins to TableJTF_IH_SCRIPTS JTF_IH_INTERACTIONS.SCRIPT_ID
JTF_IH_INTERACTIONS FK Joins to TableAMS_SOURCE_CODES JTF_IH_INTERACTIONS.SOURCE_CODE_ID
JTF_IH_INTERACTIONS FK Joins to TableFND_APPLICATION JTF_IH_INTERACTIONS.HANDLER_ID
JTF_IH_INTERACTIONS FK Joins to TableJTF_RS_RESOURCE_EXTNS JTF_IH_INTERACTIONS.RESOURCE_ID
JTF_IH_INTERACTIONS FK Joins to TableJTF_IH_INTERACTION_INTERS JTF_IH_INTERACTIONS.INTERACTION_INTERS_ID
TableAML_INTERACTION_LEADS FK Joins to JTF_IH_INTERACTIONS AML_INTERACTION_LEADS.INTERACTION_ID
TableJTF_IH_ACTIVITIES FK Joins to JTF_IH_INTERACTIONS JTF_IH_ACTIVITIES.INTERACTION_ID
TableJTF_IH_INTERACTIONS_CAMPAIGNS FK Joins to JTF_IH_INTERACTIONS JTF_IH_INTERACTIONS_CAMPAIGNS.INTERACTION_ID
TableJTF_IH_INTERACTION_INTERS FK Joins to JTF_IH_INTERACTIONS JTF_IH_INTERACTION_INTERS.INTERACT_INTERACTION_ID
TableJTF_IH_INTERACTION_INTERS FK Joins to JTF_IH_INTERACTIONS JTF_IH_INTERACTION_INTERS.INTERACT_INTERACTION_IDRELATES