eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[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:	JTF.JTF_TASKS_B

Primary Key: JTF_TASKS_B_PK

TASK_ID

Primary Key: JTF_TASKS_PK

TASK_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
JTF_TASKS_B	JTF_OBJECTS_B	JTF_TASKS_B.SOURCE_OBJECT_TYPE_CODE
JTF_TASKS_B	HZ_CUST_ACCOUNTS	JTF_TASKS_B.CUST_ACCOUNT_ID
JTF_TASKS_B	HZ_PARTY_SITES	JTF_TASKS_B.ADDRESS_ID
JTF_TASKS_B	CS_INCIDENTS_ALL_B	JTF_TASKS_B.SOURCE_OBJECT_ID
JTF_TASKS_B	FND_USER	JTF_TASKS_B.ASSIGNED_BY_ID
JTF_TASKS_B	HZ_PARTIES	JTF_TASKS_B.CUSTOMER_ID
JTF_TASKS_B	JTF_OBJECTS_B	JTF_TASKS_B.SOURCE_OBJECT_TYPE_CODE
JTF_TASKS_B	HZ_TIMEZONES	JTF_TASKS_B.TIMEZONE_ID
JTF_TASKS_B	JTF_TASK_PRIORITIES_B	JTF_TASKS_B.TASK_PRIORITY_ID
JTF_TASKS_B	JTF_TASK_STATUSES_B	JTF_TASKS_B.TASK_STATUS_ID
JTF_TASKS_B	JTF_TASK_TYPES_B	JTF_TASKS_B.TASK_TYPE_ID
JTF_TASKS_B	JTF_TASK_RECUR_RULES	JTF_TASKS_B.RECURRENCE_RULE_ID
JTF_TASKS_B	HZ_PARTIES	JTF_TASKS_B.CUSTOMER_ID
JTF_TASKS_B	FND_CURRENCIES	JTF_TASKS_B.CURRENCY_CODE
JTF_TASKS_B	JTF_TASKS_B	JTF_TASKS_B.PARENT_TASK_ID
JTF_TASKS_B	%	JTF_TASKS_B.SOURCE_OBJECT_TYPE_CODE
JTF_TASKS_B	HZ_CUST_ACCOUNTS	JTF_TASKS_B.CUST_ACCOUNT_ID
JTF_TASKS_B	CS_INCIDENTS_ALL_B	JTF_TASKS_B.SOURCE_OBJECT_ID
JTF_TASKS_B	JTF_TASK_PRIORITIES_B	JTF_TASKS_B.TASK_PRIORITY_ID
JTF_TASKS_B	JTF_TASK_STATUSES_B	JTF_TASKS_B.TASK_STATUS_ID
JTF_TASKS_B	JTF_TASK_TYPES_B	JTF_TASKS_B.TASK_TYPE_ID
JTF_TASKS_B	JTF_TASK_RECUR_RULES	JTF_TASKS_B.RECURRENCE_RULE_ID
JTF_TASKS_B	HZ_PARTIES	JTF_TASKS_B.SOURCE_OBJECT_TYPE_CODE
JTF_TASKS_B	FND_CURRENCIES	JTF_TASKS_B.CURRENCY_CODE
JTF_TASKS_B	JTF_TASKS_B	JTF_TASKS_B.PARENT_TASK_ID
JTF_TASKS_B	HZ_PARTIES	JTF_TASKS_B.SOURCE_OBJECT_TYPE_CODE
JTF_TASKS_B	HZ_PARTY_SITES	JTF_TASKS_B.ADDRESS_ID
AMS_CAMPAIGNS_ALL_B	JTF_TASKS_B	AMS_CAMPAIGNS_ALL_B.TASK_ID
AMS_CAMPAIGN_SCHEDULES_B	JTF_TASKS_B	AMS_CAMPAIGN_SCHEDULES_B.TASK_ID
AS_SALES_METH_TASK_MAP	JTF_TASKS_B	AS_SALES_METH_TASK_MAP.TASK_ID
CSD_REPAIRS	JTF_TASKS_B	CSD_REPAIRS.TASK_ID
CSF_ACCESS_HOURS_B	JTF_TASKS_B	CSF_ACCESS_HOURS_B.TASK_ID
CSP_REQUIREMENT_HEADERS	JTF_TASKS_B	CSP_REQUIREMENT_HEADERS.TASK_ID
JTF_IH_ACTIVITIES	JTF_TASKS_B	JTF_IH_ACTIVITIES.TASK_ID
JTF_TASKS_B	JTF_TASKS_B	JTF_TASKS_B.PARENT_TASK_ID
JTF_TASKS_B	JTF_TASKS_B	JTF_TASKS_B.PARENT_TASK_ID
JTF_TASK_ASSIGNMENTS	JTF_TASKS_B	JTF_TASK_ASSIGNMENTS.TASK_ID
JTF_TASK_AUDITS_B	JTF_TASKS_B	JTF_TASK_AUDITS_B.TASK_ID
JTF_TASK_AUDITS_B	JTF_TASKS_B	JTF_TASK_AUDITS_B.NEW_PARENT_TASK_ID
JTF_TASK_AUDITS_B	JTF_TASKS_B	JTF_TASK_AUDITS_B.OLD_PARENT_TASK_ID
JTF_TASK_CONTACTS	JTF_TASKS_B	JTF_TASK_CONTACTS.TASK_ID
JTF_TASK_DATES	JTF_TASKS_B	JTF_TASK_DATES.TASK_ID
JTF_TASK_DEPENDS	JTF_TASKS_B	JTF_TASK_DEPENDS.TASK_ID
JTF_TASK_DEPENDS	JTF_TASKS_B	JTF_TASK_DEPENDS.DEPENDENT_ON_TASK_ID
JTF_TASK_REFERENCES_B	JTF_TASKS_B	JTF_TASK_REFERENCES_B.TASK_ID
JTF_TASK_RSC_REQS	JTF_TASKS_B	JTF_TASK_RSC_REQS.TASK_ID