FND Design Data [Home] [Help]

Table: JTF_TASK_TEMPLATES_B

Product: JTF - CRM Foundation
Description: JTF_TASK_TEMPLATES_B stores all the Task templates.
Implementation/DBA Data: TableJTF.JTF_TASK_TEMPLATES_B
Primary Key: JTF_TASK_TEMPLATES_B_PK
  1. ColumnTASK_TEMPLATE_ID
Primary Key: JTF_TASK_TEMPLATES_PK
  1. ColumnTASK_TEMPLATE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
JTF_TASK_TEMPLATES_B FK Joins to TableJTF_TASK_RECUR_RULES JTF_TASK_TEMPLATES_B.RECURRENCE_RULE_ID
JTF_TASK_TEMPLATES_B FK Joins to TableJTF_TASK_TEMP_GROUPS_B JTF_TASK_TEMPLATES_B.TASK_GROUP_ID
JTF_TASK_TEMPLATES_B FK Joins to TableJTF_TASK_TYPES_B JTF_TASK_TEMPLATES_B.TASK_TYPE_ID
JTF_TASK_TEMPLATES_B FK Joins to TableJTF_TASK_STATUSES_B JTF_TASK_TEMPLATES_B.TASK_STATUS_ID
JTF_TASK_TEMPLATES_B FK Joins to TableJTF_TASK_PRIORITIES_B JTF_TASK_TEMPLATES_B.TASK_PRIORITY_ID
JTF_TASK_TEMPLATES_B FK Joins to Table% JTF_TASK_TEMPLATES_B.RECURRENCE_RULE_ID
JTF_TASK_TEMPLATES_B FK Joins to TableJTF_TASK_TEMP_GROUPS_B JTF_TASK_TEMPLATES_B.TASK_GROUP_ID
JTF_TASK_TEMPLATES_B FK Joins to Table% JTF_TASK_TEMPLATES_B.TASK_TYPE_ID
JTF_TASK_TEMPLATES_B FK Joins to Table% JTF_TASK_TEMPLATES_B.TASK_STATUS_ID
JTF_TASK_TEMPLATES_B FK Joins to Table% JTF_TASK_TEMPLATES_B.TASK_PRIORITY_ID
TableAS_SALES_METH_TASK_MAP FK Joins to JTF_TASK_TEMPLATES_B AS_SALES_METH_TASK_MAP.TASK_TEMPLATE_ID
TableCSP_PRODUCT_TASKS FK Joins to JTF_TASK_TEMPLATES_B CSP_PRODUCT_TASKS.TASK_TEMPLATE_ID
TableJTF_TASK_DEPENDS FK Joins to JTF_TASK_TEMPLATES_B JTF_TASK_DEPENDS.TASK_ID
TableJTF_TASK_DEPENDS FK Joins to JTF_TASK_TEMPLATES_B JTF_TASK_DEPENDS.DEPENDENT_ON_TASK_ID
TableJTF_TASK_RSC_REQS FK Joins to JTF_TASK_TEMPLATES_B JTF_TASK_RSC_REQS.TASK_TEMPLATE_ID
TableJTF_TASK_RSC_REQS FK Joins to JTF_TASK_TEMPLATES_B JTF_TASK_RSC_REQS.TASK_TEMPLATE_ID