VIEW: APPS.OKL_CS_TASK_ASSIGNMENTS_UV

Source

View Text - Preformatted

SELECT ASSG.ROWID ROW_ID ,ASSG.TASK_ASSIGNMENT_ID TASK_ASSIGNMENT_ID ,ASSG.CREATED_BY CREATED_BY ,ASSG.CREATION_DATE CREATION_DATE ,ASSG.LAST_UPDATED_BY LAST_UPDATED_BY ,ASSG.LAST_UPDATE_DATE LAST_UPDATE_DATE ,ASSG.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN ,ASSG.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER ,ASSG.TASK_ID TASK_ID ,ASSG.RESOURCE_TYPE_CODE RESOURCE_TYPE_CODE ,OBJ.NAME RESOURCE_TYPE ,ASSG.RESOURCE_ID RESOURCE_ID ,JTF_TASK_UTL.GET_OWNER(ASSG.RESOURCE_TYPE_CODE,ASSG.RESOURCE_ID) RESOURCE_NAME ,ASSG.ASSIGNMENT_STATUS_ID ASSIGNMENT_STATUS_ID ,STAT.NAME ASSIGNMENT_STATUS ,ASSG.ACTUAL_EFFORT ACTUAL_EFFORT ,ASSG.RESOURCE_TERRITORY_ID RESOURCE_TERRITORY_ID ,ASSG.ACTUAL_EFFORT_UOM ACTUAL_EFFORT_UOM ,ASSG.SCHEDULE_FLAG SCHEDULE_FLAG ,ASSG.ALARM_TYPE_CODE ALARM_TYPE_CODE ,ASSG.ALARM_CONTACT ALARM_CONTACT ,ASSG.SCHED_TRAVEL_DISTANCE SCHED_TRAVEL_DISTANCE ,ASSG.SCHED_TRAVEL_DURATION SCHED_TRAVEL_DURATION ,ASSG.SCHED_TRAVEL_DURATION_UOM SCHED_TRAVEL_DURATION_UOM ,ASSG.ACTUAL_TRAVEL_DISTANCE ACTUAL_TRAVEL_DISTANCE ,ASSG.ACTUAL_TRAVEL_DURATION ACTUAL_TRAVEL_DURATION ,ASSG.ACTUAL_TRAVEL_DURATION_UOM ACTUAL_TRAVEL_DURATION_UOM ,ASSG.ACTUAL_START_DATE ACTUAL_START_DATE ,ASSG.ACTUAL_END_DATE ACTUAL_END_DATE ,ASSG.PALM_FLAG PALM_FLAG ,ASSG.WINCE_FLAG WINCE_FLAG ,ASSG.LAPTOP_FLAG LAPTOP_FLAG ,ASSG.DEVICE1_FLAG DEVICE1_FLAG ,ASSG.DEVICE2_FLAG DEVICE2_FLAG ,ASSG.DEVICE3_FLAG DEVICE3_FLAG ,ASSG.SHIFT_CONSTRUCT_ID SHIFT_CONSTRUCT_ID ,ASSG.ASSIGNEE_ROLE ASSIGNEE_ROLE ,ASSG.SHOW_ON_CALENDAR SHOW_ON_CALENDAR ,ASSG.CATEGORY_ID CATEGORY_ID FROM JTF_TASK_ASSIGNMENTS ASSG,JTF_OBJECTS_TL OBJ,JTF_TASK_STATUSES_TL STAT WHERE OBJ.OBJECT_CODE = ASSG.RESOURCE_TYPE_CODE AND STAT.TASK_STATUS_ID = ASSG.ASSIGNMENT_STATUS_ID AND OBJ.LANGUAGE = USERENV('LANG') AND STAT.LANGUAGE = USERENV('LANG') AND ASSG.ASSIGNEE_ROLE = 'ASSIGNEE'

View Text - HTML Formatted

SELECT ASSG.ROWID ROW_ID
, ASSG.TASK_ASSIGNMENT_ID TASK_ASSIGNMENT_ID
, ASSG.CREATED_BY CREATED_BY
, ASSG.CREATION_DATE CREATION_DATE
, ASSG.LAST_UPDATED_BY LAST_UPDATED_BY
, ASSG.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ASSG.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ASSG.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ASSG.TASK_ID TASK_ID
, ASSG.RESOURCE_TYPE_CODE RESOURCE_TYPE_CODE
, OBJ.NAME RESOURCE_TYPE
, ASSG.RESOURCE_ID RESOURCE_ID
, JTF_TASK_UTL.GET_OWNER(ASSG.RESOURCE_TYPE_CODE
, ASSG.RESOURCE_ID) RESOURCE_NAME
, ASSG.ASSIGNMENT_STATUS_ID ASSIGNMENT_STATUS_ID
, STAT.NAME ASSIGNMENT_STATUS
, ASSG.ACTUAL_EFFORT ACTUAL_EFFORT
, ASSG.RESOURCE_TERRITORY_ID RESOURCE_TERRITORY_ID
, ASSG.ACTUAL_EFFORT_UOM ACTUAL_EFFORT_UOM
, ASSG.SCHEDULE_FLAG SCHEDULE_FLAG
, ASSG.ALARM_TYPE_CODE ALARM_TYPE_CODE
, ASSG.ALARM_CONTACT ALARM_CONTACT
, ASSG.SCHED_TRAVEL_DISTANCE SCHED_TRAVEL_DISTANCE
, ASSG.SCHED_TRAVEL_DURATION SCHED_TRAVEL_DURATION
, ASSG.SCHED_TRAVEL_DURATION_UOM SCHED_TRAVEL_DURATION_UOM
, ASSG.ACTUAL_TRAVEL_DISTANCE ACTUAL_TRAVEL_DISTANCE
, ASSG.ACTUAL_TRAVEL_DURATION ACTUAL_TRAVEL_DURATION
, ASSG.ACTUAL_TRAVEL_DURATION_UOM ACTUAL_TRAVEL_DURATION_UOM
, ASSG.ACTUAL_START_DATE ACTUAL_START_DATE
, ASSG.ACTUAL_END_DATE ACTUAL_END_DATE
, ASSG.PALM_FLAG PALM_FLAG
, ASSG.WINCE_FLAG WINCE_FLAG
, ASSG.LAPTOP_FLAG LAPTOP_FLAG
, ASSG.DEVICE1_FLAG DEVICE1_FLAG
, ASSG.DEVICE2_FLAG DEVICE2_FLAG
, ASSG.DEVICE3_FLAG DEVICE3_FLAG
, ASSG.SHIFT_CONSTRUCT_ID SHIFT_CONSTRUCT_ID
, ASSG.ASSIGNEE_ROLE ASSIGNEE_ROLE
, ASSG.SHOW_ON_CALENDAR SHOW_ON_CALENDAR
, ASSG.CATEGORY_ID CATEGORY_ID
FROM JTF_TASK_ASSIGNMENTS ASSG
, JTF_OBJECTS_TL OBJ
, JTF_TASK_STATUSES_TL STAT
WHERE OBJ.OBJECT_CODE = ASSG.RESOURCE_TYPE_CODE
AND STAT.TASK_STATUS_ID = ASSG.ASSIGNMENT_STATUS_ID
AND OBJ.LANGUAGE = USERENV('LANG')
AND STAT.LANGUAGE = USERENV('LANG')
AND ASSG.ASSIGNEE_ROLE = 'ASSIGNEE'