FND Design Data [Home] [Help]

Table: JTF_TASK_AUDITS_B

Product: JTF - CRM Foundation
Description: Base Table which stores audit information for a task.
Implementation/DBA Data: TableJTF.JTF_TASK_AUDITS_B
Primary Key: JTF_TASK_AUDITS_B_PK
  1. ColumnTASK_AUDIT_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
JTF_TASK_AUDITS_B FK Joins to TableJTF_TASKS_B JTF_TASK_AUDITS_B.TASK_ID
JTF_TASK_AUDITS_B FK Joins to TableJTF_TASK_STATUSES_B JTF_TASK_AUDITS_B.NEW_TASK_STATUS_ID
JTF_TASK_AUDITS_B FK Joins to TableJTF_TASKS_B JTF_TASK_AUDITS_B.NEW_PARENT_TASK_ID
JTF_TASK_AUDITS_B FK Joins to TableJTF_TASK_TYPES_B JTF_TASK_AUDITS_B.NEW_TASK_TYPE_ID
JTF_TASK_AUDITS_B FK Joins to TableJTF_TASK_TYPES_B JTF_TASK_AUDITS_B.OLD_TASK_TYPE_ID
JTF_TASK_AUDITS_B FK Joins to TableHZ_PARTY_SITES JTF_TASK_AUDITS_B.OLD_ADDRESS_ID
JTF_TASK_AUDITS_B FK Joins to TableFND_USER JTF_TASK_AUDITS_B.OLD_ASSIGNED_BY_ID
JTF_TASK_AUDITS_B FK Joins to TableHZ_PARTIES JTF_TASK_AUDITS_B.OLD_CUSTOMER_ID
JTF_TASK_AUDITS_B FK Joins to TableHZ_CUST_ACCOUNTS JTF_TASK_AUDITS_B.OLD_CUST_ACCOUNT_ID
JTF_TASK_AUDITS_B FK Joins to TableJTF_TASKS_B JTF_TASK_AUDITS_B.OLD_PARENT_TASK_ID
JTF_TASK_AUDITS_B FK Joins to TableJTF_TASK_RECUR_RULES JTF_TASK_AUDITS_B.OLD_RECURRENCE_RULE_ID
JTF_TASK_AUDITS_B FK Joins to TableHZ_PARTY_SITES JTF_TASK_AUDITS_B.NEW_ADDRESS_ID
JTF_TASK_AUDITS_B FK Joins to TableHZ_TIMEZONES JTF_TASK_AUDITS_B.NEW_TIMEZONE_ID
JTF_TASK_AUDITS_B FK Joins to TableHZ_TIMEZONES JTF_TASK_AUDITS_B.OLD_TIMEZONE_ID
JTF_TASK_AUDITS_B FK Joins to TableCS_INCIDENTS_ALL_B JTF_TASK_AUDITS_B.OLD_SOURCE_OBJECT_ID
JTF_TASK_AUDITS_B FK Joins to TableCS_INCIDENTS_ALL_B JTF_TASK_AUDITS_B.NEW_SOURCE_OBJECT_ID
JTF_TASK_AUDITS_B FK Joins to TableFND_USER JTF_TASK_AUDITS_B.NEW_ASSIGNED_BY_ID
JTF_TASK_AUDITS_B FK Joins to TableHZ_PARTIES JTF_TASK_AUDITS_B.NEW_CUSTOMER_ID
JTF_TASK_AUDITS_B FK Joins to TableHZ_CUST_ACCOUNTS JTF_TASK_AUDITS_B.NEW_CUST_ACCOUNT_ID
JTF_TASK_AUDITS_B FK Joins to TableJTF_TASK_RECUR_RULES JTF_TASK_AUDITS_B.NEW_RECURRENCE_RULE_ID
JTF_TASK_AUDITS_B FK Joins to TableJTF_TASK_PRIORITIES_B JTF_TASK_AUDITS_B.NEW_TASK_PRIORITY_ID
JTF_TASK_AUDITS_B FK Joins to TableJTF_TASK_PRIORITIES_B JTF_TASK_AUDITS_B.OLD_TASK_PRIORITY_ID
JTF_TASK_AUDITS_B FK Joins to TableJTF_TASK_STATUSES_B JTF_TASK_AUDITS_B.OLD_TASK_STATUS_ID
JTF_TASK_AUDITS_B FK Joins to Table% JTF_TASK_AUDITS_B.TASK_ID