APPS.CSF_TRIPS_PUB dependencies on JTF_TASKS_VL

Line 1155: , jtf_tasks_vl t

1151: , t.object_version_number
1152: , t.task_name
1153: , t.task_number
1154: FROM jtf_task_assignments ta
1155: , jtf_tasks_vl t
1156: WHERE ta.object_capacity_id = p_trip.trip_id
1157: AND t.task_id = ta.task_id
1158: AND NVL(t.deleted_flag, 'N') = 'N'
1159: AND t.task_type_id IN (g_dep_task_type_id, g_arr_task_type_id);

Line 1378: , jtf_tasks_vl t

1374: , t.task_number
1375: , LAG(t.task_id) OVER (PARTITION BY t.task_type_id
1376: ORDER BY t.scheduled_start_date) duplicate
1377: FROM jtf_task_assignments ta
1378: , jtf_tasks_vl t
1379: WHERE ta.object_capacity_id = p_trip.trip_id
1380: AND t.task_id = ta.task_id
1381: AND NVL(t.deleted_flag, 'N') = 'N'
1382: AND t.task_type_id IN (20, 21);

Line 5112: , jtf_tasks_vl t

5108: , t.task_number
5109: , LAG(t.task_id) OVER (PARTITION BY t.task_type_id,resource_id,resource_type_code,scheduled_start_date
5110: ORDER BY t.scheduled_start_date) duplicate
5111: FROM jtf_task_assignments ta
5112: , jtf_tasks_vl t
5113: WHERE t.task_id = ta.task_id
5114: AND NVL(t.deleted_flag, 'N') = 'N'
5115: AND t.task_type_id IN (20, 21)
5116: AND resource_id =p_res_id