DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.JTF_TASKS_V

Object Details
Object Name: JTF_TASKS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJTF.JTF_TASKS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Common View with all the task attributes.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Identifier
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).
TASK_NUMBER VARCHAR2 (30) Yes Task Number
TASK_NAME VARCHAR2 (80) Yes Task Name
TASK_TYPE_ID NUMBER
Yes Task type (foreign key to JTF_TASK_TYPES)
TASK_TYPE VARCHAR2 (30) Yes Task Type
TASK_STATUS_ID NUMBER
Yes Task status (foreign key to JTF_TASK_STATUSES)
TASK_STATUS VARCHAR2 (30) Yes Task Status
CLOSED VARCHAR2 (1)
Indicates if the Task is closed.
TASK_PRIORITY_ID NUMBER

Task priority (foreign key to JTF_TASK_PRIORITIES)
TASK_PRIORITY VARCHAR2 (30)
Task Priority
OWNER_ID NUMBER
Yes Owner of the task
OWNER VARCHAR2 (4000)
Owner
OWNER_TYPE_CODE VARCHAR2 (30) Yes Resource type identifier of task owner
OWNER_TYPE VARCHAR2 (30) Yes Resource Type description of the Task Owner
ASSIGNED_BY_ID NUMBER

User who assigned the task to current owner
ASSIGNED_BY_NAME VARCHAR2 (4000)
User Name who assigned the task to current owner
DESCRIPTION VARCHAR2 (4000)
Task description
CUSTOMER_ID NUMBER

Customer associated with task
CUSTOMER_NAME VARCHAR2 (360)
Customer name associated with task
CUSTOMER_NUMBER VARCHAR2 (30)
Customer Number associated with task
CUST_ACCOUNT_ID NUMBER

Customer account identifier
CUST_ACCOUNT_NUMBER VARCHAR2 (30)
Customer account number
ADDRESS_ID NUMBER

Address Identifier
ADDRESS1 VARCHAR2 (240)
Address of the customer.
ADDRESS2 VARCHAR2 (724)
Address of the customer.
ADDRESS3 VARCHAR2 (245)
Address of the customer.
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
TIMEZONE_ID NUMBER

Time zone identifier
GLOBAL_TIMEZONE_NAME VARCHAR2 (80)
Time zone name
GMT_DEVIATION_HOURS NUMBER

GMT deviation hours
SOURCE_OBJECT_TYPE_CODE VARCHAR2 (30)
Type of source object (foreign key to JTF_TASK_OBJECT_TYPES)
SOURCE_OBJECT_TYPE VARCHAR2 (30) Yes Source Object Type
SOURCE_OBJECT_ID NUMBER

Internal ID of source object
SOURCE_OBJECT_NAME VARCHAR2 (80)
User-visible source object identifier
OBJECT_FUNCTION VARCHAR2 (30)
Function to be invoked for this Object.
OBJECT_PARAMETERS VARCHAR2 (2000)
Parameters to be passed while invoking function.
WORKFLOW_PROCESS_ID NUMBER

Identifier of las workflow process launched for this task
ACTIVE_WF_PROCESS VARCHAR2 (4000)
Indicates if the last launched workflow is active
WORKFLOW_PROCESS_NAME VARCHAR2 (30)
Name of last workflow process launched for this task
WORKFLOW_DISPLAY_NAME VARCHAR2 (4000)
Display name of last workflow process launched for this task
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 rejecting a task, reassigning a task, etc.
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 thesource 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.
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
PARENT_TASK_NUMBER VARCHAR2 (4000)
Parent Task's Number
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
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
DELETED_FLAG VARCHAR2 (1)
Flag indicating the task has been deleted
COSTS NUMBER

Used by Marketing
CURRENCY_CODE VARCHAR2 (15)
Used by Marketing
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.
OBJECT_VERSION_NUMBER NUMBER
Yes Sequential number used for database locking control when using HTML as a user interface
OWNER_TERRITORY_ID NUMBER

Territory identifier of the Owner
OWNER_TERRITORY_NAME VARCHAR2 (4000)
Territory name of the Owner
ESCALATION_LEVEL VARCHAR2 (4000)
Escalation Level
OPEN_FLAG VARCHAR2 (1)
This column is used to indicate whether the task is open or closed
TEMPLATE_GROUP_ID NUMBER

Foreign key for template group id
TASK_CONFIRMATION_STATUS VARCHAR2 (1)
Task Confirmation Status
TASK_CONFIRMATION_COUNTER NUMBER

Task Confirmation Counter
TASK_SPLIT_FLAG VARCHAR2 (1)
Task Split Flag
ENTITY VARCHAR2 (30) Yes Entity of the task
LOCATION_ID NUMBER

