Product: | JTF - CRM Foundation |
---|---|
Description: | This view is used to get all the assignments where the ASSIGNEE_ROLE is OWNER or ASSIGNEE. |
Implementation/DBA Data: | APPS.JTF_TASK_ALL_ASSIGNMENTS_V |
SELECT ROWID 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 JTF_TASK_ALL_ASSIGNMENTS