View: CSR_PLAN_TASKS_V

Product:	CSR - Scheduler
Description:	Tasks that may be scheduled.
Implementation/DBA Data:	APPS.CSR_PLAN_TASKS_V

View Text

SELECT TA.ACTUAL_END_DATE ACTUAL_END_DATE
, TA.ACTUAL_START_DATE ACTUAL_START_DATE
, CSF_UTIL_PVT.CONVERT_TO_MINUTES(T.PLANNED_EFFORT
, T.PLANNED_EFFORT_UOM) PLANNED_EFFORT
, CSF_UTIL_PVT.GET_UOM_MINUTES PLANNED_EFFORT_UOM
, T.SCHEDULED_END_DATE SCHEDULED_END_DATE
, T.SCHEDULED_START_DATE SCHEDULED_START_DATE
, T.TASK_ID TASK_ID
, T.TASK_TYPE_ID TASK_TYPE_ID
, T.PLANNED_END_DATE PLANNED_END_DATE
, T.PLANNED_START_DATE PLANNED_START_DATE
, NVL( T.BOUND_MODE_CODE
, 'BTS') BOUND_MODE_CODE
, T.SOFT_BOUND_FLAG SOFT_BOUND_FLAG
, T.CREATION_DATE CREATION_DATE
, T.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, NVL(TS.SCHEDULABLE_FLAG
, 'N') SCHEDULABLE_FLAG
, T.TASK_STATUS_ID TASK_STATUS_ID
, CSF_LOCUS_PUB.GET_LOCUS_SEGMENTID (LOC.GEOMETRY ) LOCUS_SEGMENTID
, CSF_LOCUS_PUB.GET_LOCUS_SIDE (LOC.GEOMETRY) LOCUS_SIDE
, CSF_LOCUS_PUB.GET_LOCUS_SPOT (LOC.GEOMETRY) LOCUS_SPOT
, CSF_LOCUS_PUB.SHOULD_CALL_LF (LOC.GEOMETRY) SHOULD_CALL_LF
, LOC.LOCATION_ID LOCATION_ID
, CSR_SCHEDULER_PVT.GET_TIMEZONE (T.ADDRESS_ID) TIMEZONE_ID
, TA.TASK_ASSIGNMENT_ID TA_TASK_ASSIGNMENT_ID
, TA.SCHED_TRAVEL_DISTANCE TA_SCHED_TRAVEL_DISTANCE
, CSF_UTIL_PVT.CONVERT_TO_MINUTES(TA.SCHED_TRAVEL_DURATION
, TA.SCHED_TRAVEL_DURATION_UOM) SCHED_TRAVEL_DURATION
, CSF_UTIL_PVT.GET_UOM_MINUTES SCHED_TRAVEL_DURATION_UOM
, TA.OBJECT_VERSION_NUMBER TA_OBJECT_VERSION_NUMBER
, TA.SCHEDULABLE_FLAG TA_SCHEDULABLE_FLAG
, TA.RESOURCE_ID TA_RESOURCE_ID
, TA.RESOURCE_TYPE_CODE TA_RESOURCE_TYPE_CODE
, TA.ASSIGNMENT_STATUS_ID TA_ASSIGNMENT_STATUS_ID
, NVL( TY.SCHEDULE_FLAG
, 'N') TY_SCHEDULE_FLAG
, CSF_LOCUS_PUB.GET_LOCUS_LAT (LOC.GEOMETRY) LOCUS_LAT
, CSF_LOCUS_PUB.GET_LOCUS_LON (LOC.GEOMETRY) LOCUS_LON
, (SELECT MAX(NVL(CRL.ARRIVAL_DATE
, CRL.CREATION_DATE))
FROM CSP_REQUIREMENT_HEADERS CRH
, CSP_REQUIREMENT_LINES CRL
WHERE CRH.REQUIREMENT_HEADER_ID = CRL.REQUIREMENT_HEADER_ID
AND CRH.TASK_ID = TA.TASK_ID
AND CRH.TASK_ASSIGNMENT_ID = TA.TASK_ASSIGNMENT_ID ) AVAILABILITY_DATE
, TA.OBJECT_CAPACITY_ID OBJECT_CAPACITY_ID
, T.PARENT_TASK_ID PARENT_TASK_ID
, T.TASK_CONFIRMATION_STATUS TASK_CONFIRMATION_STATUS
, T.TASK_CONFIRMATION_COUNTER TASK_CONFIRMATION_COUNTER
, AH.ACCESSHOUR_REQUIRED ACCESS_HOURS_REQUIRED
, AH.AFTER_HOURS_FLAG AFTER_HOURS_FLAG
, AH.MONDAY_FIRST_START MONDAY_FIRST_START
, AH.MONDAY_FIRST_END MONDAY_FIRST_END
, AH.MONDAY_SECOND_START MONDAY_SECOND_START
, AH.MONDAY_SECOND_END MONDAY_SECOND_END
, AH.TUESDAY_FIRST_START TUESDAY_FIRST_START
, AH.TUESDAY_FIRST_END TUESDAY_FIRST_END
, AH.TUESDAY_SECOND_START TUESDAY_SECOND_START
, AH.TUESDAY_SECOND_END TUESDAY_SECOND_END
, AH.WEDNESDAY_FIRST_START WEDNESDAY_FIRST_START
, AH.WEDNESDAY_FIRST_END WEDNESDAY_FIRST_END
, AH.WEDNESDAY_SECOND_START WEDNESDAY_SECOND_STAR
, AH.WEDNESDAY_SECOND_END WEDNESDAY_SECOND_END
, AH.THURSDAY_FIRST_START THURSDAY_FIRST_START
, AH.THURSDAY_FIRST_END THURSDAY_FIRST_END
, AH.THURSDAY_SECOND_START THURSDAY_SECOND_START
, AH.THURSDAY_SECOND_END THURSDAY_SECOND_END
, AH.FRIDAY_FIRST_START FRIDAY_FIRST_START
, AH.FRIDAY_FIRST_END FRIDAY_FIRST_END
, AH.FRIDAY_SECOND_START FRIDAY_SECOND_START
, AH.FRIDAY_SECOND_END FRIDAY_SECOND_END
, AH.SATURDAY_FIRST_START SATURDAY_FIRST_START
, AH.SATURDAY_FIRST_END SATURDAY_FIRST_END
, AH.SATURDAY_SECOND_START SATURDAY_SECOND_START
, AH.SATURDAY_SECOND_END SATURDAY_SECOND_END
, AH.SUNDAY_FIRST_START SUNDAY_FIRST_START
, AH.SUNDAY_FIRST_END SUNDAY_FIRST_END
, AH.SUNDAY_SECOND_START SUNDAY_SECOND_START
, AH.SUNDAY_SECOND_END SUNDAY_SECOND_END
, T.TASK_SPLIT_FLAG
, NVL(TS.ASSIGNED_FLAG
, 'N') TS_ASSIGNED_FLAG
, NVL(TS.WORKING_FLAG
, 'N') TS_WORKING_FLAG
, NVL(TS.APPROVED_FLAG
, 'N') TS_APPROVED_FLAG
, NVL(TS.COMPLETED_FLAG
, 'N') TS_COMPLETED_FLAG
, NVL(TS.CANCELLED_FLAG
, 'N') TS_CANCELLED_FLAG
, NVL(TS.CLOSED_FLAG
, 'N') TS_CLOSED_FLAG
, NVL(TS.REJECTED_FLAG
, 'N') TS_REJECTED_FLAG
, NVL(TS.ACCEPTED_FLAG
, 'N') TS_ACCEPTED_FLAG
, NVL(TS.ON_HOLD_FLAG
, 'N') TS_ON_HOLD_FLAG
, NVL(TS.DELETE_ALLOWED_FLAG
, 'N') TS_DELETE_ALLOWED_FLAG
, T.TASK_NUMBER TASK_NUMBER
FROM JTF_TASKS_B T
, JTF_TASK_STATUSES_B TS
, (SELECT A.TASK_ASSIGNMENT_ID TASK_ASSIGNMENT_ID
, A.TASK_ID TASK_ID
, A.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, A.SHIFT_CONSTRUCT_ID SHIFT_CONSTRUCT_ID
, A.OBJECT_CAPACITY_ID OBJECT_CAPACITY_ID
, A.ACTUAL_START_DATE ACTUAL_START_DATE
, A.ACTUAL_END_DATE ACTUAL_END_DATE
, A.SCHED_TRAVEL_DISTANCE SCHED_TRAVEL_DISTANCE
, A.SCHED_TRAVEL_DURATION SCHED_TRAVEL_DURATION
, A.SCHED_TRAVEL_DURATION_UOM SCHED_TRAVEL_DURATION_UOM
, A.RESOURCE_ID RESOURCE_ID
, A.RESOURCE_TYPE_CODE RESOURCE_TYPE_CODE
, S.TASK_STATUS_ID ASSIGNMENT_STATUS_ID
, NVL(S.SCHEDULABLE_FLAG
, 'N') SCHEDULABLE_FLAG
FROM JTF_TASK_ASSIGNMENTS A
, JTF_TASK_STATUSES_B S
WHERE A.ASSIGNMENT_STATUS_ID = S.TASK_STATUS_ID
AND S.USAGE = 'TASK'
AND (S.CLOSED_FLAG = 'N' OR S.CLOSED_FLAG IS NULL)
AND (S.COMPLETED_FLAG = 'N' OR S.COMPLETED_FLAG IS NULL)
AND (S.CANCELLED_FLAG = 'N' OR S.CANCELLED_FLAG IS NULL)
AND A.OBJECT_CAPACITY_ID IS NOT NULL
AND A.ASSIGNEE_ROLE = 'ASSIGNEE' ) TA
, JTF_TASK_TYPES_B TY
, HZ_PARTY_SITES PAR
, HZ_LOCATIONS LOC
, CSF_ACCESS_HOURS_B AH
WHERE T.TASK_STATUS_ID = TS.TASK_STATUS_ID
AND T.TASK_ID = TA.TASK_ID (+)
AND T.TASK_TYPE_ID = TY.TASK_TYPE_ID
AND T.ADDRESS_ID = PAR.PARTY_SITE_ID (+)
AND PAR.LOCATION_ID = LOC.LOCATION_ID (+)
AND T.TASK_ID = AH.TASK_ID (+)
AND TS.USAGE = 'TASK'

Columns