FND Design Data [Home] [Help]

Table: JTF_TASKS_B

Product: JTF - CRM Foundation
Description: Base Table JTF_TASKS_B stores general information about a given Task.
Implementation/DBA Data: TableJTF.JTF_TASKS_B
Primary Key: JTF_TASKS_B_PK
  1. ColumnTASK_ID
Primary Key: JTF_TASKS_PK
  1. ColumnTASK_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
JTF_TASKS_B FK Joins to TableJTF_OBJECTS_B JTF_TASKS_B.SOURCE_OBJECT_TYPE_CODE
JTF_TASKS_B FK Joins to TableHZ_CUST_ACCOUNTS JTF_TASKS_B.CUST_ACCOUNT_ID
JTF_TASKS_B FK Joins to TableHZ_PARTY_SITES JTF_TASKS_B.ADDRESS_ID
JTF_TASKS_B FK Joins to TableCS_INCIDENTS_ALL_B JTF_TASKS_B.SOURCE_OBJECT_ID
JTF_TASKS_B FK Joins to TableFND_USER JTF_TASKS_B.ASSIGNED_BY_ID
JTF_TASKS_B FK Joins to TableHZ_PARTIES JTF_TASKS_B.CUSTOMER_ID
JTF_TASKS_B FK Joins to TableJTF_OBJECTS_B JTF_TASKS_B.SOURCE_OBJECT_TYPE_CODE
JTF_TASKS_B FK Joins to TableHZ_TIMEZONES JTF_TASKS_B.TIMEZONE_ID
JTF_TASKS_B FK Joins to TableJTF_TASK_PRIORITIES_B JTF_TASKS_B.TASK_PRIORITY_ID
JTF_TASKS_B FK Joins to TableJTF_TASK_STATUSES_B JTF_TASKS_B.TASK_STATUS_ID
JTF_TASKS_B FK Joins to TableJTF_TASK_TYPES_B JTF_TASKS_B.TASK_TYPE_ID
JTF_TASKS_B FK Joins to TableJTF_TASK_RECUR_RULES JTF_TASKS_B.RECURRENCE_RULE_ID
JTF_TASKS_B FK Joins to TableHZ_PARTIES JTF_TASKS_B.CUSTOMER_ID
JTF_TASKS_B FK Joins to TableFND_CURRENCIES JTF_TASKS_B.CURRENCY_CODE
JTF_TASKS_B FK Joins to TableJTF_TASKS_B JTF_TASKS_B.PARENT_TASK_ID
JTF_TASKS_B FK Joins to Table% JTF_TASKS_B.SOURCE_OBJECT_TYPE_CODE
JTF_TASKS_B FK Joins to TableHZ_CUST_ACCOUNTS JTF_TASKS_B.CUST_ACCOUNT_ID
JTF_TASKS_B FK Joins to TableCS_INCIDENTS_ALL_B JTF_TASKS_B.SOURCE_OBJECT_ID
JTF_TASKS_B FK Joins to TableJTF_TASK_PRIORITIES_B JTF_TASKS_B.TASK_PRIORITY_ID
JTF_TASKS_B FK Joins to TableJTF_TASK_STATUSES_B JTF_TASKS_B.TASK_STATUS_ID
JTF_TASKS_B FK Joins to TableJTF_TASK_TYPES_B JTF_TASKS_B.TASK_TYPE_ID
JTF_TASKS_B FK Joins to TableJTF_TASK_RECUR_RULES JTF_TASKS_B.RECURRENCE_RULE_ID
JTF_TASKS_B FK Joins to TableHZ_PARTIES JTF_TASKS_B.SOURCE_OBJECT_TYPE_CODE
JTF_TASKS_B FK Joins to TableFND_CURRENCIES JTF_TASKS_B.CURRENCY_CODE
JTF_TASKS_B FK Joins to TableJTF_TASKS_B JTF_TASKS_B.PARENT_TASK_ID
JTF_TASKS_B FK Joins to TableHZ_PARTIES JTF_TASKS_B.SOURCE_OBJECT_TYPE_CODE
JTF_TASKS_B FK Joins to TableHZ_PARTY_SITES JTF_TASKS_B.ADDRESS_ID
TableAMS_CAMPAIGNS_ALL_B FK Joins to JTF_TASKS_B AMS_CAMPAIGNS_ALL_B.TASK_ID
TableAMS_CAMPAIGN_SCHEDULES_B FK Joins to JTF_TASKS_B AMS_CAMPAIGN_SCHEDULES_B.TASK_ID
TableAS_SALES_METH_TASK_MAP FK Joins to JTF_TASKS_B AS_SALES_METH_TASK_MAP.TASK_ID
TableCSD_REPAIRS FK Joins to JTF_TASKS_B CSD_REPAIRS.TASK_ID
TableCSF_ACCESS_HOURS_B FK Joins to JTF_TASKS_B CSF_ACCESS_HOURS_B.TASK_ID
TableCSP_REQUIREMENT_HEADERS FK Joins to JTF_TASKS_B CSP_REQUIREMENT_HEADERS.TASK_ID
TableJTF_IH_ACTIVITIES FK Joins to JTF_TASKS_B JTF_IH_ACTIVITIES.TASK_ID
TableJTF_TASKS_B FK Joins to JTF_TASKS_B JTF_TASKS_B.PARENT_TASK_ID
TableJTF_TASKS_B FK Joins to JTF_TASKS_B JTF_TASKS_B.PARENT_TASK_ID
TableJTF_TASK_ASSIGNMENTS FK Joins to JTF_TASKS_B JTF_TASK_ASSIGNMENTS.TASK_ID
TableJTF_TASK_AUDITS_B FK Joins to JTF_TASKS_B JTF_TASK_AUDITS_B.TASK_ID
TableJTF_TASK_AUDITS_B FK Joins to JTF_TASKS_B JTF_TASK_AUDITS_B.NEW_PARENT_TASK_ID
TableJTF_TASK_AUDITS_B FK Joins to JTF_TASKS_B JTF_TASK_AUDITS_B.OLD_PARENT_TASK_ID
TableJTF_TASK_CONTACTS FK Joins to JTF_TASKS_B JTF_TASK_CONTACTS.TASK_ID
TableJTF_TASK_DATES FK Joins to JTF_TASKS_B JTF_TASK_DATES.TASK_ID
TableJTF_TASK_DEPENDS FK Joins to JTF_TASKS_B JTF_TASK_DEPENDS.TASK_ID
TableJTF_TASK_DEPENDS FK Joins to JTF_TASKS_B JTF_TASK_DEPENDS.DEPENDENT_ON_TASK_ID
TableJTF_TASK_REFERENCES_B FK Joins to JTF_TASKS_B JTF_TASK_REFERENCES_B.TASK_ID
TableJTF_TASK_RSC_REQS FK Joins to JTF_TASKS_B JTF_TASK_RSC_REQS.TASK_ID