APPS.CSF_TASK_ASSIGNMENTS_PUB dependencies on JTF_TASKS_B

Line 65: FROM jtf_tasks_b t

61: , csf_util_pvt.convert_to_minutes(ta.sched_travel_duration, ta.sched_travel_duration_uom) sched_travel_duration
62: , csf_util_pvt.convert_to_minutes(ta.actual_travel_duration, ta.actual_travel_duration_uom) actual_travel_duration
63: , cac.object_capacity_id old_trip_id
64: , cac.object_version_number old_trip_ovn
65: FROM jtf_tasks_b t
66: , jtf_task_assignments ta
67: , jtf_task_statuses_b ts
68: , cac_sr_object_capacity cac
69: WHERE t.task_id = p_task_id

Line 302: , (SELECT pt.object_version_number FROM jtf_tasks_b pt WHERE pt.task_id = t.parent_task_id) parent_task_ovn

298: , t.scheduled_start_date
299: , t.scheduled_end_date
300: , t.task_split_flag
301: , t.parent_task_id
302: , (SELECT pt.object_version_number FROM jtf_tasks_b pt WHERE pt.task_id = t.parent_task_id) parent_task_ovn
303: , t.source_object_type_code
304: , ta.resource_id
305: , ta.resource_type_code
306: , cac.object_capacity_id trip_id

Line 322: FROM jtf_tasks_b t

318: AND ROWNUM = 1
319: )
320: , 'N'
321: ) other_ta_exists
322: FROM jtf_tasks_b t
323: , jtf_task_assignments ta
324: , cac_sr_object_capacity cac
325: WHERE ta.task_assignment_id = p_task_assignment_id
326: AND t.task_id = ta.task_id