The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT concatenated_segments
,concatenated_segments
,description
INTO x_ordered_item
,x_inventory_item
,x_ordered_item_desc
FROM mtl_system_items_vl
WHERE inventory_item_id = p_inventory_item_id
AND organization_id = l_organization_id;
SELECT citems.customer_item_number
,sitems.concatenated_segments
,nvl(citems.customer_item_desc, sitems.description)
INTO x_ordered_item
,x_inventory_item
,x_ordered_item_desc
FROM mtl_customer_items citems
,mtl_customer_item_xrefs cxref
,mtl_system_items_vl sitems
WHERE citems.customer_item_id = cxref.customer_item_id
AND cxref.inventory_item_id = sitems.inventory_item_id
AND sitems.inventory_item_id = p_inventory_item_id
AND sitems.organization_id = l_organization_id
AND citems.customer_item_id = p_ordered_item_id
AND citems.customer_id = p_sold_to_org_id;
SELECT category_concat_segs
,category_concat_segs
,description
INTO x_ordered_item
,x_inventory_item
,x_ordered_item_desc
FROM mtl_categories_v
WHERE CATEGORY_ID = p_inventory_item_id;
SELECT items.cross_reference
,sitems.concatenated_segments
,nvl(items.description, sitems.description)
INTO x_ordered_item
,x_inventory_item
,x_ordered_item_desc
FROM mtl_cross_reference_types types
, mtl_cross_references items
, mtl_system_items_vl sitems
WHERE types.cross_reference_type = items.cross_reference_type
AND items.inventory_item_id = sitems.inventory_item_id
AND sitems.organization_id = l_organization_id
AND sitems.inventory_item_id = p_inventory_item_id
AND items.cross_reference_type = p_item_identifier_type
AND items.cross_reference = p_ordered_item;