The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT a.*
FROM okl_cnsld_ar_hdrs_v a
WHERE EXISTS (SELECT 1 FROM
(SELECT x.id
FROM okl_cnsld_ar_hdrs_v x,
okl_cnsld_ar_lines_v y,
okl_cnsld_ar_strms_v z
WHERE x.trx_status_code like 'PROCESSED%' AND
x.id = y.cnr_id AND
y.id = z.lln_id AND
z.receivables_invoice_id IS NOT NULL) b
WHERE b.id = a.id
-- nikshah bug 6747706 added org check
AND NVL(a.ORG_ID, MO_GLOBAL.GET_CURRENT_ORG_ID) = MO_GLOBAL.GET_CURRENT_ORG_ID)
-- nikshah bug 6747706 end
ORDER BY to_number(a.consolidated_invoice_number);
SELECT sequence_number,
nvl(amount, 0) + nvl(tax_amount, 0) amount,
ilt_id,
khr_id,
kle_id
FROM okl_cnsld_ar_lines_v
WHERE cnr_id = p_cnr_id;
SELECT name
FROM okl_invc_line_types_v
WHERE id = p_ilt_id;
SELECT contract_number
FROM okc_k_headers_b
WHERE id = p_khr_id;
SELECT name, description
FROM okx_asset_lines_v
WHERE parent_line_id = p_kle_id;
SELECT party_name,
party_id
FROM hz_parties
where party_id = p_party_id;
Select name
from fnd_currencies_vl
WHERE currency_code = p_code;
SELECT
CA.account_number,
PY.PARTY_NAME,
PY.ADDRESS1,
PY.ADDRESS2,
PY.ADDRESS3,
PY.ADDRESS4,
PY.CITY,
PY.STATE,
PY.POSTAL_CODE,
PY.COUNTRY
FROM HZ_CUST_ACCOUNTS CA,
HZ_PARTIES PY
WHERE CA.CUST_ACCOUNT_ID = p_id AND
PY.PARTY_ID = CA.PARTY_ID;