Product: | CSF - Field Service |
---|---|
Description: | Used to extract predicted start and end times for tasks |
Implementation/DBA Data: | Not implemented in this database |
SELECT V.ROW_ID
, V.TASK_ASSIGNMENT_ID
, V.CREATED_BY
, V.CREATION_DATE
, V.LAST_UPDATED_BY
, V.LAST_UPDATE_DATE
, V.LAST_UPDATE_LOGIN
, V.TASK_ID
, V.RESOURCE_TYPE_CODE
, V.RESOURCE_ID
, V.ACTUAL_EFFORT
, V.ACTUAL_EFFORT_UOM
, V.SCHEDULE_FLAG
, V.ALARM_TYPE_CODE
, V.ALARM_CONTACT
, V.SCHED_TRAVEL_DISTANCE
, V.SCHED_TRAVEL_DURATION
, V.SCHED_TRAVEL_DURATION_UOM
, V.ACTUAL_TRAVEL_DISTANCE
, V.ACTUAL_TRAVEL_DURATION
, V.ACTUAL_TRAVEL_DURATION_UOM
, V.ACTUAL_START_DATE
, V.ACTUAL_END_DATE
, V.PALM_FLAG
, V.WINCE_FLAG
, V.LAPTOP_FLAG
, V.DEVICE1_FLAG
, V.DEVICE2_FLAG
, V.DEVICE3_FLAG
, V.ATTRIBUTE1
, V.ATTRIBUTE2
, V.ATTRIBUTE3
, V.ATTRIBUTE4
, V.ATTRIBUTE5
, V.ATTRIBUTE6
, V.ATTRIBUTE7
, V.ATTRIBUTE8
, V.ATTRIBUTE9
, V.ATTRIBUTE10
, V.ATTRIBUTE11
, V.ATTRIBUTE12
, V.ATTRIBUTE13
, V.ATTRIBUTE14
, V.ATTRIBUTE15
, V.ATTRIBUTE_CATEGORY
, V.OBJECT_VERSION_NUMBER
, V.RESOURCE_TERRITORY_ID
, V.ASSIGNMENT_STATUS_ID
, V.SHIFT_CONSTRUCT_ID
, V.TASK_NUMBER
, V.TASK_TYPE_ID
, V.TASK_STATUS_ID
, V.TASK_PRIORITY_ID
, V.OWNER_TYPE_CODE
, V.OWNER_ID
, V.ASSIGNED_BY_ID
, V.CUST_ACCOUNT_ID
, V.CUSTOMER_ID
, V.ADDRESS_ID
, V.PLANNED_START_DATE
, V.PLANNED_END_DATE
, V.SCHEDULED_START_DATE
, V.SCHEDULED_END_DATE
, V.TIMEZONE_ID
, V.SOURCE_OBJECT_TYPE_CODE
, V.SOURCE_OBJECT_ID
, V.SOURCE_OBJECT_NAME
, V.DURATION
, V.DURATION_UOM
, V.PLANNED_EFFORT
, V.PLANNED_EFFORT_UOM
, V.PERCENTAGE_COMPLETE
, V.REASON_CODE
, V.PRIVATE_FLAG
, V.PUBLISH_FLAG
, V.RESTRICT_CLOSURE_FLAG
, V.MULTI_BOOKED_FLAG
, V.MILESTONE_FLAG
, V.HOLIDAY_FLAG
, V.BILLABLE_FLAG
, V.BOUND_MODE_CODE
, V.SOFT_BOUND_FLAG
, V.WORKFLOW_PROCESS_ID
, CSF_AGENDA_CALCULATIONS.SET_ESCALATION_FLAG(V.TASK_ID) ESCALATION_FLAG
, V.ESCALATION_LEVEL
, V.NOTIFICATION_FLAG
, V.NOTIFICATION_PERIOD
, V.NOTIFICATION_PERIOD_UOM
, V.PARENT_TASK_ID
, V.ALARM_START
, V.ALARM_START_UOM
, V.ALARM_ON
, V.ALARM_COUNT
, V.ALARM_FIRED_COUNT
, V.ALARM_INTERVAL
, V.ALARM_INTERVAL_UOM
, V.RECURRENCE_RULE_ID
, V.COSTS
, V.CURRENCY_CODE
, V.ORG_ID
, V.SHIFT_START
, V.SHIFT_END
, NVL(V.ACTUAL_START_DATE
, V.SCHEDULED_START_DATE + CSF_AGENDA_CALCULATIONS.PREDICT_TIME_DIFFERENCE(V.TASK_ASSIGNMENT_ID)) PREDICTED_START_DATE
, NVL(V.ACTUAL_END_DATE
, V.SCHEDULED_END_DATE + CSF_AGENDA_CALCULATIONS.PREDICT_TIME_DIFFERENCE(V.TASK_ASSIGNMENT_ID)) PREDICTED_END_DATE
, SUBSTR(CSF_AGENDA_CALCULATIONS.SET_SEQUENCE_FLAG(V.TASK_ASSIGNMENT_ID)
, 1
, 1) OUT_OF_SEQUENCE_FLAG
, CSF_AGENDA_CALCULATIONS.GET_ASSIGNMENT_STATUS(V.RESOURCE_ID
, V.RESOURCE_TYPE_CODE) CURRENT_STATUS_ID
, SUBSTR(CSF_AGENDA_CALCULATIONS.GET_STATUS_NAME(CSF_AGENDA_CALCULATIONS.GET_ASSIGNMENT_STATUS(V.RESOURCE_ID
, V.RESOURCE_TYPE_CODE))
, 1
, 30) CURRENT_STATUS_NAME
, SUBSTR(CSF_AGENDA_CALCULATIONS.GET_STATUS_NAME(V.ASSIGNMENT_STATUS_ID)
, 1
, 30) ASSIGNMENT_STATUS_NAME
, CSF_AGENDA_CALCULATIONS.GET_CURRENT_TASK(V.RESOURCE_ID
, V.RESOURCE_TYPE_CODE) CURRENT_TASK_ID
FROM CSF_AGENDA_TA_V V