The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT delv.INVENTORY_ITEM_ID
FROM ams_deliverables_all_b delv
WHERE delv.deliverable_id = p_collateral_id
UNION
SELECT delv.INVENTORY_ITEM_ID
FROM ams_deliverables_all_b delv,
mtl_system_items_b msi
WHERE delv.deliverable_id in (select deliverable_kit_part_id
FROM ams_deliv_kit_items
WHERE deliverable_kit_id = p_collateral_id)
AND delv.inventory_item_id is not null
AND nvl(delv.kit_flag,'N')='N'
AND delv.status_code='AVAILABLE'
AND delv.active_flag = 'Y'
AND delv.can_fulfill_physical_flag = 'Y'
AND delv.actual_avail_to_date > sysdate
AND msi.inventory_item_id = delv.inventory_item_id
AND msi.organization_id = p_order_header_rec.inv_organization_id
and msi.customer_order_flag = 'Y'
and msi.shippable_item_flag = 'Y';
SELECT msi.primary_uom_code
FROM mtl_system_items_b msi
WHERE msi.inventory_item_id = p_item_id
AND msi.organization_id = p_order_header_rec.inv_organization_id;