The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT source_object_id
, source_object_line_id
, credit_to
, SUM(quantity) qty
, AVG(rate) rate
, SUM(NVL(claim_currency_amount,0)) amount
FROM ozf_claim_lines
WHERE claim_id = cv_claim_id
GROUP BY source_object_id, source_object_line_id, credit_to;
SELECT COUNT(rec.cash_receipt_id)
FROM ar_receivable_applications rec
WHERE rec.applied_customer_trx_id = cv_invoice_id
AND rec.cash_receipt_id = cv_receipt_id
AND rec.display = 'Y';
SELECT payment_schedule_id
, trx_number
, amount_line_items_remaining
, tax_remaining
, freight_remaining
FROM ar_payment_schedules
WHERE customer_trx_id = cv_customer_trx_id;
SELECT source_object_id, SUM(NVL(claim_currency_amount,0))
FROM ozf_claim_lines
WHERE claim_id = cv_claim_id
AND ( cv_invoice_id IS NULL OR source_object_id = cv_invoice_id )
GROUP BY source_object_id;
SELECT source_object_id, SUM(NVL(claim_currency_amount,0))
FROM ozf_claim_lines
WHERE claim_id = cv_claim_id
AND ( cv_invoice_id IS NULL OR source_object_id = cv_invoice_id )
GROUP BY source_object_id;
SELECT source_object_id
, credit_to
, SUM(NVL(claim_currency_amount,0))
FROM ozf_claim_lines
WHERE claim_id = cv_claim_id
AND source_object_class IN ('INVOICE', 'DM', 'CB')
AND ( cv_invoice_id IS NULL OR source_object_id = cv_invoice_id )
GROUP BY source_object_id, credit_to;
SELECT source_object_id
, source_object_line_id
, SUM(NVL(claim_currency_amount,0))
FROM ozf_claim_lines
WHERE claim_id = cv_claim_id
AND ( cv_invoice_id IS NULL OR source_object_id = cv_invoice_id )
GROUP BY source_object_id,source_object_line_id;
SELECT extended_amount
FROM ra_customer_trx_lines
WHERE customer_trx_line_id = cv_invoice_line_id;
SELECT trx_number from ar_payment_schedules_all
WHERE customer_trx_id = cv_customer_trx_id;
SELECT NVL(SUM(claim_currency_amount), 0)
FROM ozf_claim_lines
WHERE claim_id = cv_claim_id;
SELECT batch_source_id
, post_to_gl
, gl_rec_clearing_account
, cm_trx_type_id
, billback_trx_type_id
, cb_trx_type_id
, adj_rec_trx_id
, wo_rec_trx_id
, neg_wo_rec_trx_id
FROM ozf_sys_parameters
WHERE set_of_books_id = cv_set_of_books_id;
SELECT billback_trx_type_id, cm_trx_type_id
FROM ozf_sys_parameters
WHERE set_of_books_id = cv_set_of_books_id;
SELECT type, creation_sign
FROM ra_cust_trx_types
WHERE cust_trx_type_id = cv_trx_type_id;
SELECT reason_code
, adjustment_reason_code
, name
FROM ozf_reason_codes_vl
WHERE reason_code_id = cv_reason_code_id;
SELECT cm_trx_type_id
, dm_trx_type_id
, cb_trx_type_id
, wo_rec_trx_id
, neg_wo_rec_trx_id
, adj_rec_trx_id
FROM ozf_claim_types_vl
WHERE claim_type_id = cv_claim_type_id;
SELECT SUM(amount_due_remaining),
invoice_currency_code
FROM ar_payment_schedules
WHERE customer_trx_id = cv_customer_trx_id
GROUP BY invoice_currency_code;
SELECT item_id
, quantity_uom
--, org_id
, FND_PROFILE.value('AMS_ITEM_ORGANIZATION_ID')
FROM ozf_claim_lines
WHERE item_type = 'PRODUCT'
AND claim_id = cv_claim_id;
SELECT primary_uom_code
FROM mtl_system_items
WHERE inventory_item_id = cv_item_id
AND organization_id = cv_org_id;
SELECT uom_class
FROM mtl_units_of_measure
WHERE uom_code = cv_uom_code;
SELECT salesrep_required_flag
FROM ar_system_parameters;
SELECT source_object_id, source_object_class, SUM(NVL(claim_currency_amount,0))
FROM ozf_claim_lines
WHERE claim_id = cv_claim_id
GROUP BY source_object_id, source_object_class;