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

VIEW: APPS.JTF_TASK_ALL_ASSIGNMENTS_V

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

View Type

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


This view is used to get all the assignments where the ASSIGNEE_ROLE is OWNER or ASSIGNEE.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Id
TASK_ASSIGNMENT_ID NUMBER
Yes Unique task assignment identifier
CREATED_BY NUMBER
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
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

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_ID NUMBER
Yes Task identifier (foreign key to JTF_TASKS_VL)
RESOURCE_TYPE_CODE VARCHAR2 (30) Yes Resource type identifier
RESOURCE_ID NUMBER
Yes Resource ID
ASSIGNMENT_STATUS_ID NUMBER
Yes Status identifier of the asignee
ACTUAL_EFFORT NUMBER

Actual amont of effort spent on a task
RESOURCE_TERRITORY_ID NUMBER

Territory identifier of the assignee
ACTUAL_EFFORT_UOM VARCHAR2 (3)
Unit of measure for actual effort
SCHEDULE_FLAG VARCHAR2 (1)
Indicates whether the resource should be scheduled by the Scheduler
ALARM_TYPE_CODE VARCHAR2 (30)
A lookup code that indicates how alarms should be sent to the resource., e.g., 'EMAIL', 'PAGER', 'PHONE'
ALARM_CONTACT VARCHAR2 (200)
Contact information for sending alarms, this field may store emial address, pager number, or phone number
SCHED_TRAVEL_DISTANCE NUMBER

Scheduled Travel Distance
SCHED_TRAVEL_DURATION NUMBER

Scheduled Travel Duration
SCHED_TRAVEL_DURATION_UOM VARCHAR2 (3)
Unit of measure for Scheduled Travel Duration
ACTUAL_TRAVEL_DISTANCE NUMBER

Actual Travel Distance
ACTUAL_TRAVEL_DURATION NUMBER

Actual Travel Duration
ACTUAL_TRAVEL_DURATION_UOM VARCHAR2 (3)
Unit of Measure for Actual Travel Duration
ACTUAL_START_DATE DATE

Actual start date
ACTUAL_END_DATE DATE

Actual end date
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
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 (30)
Descriptive flexfield structure definition column.
SHIFT_CONSTRUCT_ID NUMBER

Shift construct identifier for the assignment
ASSIGNEE_ROLE VARCHAR2 (30)
An indicator to determine an assignee's role. The possible values are ASSIGNEE and OWNER.
SHOW_ON_CALENDAR VARCHAR2 (1)
A flag to determine whether the task is shown on calendar.
CATEGORY_ID NUMBER

Category identifier. Foriegn Key to JTF_PERZ_DATA. This is used as the identifier which a resource categorizes the tasks.
REMINDER_WF_ITEM_TYPE VARCHAR2 (8)
Reminder WF Item Type
REMINDER_WF_ITEM_KEY VARCHAR2 (240)
Reminder WF item key
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
FREE_BUSY_TYPE VARCHAR2 (100) Yes Free-Busy Type
BOOKING_START_DATE DATE

Booking start date
BOOKING_END_DATE DATE

Booking end date
OBJECT_CAPACITY_ID NUMBER

Object capacity Id
Query Text

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


SELECT ROW_ID
,      TASK_ASSIGNMENT_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      TASK_ID
,      RESOURCE_TYPE_CODE
,      RESOURCE_ID
,      ASSIGNMENT_STATUS_ID
,      ACTUAL_EFFORT
,      RESOURCE_TERRITORY_ID
,      ACTUAL_EFFORT_UOM
,      SCHEDULE_FLAG
,      ALARM_TYPE_CODE
,      ALARM_CONTACT
,      SCHED_TRAVEL_DISTANCE
,      SCHED_TRAVEL_DURATION
,      SCHED_TRAVEL_DURATION_UOM
,      ACTUAL_TRAVEL_DISTANCE
,      ACTUAL_TRAVEL_DURATION
,      ACTUAL_TRAVEL_DURATION_UOM
,      ACTUAL_START_DATE
,      ACTUAL_END_DATE
,      PALM_FLAG
,      WINCE_FLAG
,      LAPTOP_FLAG
,      DEVICE1_FLAG
,      DEVICE2_FLAG
,      DEVICE3_FLAG
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      SHIFT_CONSTRUCT_ID
,      ASSIGNEE_ROLE
,      SHOW_ON_CALENDAR
,      CATEGORY_ID
,      REMINDER_WF_ITEM_TYPE
,      REMINDER_WF_ITEM_KEY
,      ORIG_SYSTEM_REFERENCE
,      ORIG_SYSTEM_REFERENCE_ID
,      UPDATE_STATUS_FLAG
,      FREE_BUSY_TYPE
,      BOOKING_START_DATE
,      BOOKING_END_DATE
,      OBJECT_CAPACITY_ID
FROM APPS.JTF_TASK_ALL_ASSIGNMENTS_V;

Dependencies

[top of page]

APPS.JTF_TASK_ALL_ASSIGNMENTS_V references the following:

SchemaAPPS
SynonymJTF_TASK_ALL_ASSIGNMENTS

APPS.JTF_TASK_ALL_ASSIGNMENTS_V is not referenced by any database object