The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT mtlb.inventory_item_id,
mtlk.concatenated_segments,
substrb(mtlt.description,1,120),
mtlb.last_update_date,
mtlb.organization_id
FROM wsh_delivery_assignments wda,
wsh_delivery_details wdd,
mtl_system_items_b mtlb,
mtl_system_items_tl mtlt,
mtl_system_items_kfv mtlk
WHERE wda.delivery_id = p_delivery_id
AND wda.delivery_detail_id = wdd.delivery_detail_id
AND wdd.inventory_item_id = mtlb.inventory_item_id
AND wdd.inventory_item_id = mtlt.inventory_item_id
AND wdd.inventory_item_id = mtlk.inventory_item_id
AND wdd.organization_id = mtlb.organization_id
AND wdd.organization_id = mtlk.organization_id
AND wdd.organization_id = mtlt.organization_id
AND mtlb.shippable_item_flag = 'Y'
AND mtlk.shippable_item_flag = 'Y'
AND mtlt.language = userenv('LANG');
SELECT mtlb.inventory_item_id,
mtlk.concatenated_segments,
substrb(mtlt.description,1,120),
mtlb.last_update_date,
mtlb.organization_id
FROM wsh_delivery_assignments wda,
wsh_delivery_details wdd,
wsh_delivery_legs wdl,
wsh_trip_stops wts,
mtl_system_items_b mtlb,
mtl_system_items_tl mtlt,
mtl_system_items_kfv mtlk
WHERE wts.trip_id = p_trip_id
AND wts.stop_id = wdl.pick_up_stop_id
AND wda.delivery_id = wdl.delivery_id
AND wda.delivery_detail_id = wdd.delivery_detail_id
AND wdd.inventory_item_id = mtlb.inventory_item_id
AND wdd.inventory_item_id = mtlt.inventory_item_id
AND wdd.inventory_item_id = mtlk.inventory_item_id
AND wdd.organization_id = mtlb.organization_id
AND wdd.organization_id = mtlk.organization_id
AND wdd.organization_id = mtlt.organization_id
AND mtlb.shippable_item_flag = 'Y'
AND mtlk.shippable_item_flag = 'Y'
AND mtlt.language = userenv('LANG');
SELECT wsh_otm_sync_ref_data_log_s.NEXTVAL
FROM dual;
l_last_update_date DATE;
l_last_update_date := l_tbl_item(l_loop_index).last_update_date;
P_ENTITY_UPDATED_DATE => l_last_update_date,
X_SUBSTITUTE_ENTITY => l_substitute_entity,
P_TRANSMISSION_ID => l_transmission_id ,
X_SEND_ALLOWED => l_send_allowed,
X_RETURN_STATUS => l_return_status
);
l_tbl_item.DELETE;