VIEW: APPS.JTF_TASK_ALL_ASSIGNMENTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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