APPS.CSF_TRIPS_PUB dependencies on JTF_TASKS_VL

Line 1051: , jtf_tasks_vl t

1047: , t.object_version_number
1048: , t.task_name
1049: , t.task_number
1050: FROM jtf_task_assignments ta
1051: , jtf_tasks_vl t
1052: WHERE ta.object_capacity_id = p_trip.trip_id
1053: AND t.task_id = ta.task_id
1054: AND NVL(t.deleted_flag, 'N') = 'N'
1055: AND t.task_type_id IN (g_dep_task_type_id, g_arr_task_type_id);

Line 1267: , jtf_tasks_vl t

1263: , t.task_number
1264: , LAG(t.task_id) OVER (PARTITION BY t.task_type_id
1265: ORDER BY t.scheduled_start_date) duplicate
1266: FROM jtf_task_assignments ta
1267: , jtf_tasks_vl t
1268: WHERE ta.object_capacity_id = p_trip.trip_id
1269: AND t.task_id = ta.task_id
1270: AND NVL(t.deleted_flag, 'N') = 'N'
1271: AND t.task_type_id IN (20, 21);