FFS_REP_ACTIVITY_V

Details

• Schema: FUSION

• Object owner: FFS

• Object type: VIEW

Columns

Name
ROUTE_DATE ROUTE_ID RESOURCE_ID ACTIVITY_ID RECORD_TYPE TYPE_ID STATUS ETA DURATION SERVICE_WINDOW_START SERVICE_WINDOW_END SERVICE_WINDOW_START_MINS SERVICE_WINDOW_END_MINS TRAVEL_TIME TIME_DELIVERED_START TIME_DELIVERED_END

Query

SQL_Statement

SELECT ffs_route.route_date, ffs_route.route_id, ffs_resource.resource_id, ffs_activity.activity_id, ffs_activity.record_type, ffs_activity.type_id, ffs_activity.status, ffs_activity.eta, ffs_activity.duration, TO_CHAR(trunc(SYSDATE) + ffs_activity.service_window_start / 24 / 60, 'HH24:MI') AS service_window_start, TO_CHAR(trunc(SYSDATE) + ffs_activity.service_window_end / 24 / 60, 'HH24:MI') AS service_window_end, ffs_activity.service_window_start AS service_window_start_mins, ffs_activity.service_window_end AS service_window_end_mins, ffs_activity.travel_time, ffs_activity.time_delivered_start, ffs_activity.time_delivered_end FROM ffs_route INNER JOIN ffs_resource ON abs(ffs_route.resource_id) = ffs_resource.resource_id INNER JOIN ffs_activity ON ffs_route.route_id = ffs_activity.route_id