Location Identifier
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      TASK_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      TASK_NUMBER
,      TASK_NAME
,      TASK_TYPE_ID
,      TASK_TYPE
,      TASK_STATUS_ID
,      TASK_STATUS
,      CLOSED
,      TASK_PRIORITY_ID
,      TASK_PRIORITY
,      OWNER_ID
,      OWNER
,      OWNER_TYPE_CODE
,      OWNER_TYPE
,      ASSIGNED_BY_ID
,      ASSIGNED_BY_NAME
,      DESCRIPTION
,      CUSTOMER_ID
,      CUSTOMER_NAME
,      CUSTOMER_NUMBER
,      CUST_ACCOUNT_ID
,      CUST_ACCOUNT_NUMBER
,      ADDRESS_ID
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      PLANNED_START_DATE
,      PLANNED_END_DATE
,      SCHEDULED_START_DATE
,      SCHEDULED_END_DATE
,      ACTUAL_START_DATE
,      ACTUAL_END_DATE
,      TIMEZONE_ID
,      GLOBAL_TIMEZONE_NAME
,      GMT_DEVIATION_HOURS
,      SOURCE_OBJECT_TYPE_CODE
,      SOURCE_OBJECT_TYPE
,      SOURCE_OBJECT_ID
,      SOURCE_OBJECT_NAME
,      OBJECT_FUNCTION
,      OBJECT_PARAMETERS
,      WORKFLOW_PROCESS_ID
,      ACTIVE_WF_PROCESS
,      WORKFLOW_PROCESS_NAME
,      WORKFLOW_DISPLAY_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
,      NOTIFICATION_FLAG
,      NOTIFICATION_PERIOD
,      NOTIFICATION_PERIOD_UOM
,      PARENT_TASK_ID
,      PARENT_TASK_NUMBER
,      RECURRENCE_RULE_ID
,      ALARM_START
,      ALARM_START_UOM
,      ALARM_ON
,      ALARM_COUNT
,      ALARM_FIRED_COUNT
,      ALARM_INTERVAL
,      ALARM_INTERVAL_UOM
,      PALM_FLAG
,      WINCE_FLAG
,      LAPTOP_FLAG
,      DEVICE1_FLAG
,      DEVICE2_FLAG
,      DEVICE3_FLAG
,      DELETED_FLAG
,      COSTS
,      CURRENCY_CODE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      OBJECT_VERSION_NUMBER
,      OWNER_TERRITORY_ID
,      OWNER_TERRITORY_NAME
,      ESCALATION_LEVEL
,      OPEN_FLAG
,      TEMPLATE_GROUP_ID
,      TASK_CONFIRMATION_STATUS
,      TASK_CONFIRMATION_COUNTER
,      TASK_SPLIT_FLAG
,      ENTITY
,      LOCATION_ID
FROM APPS.JTF_TASKS_V;

Dependencies

[top of page]

APPS.JTF_TASKS_V references the following:

SchemaAPPS
ViewFND_TIMEZONES_VL
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_LOCATIONS
SynonymHZ_PARTIES
SynonymHZ_PARTY_SITES
SynonymJTF_OBJECTS_B
SynonymJTF_OBJECTS_TL
ViewJTF_TASKS_VL
SynonymJTF_TASK_PRIORITIES_TL
SynonymJTF_TASK_STATUSES_B
SynonymJTF_TASK_STATUSES_TL
SynonymJTF_TASK_TYPES_B
SynonymJTF_TASK_TYPES_TL
PL/SQL PackageJTF_TASK_UTL - show dependent code
PL/SQL PackageJTF_TASK_WORKFLOW_PKG - show dependent code
APPS.JTF_TASKS_V is referenced by following:

SchemaAPPS
ViewAMS_TASKS_V
Package BodyCS_EA_AUTOGEN_TASKS_PVT - show dependent code
ViewCS_INCIDENTS_DIARY_V
Package BodyCS_WF_ACTIVITIES_PKG - show dependent code
Package BodyCUG_GENERIC_WF_PKG - show dependent code
ViewJTF_BRM_3D_TASK_V
Package BodyJTF_ESCWFACTIVITY_PVT - show dependent code
Package BodyJTF_TASKS_PUB - show dependent code
PL/SQL PackageJTF_TASKS_PUB - show dependent code
PL/SQL PackageJTF_TASKS_PVT - show dependent code
Package BodyJTF_TASKS_PVT - show dependent code
Package BodyJTF_TASK_WORKFLOW_PKG - show dependent code
Package BodyOKC_TASK_ALERT_ESCL_PVT - show dependent code
Package BodyOKC_TASK_PVT - show dependent code