[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT NULL
FROM jtf_tasks_b t, jtf_task_references_vl r, jtf_ec_statuses_vl s
WHERE t.task_id = r.task_id
AND t.task_type_id = 22
AND t.task_status_id = s.task_status_id
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 r.reference_code = 'ESC'
AND r.object_type_code = l_object_type_code
AND r.object_id = l_object_id;
SELECT t.source_object_type_code,
t.source_object_id
FROM jtf_tasks_b t, jtf_task_statuses_vl s
WHERE t.task_id = p_task_id
AND t.task_status_id = s.task_status_id
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);
SELECT task_assignment_id,
scheduled_end_date
FROM jtf_tasks_b jtb,
jtf_task_assignments jta,
cac_sr_object_capacity cso
WHERE jta.resource_id = p_res_id
AND jta.resource_type_code = p_res_type
AND jta.object_capacity_id = cso.object_capacity_id
AND jta.task_id = jtb.task_id
AND cso.start_date_time = p_shift_start
AND cso.end_date_time = p_shift_end
AND ( jtb.task_type_id = 20 -- departure task
OR ( jtb.task_type_id NOT IN (20, 21) -- real tasks
AND ( jtb.scheduled_start_date < p_sched_start
OR ( jtb.scheduled_start_date = p_sched_start
AND jta.task_assignment_id < p_ta_id
)
)
)
)
ORDER BY DECODE (jtb.task_type_id, 20, 1, 0) -- departure task last
,
jtb.scheduled_start_date DESC,
jta.task_assignment_id DESC;
SELECT jta.task_assignment_id,
jtb.scheduled_end_date
FROM jtf_tasks_b jtb,
jtf_task_assignments jta,
cac_sr_object_capacity cso
WHERE jta.resource_id = p_res_id
AND jta.resource_type_code = p_res_type
AND jta.object_capacity_id = cso.object_capacity_id
AND jta.task_id = jtb.task_id
AND cso.start_date_time = p_shift_start
AND cso.end_date_time = p_shift_end
AND jtb.task_type_id <> 21 -- not arrival task
ORDER BY DECODE (jtb.task_type_id, 20, 1, 0) -- departure task last
,
jtb.scheduled_start_date DESC,
jta.task_assignment_id DESC;
SELECT jtb.scheduled_start_date,
jtb.scheduled_end_date,
jtb.actual_start_date,
jtb.actual_end_date,
jta.sched_travel_duration,
jta.resource_id,
jta.resource_type_code,
cso.start_date_time,
cso.end_date_time,
jtb.bound_mode_code,
jtb.planned_start_date,
jtb.planned_end_date,
jtb.task_type_id
FROM jtf_tasks_b jtb,
jtf_task_assignments jta,
cac_sr_object_capacity cso
WHERE jta.object_capacity_id = cso.object_capacity_id
AND jta.task_id = jtb.task_id
AND jta.task_assignment_id = p_ta_id;
SELECT task_id
FROM jtf_task_assignments jta
WHERE jta.resource_id = p_res_id
AND jta.resource_type_code = p_res_type
AND TRUNC (p_date) BETWEEN TRUNC (jta.booking_start_date)
AND TRUNC (jta.booking_end_date);
SELECT --task_id,
-- start_date_time shift_start,
MAX (NVL (jta.actual_start_date,
jta.booking_start_date
+ predict_time_difference (jta.task_assignment_id)
)
) predicted_start_date,
MAX (end_date_time) shift_end
-- NVL (jta.actual_end_date, jtb.scheduled_end_date + predict_time_difference (jta.task_assignment_id)) predicted_end_date
FROM jtf_task_assignments jta, cac_sr_object_capacity cso
WHERE jta.resource_id = p_res_id
AND jta.resource_type_code = p_res_type
AND TRUNC (p_date) BETWEEN TRUNC (jta.booking_start_date)
AND TRUNC (jta.booking_end_date)
AND cso.object_capacity_id = jta.object_capacity_id;