[Home] [Help] [Dependency Information]
Object Name: | JTF_TASKS_B |
---|---|
Object Type: | TABLE |
Owner: | JTF |
FND Design Data: | JTF.JTF_TASKS_B |
Subobject Name: | |
Status: | VALID |
Base Table JTF_TASKS_B stores general information about a given Task.
Each line includes details about owner, source object, customer, dates, effort and duration.
Also, this table contains multiple flags used by the various consumers of the foundation Task Manager.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JTF_TASKS_B_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | TASK_ID |
JTF_TASKS_B_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX | TASK_NUMBER |
JTF_TASKS_B_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
SOURCE_OBJECT_TYPE_CODE
SOURCE_OBJECT_ID |
JTF_TASKS_B_N10 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | OBJECT_CHANGED_DATE |
JTF_TASKS_B_N11 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ADDRESS_ID |
JTF_TASKS_B_N12 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
SCHEDULED_START_DATE
SCHEDULED_END_DATE |
JTF_TASKS_B_N13 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
CALENDAR_START_DATE
CALENDAR_END_DATE |
JTF_TASKS_B_N14 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LAST_UPDATE_DATE |
JTF_TASKS_B_N15 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PARENT_TASK_ID |
JTF_TASKS_B_N16 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
OPEN_FLAG
TASK_TYPE_ID |
JTF_TASKS_B_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
OWNER_ID
OWNER_TYPE_CODE OPEN_FLAG |
JTF_TASKS_B_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
TASK_TYPE_ID
OWNER_ID OWNER_TYPE_CODE |
JTF_TASKS_B_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TASK_STATUS_ID |
JTF_TASKS_B_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CUSTOMER_ID |
JTF_TASKS_B_N6 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CUST_ACCOUNT_ID |
JTF_TASKS_B_N7 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ORIG_SYSTEM_REFERENCE
ORIG_SYSTEM_REFERENCE_ID |
JTF_TASKS_B_N8 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | RECURRENCE_RULE_ID |
JTF_TASKS_B_N9 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PLANNED_START_DATE
PLANNED_END_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TASK_ID | NUMBER | Yes | Unique task identifier (PK) | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | Sequential number used for database locking control when using HTML as a user interface | |
TASK_NUMBER | VARCHAR2 | (30) | Yes | Task Number |
TASK_TYPE_ID | NUMBER | Yes | Task type (foreign key to JTF_TASK_TYPES_VL ) | |
TASK_STATUS_ID | NUMBER | Yes | Task status (foreign key to JTF_TASK_STATUSES_VL) | |
TASK_PRIORITY_ID | NUMBER | Task priority (foreign key to JTF_TASK_PRIORITIES) | ||
OWNER_ID | NUMBER | Yes | Owner of the task | |
OWNER_TYPE_CODE | VARCHAR2 | (30) | Yes | Resource type identifier of task owner |
OWNER_TERRITORY_ID | NUMBER | Territory identifier of the Owner | ||
ASSIGNED_BY_ID | NUMBER | User who assigned the task to current owner | ||
CUST_ACCOUNT_ID | NUMBER | Customer account identifier | ||
CUSTOMER_ID | NUMBER | Customer associated with task | ||
ADDRESS_ID | NUMBER | Address Identifier | ||
PLANNED_START_DATE | DATE | Planned start date | ||
PLANNED_END_DATE | DATE | Planned end date | ||
SCHEDULED_START_DATE | DATE | Scheduled start date | ||
SCHEDULED_END_DATE | DATE | Scheduled end date | ||
ACTUAL_START_DATE | DATE | Actual start date | ||
ACTUAL_END_DATE | DATE | Actual end date | ||
SOURCE_OBJECT_TYPE_CODE | VARCHAR2 | (30) | Source type (foreign key to JTF_OBJECTS_VL) | |
TIMEZONE_ID | NUMBER | Time zone identifier | ||
SOURCE_OBJECT_ID | NUMBER | Internal ID of source object | ||
SOURCE_OBJECT_NAME | VARCHAR2 | (80) | User-visible source object identifier | |
DURATION | NUMBER | Duration of task | ||
DURATION_UOM | VARCHAR2 | (3) | Unit of measure for duration | |
PLANNED_EFFORT | NUMBER | Planned effort | ||
PLANNED_EFFORT_UOM | VARCHAR2 | (3) | Unit of measure for planned effort | |
ACTUAL_EFFORT | NUMBER | Actual amount of effort spent on a task by all assignees | ||
ACTUAL_EFFORT_UOM | VARCHAR2 | (3) | Unit of measure for actual work | |
PERCENTAGE_COMPLETE | NUMBER | Percentage completion of task | ||
REASON_CODE | VARCHAR2 | (30) | Reason for updating the task | |
PRIVATE_FLAG | VARCHAR2 | (1) | Indicates whether the task is private or public | |
PUBLISH_FLAG | VARCHAR2 | (1) | Indicates whether the task should be published. | |
RESTRICT_CLOSURE_FLAG | VARCHAR2 | (1) | Indicates whether completing the task is necessary for the source object to be deemed complete | |
MULTI_BOOKED_FLAG | VARCHAR2 | (1) | Indicates whether the task can book resources that are already assigned to other tasks | |
MILESTONE_FLAG | VARCHAR2 | (1) | Indicates whether the task is a milestone delivery date | |
HOLIDAY_FLAG | VARCHAR2 | (1) | Indicates whether the task can be performed on holidays | |
BILLABLE_FLAG | VARCHAR2 | (1) | Indicates whether the task is billable. | |
BOUND_MODE_CODE | VARCHAR2 | (30) | Used for Scheduling. | |
SOFT_BOUND_FLAG | VARCHAR2 | (1) | Used for Scheduling. | |
WORKFLOW_PROCESS_ID | NUMBER | Identifier of las workflow process launched for this task | ||
NOTIFICATION_FLAG | VARCHAR2 | (1) | Flag indicating whether notification workflow will be automatically launched. | |
NOTIFICATION_PERIOD | NUMBER | Time before the scheduled start date that a notification is sent to the assignees | ||
NOTIFICATION_PERIOD_UOM | VARCHAR2 | (3) | Unit of measure for notification period | |
PARENT_TASK_ID | NUMBER | Parent Task's ID | ||
RECURRENCE_RULE_ID | NUMBER | Recurrence rule identifier | ||
ALARM_START | NUMBER | Indicates when the first alarm should be fired | ||
ALARM_START_UOM | VARCHAR2 | (3) | Unit of measure for ALARM_START | |
ALARM_ON | VARCHAR2 | (1) | Indicates whether the alarm is on | |
ALARM_COUNT | NUMBER | Total number of alarms to fire | ||
ALARM_FIRED_COUNT | NUMBER | Number of alarms fired | ||
ALARM_INTERVAL | NUMBER | Alarm interval | ||
ALARM_INTERVAL_UOM | VARCHAR2 | (3) | Unit of measure for Alarm Interval | |
DELETED_FLAG | VARCHAR2 | (1) | Flag indicating the task has been deleted | |
PALM_FLAG | VARCHAR2 | (1) | Used by Mobile Device | |
WINCE_FLAG | VARCHAR2 | (1) | Used by Mobile Device | |
LAPTOP_FLAG | VARCHAR2 | (1) | Used by Mobile Device | |
DEVICE1_FLAG | VARCHAR2 | (1) | Used by Mobile Device | |
DEVICE2_FLAG | VARCHAR2 | (1) | Used by Mobile Device | |
DEVICE3_FLAG | VARCHAR2 | (1) | Used by Mobile Device | |
COSTS | NUMBER | Used by Marketing | ||
CURRENCY_CODE | VARCHAR2 | (15) | Used by Marketing. | |
ORG_ID | NUMBER | Organization identifier | ||
ESCALATION_LEVEL | VARCHAR2 | (30) | Escalation Level | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Descriptive flexfield structure definition column. | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
ORIG_SYSTEM_REFERENCE | VARCHAR2 | (60) | Identifier of the system or table where this row was originally created | |
ORIG_SYSTEM_REFERENCE_ID | NUMBER | Unique identifier for this row in the original system or table | ||
UPDATE_STATUS_FLAG | VARCHAR2 | (1) | To support partial re-run of upgrade or migration | |
CALENDAR_START_DATE | DATE | The date the task/appointment starts | ||
CALENDAR_END_DATE | DATE | The date the task/appointment ends | ||
DATE_SELECTED | VARCHAR2 | (1) | The date selected. P for Planned, S for Scheduled, A for Actual | |
TEMPLATE_ID | NUMBER | Template identifier. Foriegn Key to JTF_TASK_TEMPLATES_B. This is an identifier of the template task belongs to a template group. | ||
TEMPLATE_GROUP_ID | NUMBER | Template group identifier. Foriegn Key to JTF_TASK_TEMP_GROUPS_B. The template group is used to create a set of tasks defined as a group. | ||
OBJECT_CHANGED_DATE | DATE | column to indicate if the task object has changed including the repating /exclusions part of the object this has been added for the sync code to work more effectively | ||
TASK_CONFIRMATION_STATUS | VARCHAR2 | (1) | Customer confirmation status | |
TASK_CONFIRMATION_COUNTER | NUMBER | Customer confirmation counter | ||
TASK_SPLIT_FLAG | VARCHAR2 | (1) | Used to mark split task | |
OPEN_FLAG | VARCHAR2 | (1) | This column is used to indicate whether the task is open or closed | |
ENTITY | VARCHAR2 | (30) | Yes | Used for distinguishing between different entities |
CHILD_POSITION | VARCHAR2 | (1) | To hold the position of child in respect to the parent | |
CHILD_SEQUENCE_NUM | NUMBER | (15) | To hold the sequence number in the dependency chain for the parent | |
LOCATION_ID | NUMBER | Location Identifier |
Cut, paste (and edit) the following text to query this object:
SELECT TASK_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, TASK_NUMBER
, TASK_TYPE_ID
, TASK_STATUS_ID
, TASK_PRIORITY_ID
, OWNER_ID
, OWNER_TYPE_CODE
, OWNER_TERRITORY_ID
, ASSIGNED_BY_ID
, CUST_ACCOUNT_ID
, CUSTOMER_ID
, ADDRESS_ID
, PLANNED_START_DATE
, PLANNED_END_DATE
, SCHEDULED_START_DATE
, SCHEDULED_END_DATE
, ACTUAL_START_DATE
, ACTUAL_END_DATE
, SOURCE_OBJECT_TYPE_CODE
, TIMEZONE_ID
, SOURCE_OBJECT_ID
, SOURCE_OBJECT_NAME
, DURATION
, DURATION_UOM
, PLANNED_EFFORT
, PLANNED_EFFORT_UOM
, ACTUAL_EFFORT
, ACTUAL_EFFORT_UOM
, PERCENTAGE_COMPLETE
, REASON_CODE
, PRIVATE_FLAG
, PUBLISH_FLAG
, RESTRICT_CLOSURE_FLAG
, MULTI_BOOKED_FLAG
, MILESTONE_FLAG
, HOLIDAY_FLAG
, BILLABLE_FLAG
, BOUND_MODE_CODE
, SOFT_BOUND_FLAG
, WORKFLOW_PROCESS_ID
, NOTIFICATION_FLAG
, NOTIFICATION_PERIOD
, NOTIFICATION_PERIOD_UOM
, PARENT_TASK_ID
, RECURRENCE_RULE_ID
, ALARM_START
, ALARM_START_UOM
, ALARM_ON
, ALARM_COUNT
, ALARM_FIRED_COUNT
, ALARM_INTERVAL
, ALARM_INTERVAL_UOM
, DELETED_FLAG
, PALM_FLAG
, WINCE_FLAG
, LAPTOP_FLAG
, DEVICE1_FLAG
, DEVICE2_FLAG
, DEVICE3_FLAG
, COSTS
, CURRENCY_CODE
, ORG_ID
, ESCALATION_LEVEL
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY
, SECURITY_GROUP_ID
, ORIG_SYSTEM_REFERENCE
, ORIG_SYSTEM_REFERENCE_ID
, UPDATE_STATUS_FLAG
, CALENDAR_START_DATE
, CALENDAR_END_DATE
, DATE_SELECTED
, TEMPLATE_ID
, TEMPLATE_GROUP_ID
, OBJECT_CHANGED_DATE
, TASK_CONFIRMATION_STATUS
, TASK_CONFIRMATION_COUNTER
, TASK_SPLIT_FLAG
, OPEN_FLAG
, ENTITY
, CHILD_POSITION
, CHILD_SEQUENCE_NUM
, LOCATION_ID
FROM JTF.JTF_TASKS_B;
JTF.JTF_TASKS_B does not reference any database object
JTF.JTF_TASKS_B is referenced by following:
|
|
|