The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT l.location_id
, l.geometry
, l.house_number
, l.address1
, l.address2
, l.address3
, l.address4
, l.city
, l.state
, l.postal_code
, fnd.territory_short_name country
, l.country country_code
, l.geometry_status_code
FROM jtf_tasks_b t
, hz_locations l
, fnd_territories_vl fnd
WHERE t.task_id = p_task_id
AND l.location_id = csf_tasks_pub.get_task_location_id(t.task_id, t.address_id, t.location_id)
AND fnd.territory_code = l.country;
SELECT MIN(timezone_id)
INTO l_timezone_id
FROM hz_timezones
WHERE gmt_deviation_hours = -8
AND daylight_savings_time_flag = 'Y';
SELECT loc.timezone_id
FROM hz_party_sites par
, hz_locations loc
WHERE par.party_site_id = p_address_id
AND par.location_id = loc.location_id;
SELECT planned_start_date, planned_end_date, source_object_id
FROM jtf_tasks_b
WHERE task_id = p_task_id;
SELECT t.task_id, t.planned_start_date, t.planned_end_date, t.source_object_id
FROM jtf_tasks_b t
WHERE t.task_id = p_task_id;
SELECT rt.request_task_id
, t.task_number
, t.task_id
, t.source_object_id
, t.planned_start_date
, t.planned_end_date
FROM ( SELECT sched_request_id
FROM csf_r_sched_requests
WHERE parent_request_id = p_request_id
UNION ALL
SELECT sched_request_id
FROM csf_r_sched_requests
WHERE sched_request_id = p_request_id
AND NOT EXISTS (SELECT 1
FROM csf_r_sched_requests
WHERE parent_request_id = p_request_id)
) r
, csf_r_request_tasks rt
, jtf_tasks_b t
WHERE rt.sched_request_id = r.sched_request_id
AND NOT EXISTS ( SELECT 1
FROM csf_r_resource_results rr
WHERE rr.request_task_id = rt.request_task_id
)
AND t.task_id = rt.task_id;
l_res_tbl.DELETE(iIndex) ;
l_stmt := 'SELECT task_id FROM csf_ct_tasks WHERE ' || l_where || ' ORDER BY scheduled_start_date NULLS FIRST, planned_end_date, creation_date';
SELECT resource_id, resource_type, terr_id FROM
(SELECT /*+ cardinality(t, 1) */ DISTINCT trs.resource_id, trs.resource_type, trs.terr_id
, RANK () OVER (PARTITION BY trs.resource_id, trs.resource_type ORDER BY NVL
(tra.absolute_rank,
0
) DESC NULLS LAST)
AS comp_rank
FROM jtf_terr_rsc_all trs, jtf_terr_all tra
, TABLE( CAST ( csf_util_pvt.get_selected_terr_table AS jtf_number_table ) ) t
WHERE trs.terr_id = t.column_value
AND (p_terr_id IS NULL OR trs.terr_id = p_terr_id))
WHERE comp_rank = 1;
SELECT source_object_id
FROM jtf_tasks_b t
, TABLE( CAST ( p_task_id_tbl AS jtf_number_table ) ) tt
WHERE t.task_id = tt.COLUMN_VALUE;
l_task_res_tbl.DELETE;
SELECT 'Y'
FROM csp_req_line_details crld
, csp_requirement_lines crl
, csp_requirement_headers crh
WHERE crh.task_assignment_id = p_task_assignment_id
AND crl.requirement_header_id = crh.requirement_header_id
AND crld.requirement_line_id = crl.requirement_line_id
AND crld.source_type = 'RES' ;
SELECT 'Y'
FROM csp_req_line_details crld
, csp_requirement_lines crl
, csp_requirement_headers crh
, oe_order_lines_all oel
, oe_order_headers_all oeh
WHERE crh.task_assignment_id = p_task_assignment_id
AND crl.requirement_header_id = crh.requirement_header_id
AND crld.requirement_line_id = crl.requirement_line_id
AND crld.source_type = 'IO'
AND oel.line_id = crld.source_id
AND oeh.header_id = oel.header_id
AND oeh.flow_status_code <>'CANCELLED'
ORDER BY oeh.header_id;
SELECT t.task_id
, ta.task_assignment_id
, ah.access_hour_id
, oc.object_capacity_id
FROM jtf_tasks_b t
, jtf_task_assignments ta
, jtf_task_statuses_b ts
, csf_access_hours_b ah
, cac_sr_object_capacity oc
, TABLE ( CAST ( p_resource_tbl AS CSF_RESOURCE_TBL ) ) r
WHERE t.task_id = ta.task_id
AND ta.assignment_status_id = ts.task_status_id
AND t.task_id = ah.task_id(+)
AND ta.resource_id = oc.object_id
AND ta.resource_type_code = oc.object_type
AND (
( ta.object_capacity_id IS NOT NULL
AND ta.object_capacity_id = oc.object_capacity_id
)
OR (
ta.object_capacity_id IS NULL
AND ta.booking_start_date < oc.end_date_time
AND ta.booking_end_date > oc.start_date_time
)
)
AND t.scheduled_end_date >= t.scheduled_start_date
AND (t.deleted_flag = 'N' OR t.deleted_flag IS NULL)
AND (
NVL(ta.actual_start_date, ta.actual_end_date) IS NOT NULL
OR ((ts.cancelled_flag = 'N' OR ts.cancelled_flag IS NULL))
)
AND oc.object_id = r.resource_id
AND oc.object_type = r.resource_type
AND oc.start_date_time <= r.planwin_end
AND oc.end_date_time >= r.planwin_start
FOR UPDATE OF t.task_id, ta.task_assignment_id, ah.access_hour_id, oc.object_capacity_id NOWAIT;
SELECT jrb.role_code
, jrr.role_resource_type
FROM jtf_rs_role_relations jrr
, jtf_rs_roles_b jrb
WHERE jrr.role_id = jrb.role_id
AND jrr.role_resource_id = p_resource_id
AND jrb.role_type_code = 'CSF_THIRD_PARTY'
AND jrr.role_resource_type = p_resource_type
AND ( jrr.start_date_active IS NULL or trunc(jrr.start_date_active) <= sysdate )
AND ( jrr.end_date_active IS NULL or trunc(jrr.end_date_active) >= sysdate )
AND NVL( jrr.delete_flag, 'N') = 'N'
ORDER BY 1;