The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT inventory_item_id,
transaction_quantity,
source_code,
transaction_action_id,
transaction_type_id,
transaction_source_type_id,
ship_to_location_id,
organization_id,
transaction_id,
parent_transaction_id
FROM mtl_material_transactions
WHERE transaction_id = p_transaction_id;
SELECT type_class,
transaction_source_type_id,
nvl(location_required_flag,'N') location_required_flag
FROM mtl_trx_types_view
WHERE transaction_type_id = pc_transaction_type_id;
SELECT entity_type
FROM wip_entities we,
mtl_material_transactions mmt
WHERE mmt.transaction_source_id=we.wip_entity_id
AND mmt.transaction_id= p_transaction_id;
SELECT organization_id
FROM mtl_material_transactions
WHERE transaction_id = pc_par_txn_id;
SELECT transaction_id
FROM mtl_material_transactions
WHERE transaction_id = pc_transaction_id
AND organization_id = pc_parent_org;
SELECT master_organization_id
INTO l_master_org_id
FROM mtl_parameters
WHERE organization_id = r_mtl_data.organization_id;
l_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
l_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;
l_trx_error_rec.error_stage := csi_inv_trxs_pkg.g_ib_update;