[Home] [Help]
359: FROM cac_sr_object_capacity oc
360: WHERE object_capacity_id = p_trip_id
361: AND EXISTS (SELECT 1
362: FROM jtf_task_assignments ta
363: , jtf_task_statuses_b ts
364: , jtf_tasks_b t
365: WHERE ta.object_capacity_id = oc.object_capacity_id
366: AND ts.task_status_id = ta.assignment_status_id
367: AND NVL(ts.closed_flag, 'N') = 'N'
710: ta.sched_travel_duration
711: , ta.sched_travel_duration_uom
712: ) travel_time
713: FROM jtf_task_assignments ta
714: , jtf_task_statuses_b ts
715: , jtf_tasks_b t
716: WHERE ta.resource_id = p_resource_id
717: AND ta.resource_type_code = p_resource_type
718: AND ta.assignee_role = 'ASSIGNEE'
950: , t.task_status_id
951: FROM cac_sr_object_capacity cac
952: , jtf_task_assignments ta
953: , jtf_tasks_b t
954: , jtf_task_statuses_b ts
955: WHERE cac.object_capacity_id = p_trip.trip_id
956: AND ta.resource_id = cac.object_id
957: AND ta.resource_type_code = cac.object_type
958: AND ( (ta.object_capacity_id IS NOT NULL AND ta.object_capacity_id = cac.object_capacity_id)
1302: , oc.object_capacity_id correct_trip_id
1303: FROM cac_sr_object_capacity oc
1304: , jtf_task_assignments ta
1305: , jtf_tasks_b t
1306: , jtf_task_statuses_b ts
1307: WHERE oc.object_capacity_id = p_trip.trip_id
1308: AND ta.resource_id = oc.object_id
1309: AND ta.resource_type_code = oc.object_type
1310: AND ta.assignee_role = 'ASSIGNEE'
1326: , oc.object_capacity_id correct_trip_id
1327: FROM cac_sr_object_capacity oc
1328: , jtf_task_assignments ta
1329: , jtf_tasks_b t
1330: , jtf_task_statuses_b ts
1331: WHERE ta.object_capacity_id = p_trip.trip_id
1332: AND oc.object_id = ta.resource_id
1333: AND oc.object_type = ta.resource_type_code
1334: AND oc.object_capacity_id <> ta.object_capacity_id
1358: ta.sched_travel_duration
1359: , ta.sched_travel_duration_uom
1360: ), 0)) travel_time
1361: FROM jtf_task_assignments ta
1362: , jtf_task_statuses_b ts
1363: WHERE ta.object_capacity_id = p_trip.trip_id
1364: AND ts.task_status_id = ta.assignment_status_id
1365: AND NVL(ts.closed_flag, 'N') = 'N'
1366: AND NVL(ts.completed_flag, 'N') = 'N'
1746: , ta.sched_travel_duration_uom
1747: ) travel_time
1748: FROM TABLE ( CAST(l_del_trip_tbl AS jtf_number_table) ) oc
1749: , jtf_task_assignments ta
1750: , jtf_task_statuses_b ts
1751: , jtf_tasks_b t
1752: WHERE ta.object_capacity_id = oc.COLUMN_VALUE
1753: AND ts.task_status_id = ta.assignment_status_id
1754: AND NVL(ts.closed_flag, 'N') = 'N'
1764: CURSOR c_linkable_tasks(l_trip number) IS
1765: SELECT tb.task_id
1766: FROM jtf_task_assignments jta,
1767: jtf_tasks_b tb,
1768: jtf_task_statuses_b jts
1769: WHERE jta.object_capacity_id=l_trip
1770: AND jta.task_id=tb.task_id
1771: AND jts.task_status_id = tb.task_status_id
1772: AND NVL(jts.closed_flag, 'N') = 'N'
4083: ta.sched_travel_duration
4084: , ta.sched_travel_duration_uom
4085: ) travel_time
4086: FROM jtf_task_assignments ta
4087: , jtf_task_statuses_b ts
4088: , jtf_tasks_b t
4089: WHERE ta.resource_id = p_resource_id
4090: AND ta.resource_type_code = p_resource_type
4091: AND ta.assignee_role = 'ASSIGNEE'
5003: (SELECT co.object_capacity_id
5004: FROM cac_sr_object_capacity co,
5005: jtf_tasks_b jtb,
5006: jtf_task_assignments jta,
5007: jtf_task_statuses_b jts,
5008: jtf_Task_statuses_b jtsa
5009: WHERE jtb.task_id =jta.task_id
5010: AND jta.assignment_status_id =jts.task_status_id
5011: AND NVL(jts.cancelled_flag,'N') <> 'Y'
5004: FROM cac_sr_object_capacity co,
5005: jtf_tasks_b jtb,
5006: jtf_task_assignments jta,
5007: jtf_task_statuses_b jts,
5008: jtf_Task_statuses_b jtsa
5009: WHERE jtb.task_id =jta.task_id
5010: AND jta.assignment_status_id =jts.task_status_id
5011: AND NVL(jts.cancelled_flag,'N') <> 'Y'
5012: AND jtb.task_status_id =jtsa.task_status_id
5188: ta.sched_travel_duration
5189: , ta.sched_travel_duration_uom
5190: ) travel_time
5191: FROM jtf_task_assignments ta
5192: , jtf_task_statuses_b ts
5193: , jtf_tasks_b t
5194: WHERE ta.resource_id = p_resource_id
5195: AND ta.resource_type_code = p_resource_type
5196: AND ta.assignee_role = 'ASSIGNEE'