[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select CHRB.CURRENCY_CODE,
KHR.CURRENCY_CONVERSION_TYPE,
KHR.CURRENCY_CONVERSION_RATE,
KHR.CURRENCY_CONVERSION_DATE
from OKC_K_HEADERS_B CHRB,OKL_K_HEADERS KHR
WHERE KHR.ID = CHRB.ID
AND CHRB.ID = l_khr_id;
SELECT id
FROM OKL_TRX_TYPES_TL
WHERE name = 'Billing'
AND language = 'US';
SELECT scs_code
FROM OKL_K_HEADERS_FULL_V
WHERE id = p_khr_id;
SELECT ID
FROM OKL_STRM_TYPE_TL
WHERE name = 'INTERIM INTEREST' ; */
SELECT ct.object1_id1 id
from okc_contacts ct,
okc_contact_sources csrc,
okc_k_party_roles_b pty,
okc_k_headers_b chr
where ct.cpl_id = pty.id
and ct.cro_code = csrc.cro_code
and ct.jtot_object1_code = csrc.jtot_object_code
and ct.dnz_chr_id = chr.id
and pty.rle_code = csrc.rle_code
and csrc.cro_code = 'SALESPERSON'
and csrc.rle_code = 'LESSOR'
and csrc.buy_or_sell = chr.buy_or_sell
and pty.dnz_chr_id = chr.id
and pty.chr_id = chr.id
and chr.id = v_khr_id;
SELECT cust_trx_type_id
FROM ra_cust_trx_types
WHERE name = 'Invoice-OKL';
SELECT object1_id1 cust_acct_site_id
FROM okc_rules_b rul
WHERE rul.rule_information_category = 'BTO'
and exists (select '1'
from okc_rule_groups_b rgp
where rgp.id = rul.rgp_id
and rgp.rgd_code = 'LABILL'
and rgp.chr_id = rul.dnz_chr_id
and rgp.chr_id = v_khr_id );
SELECT contract_number
FROM okc_k_headers_b
WHERE id = p_ctr_id;
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRITUB.pls call OKL_CONTRACT_PUB.update_contract_header ');
OKL_CONTRACT_PUB.update_contract_header(p_api_version => 1.0,
p_init_msg_list => l_init_msg_list,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_restricted_update => OKL_API.G_TRUE,
p_chrv_rec => l_chrv_rec_in,
p_khrv_rec => l_khrv_rec_in,
p_edit_mode => 'N',
x_chrv_rec => l_chrv_rec_out,
x_khrv_rec => l_khrv_rec_out);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRITUB.pls call OKL_CONTRACT_PUB.update_contract_header ');
SELECT idx.name
FROM OKC_RULES_B rule, OKL_INDICES idx, OKC_RULE_GROUPS_B rgp
WHERE rule.rule_information_category = 'LAIVAR'
AND rule.dnz_chr_id = p_chr_id
AND rule.rule_information2 = idx.id
AND rule.rgp_id = rgp.id
AND rgp.rgd_code = 'LAPREF'
AND rgp.chr_id = p_chr_id;
SELECT ac.check_date change_date
FROM OKL_TRX_AP_INVOICES_B oklinv,
okl_txl_ap_inv_lns_all_b tpl,
okl_cnsld_ap_invs_all okl_cnsld,
AP_INVOICES inv,
AP_INVOICE_PAYMENTS pay,
AP_CHECKS AC,
fnd_application fnd_app
WHERE oklinv.id = tpl.tap_id
AND tpl.khr_id = v_khr_id
AND tpl.cnsld_ap_inv_id = okl_cnsld.cnsld_ap_inv_id
AND inv.application_id = fnd_app.application_id
AND fnd_app.application_short_name = 'OKL'
AND inv.product_table = 'OKL_CNSLD_AP_INVS_ALL'
AND okl_cnsld.cnsld_ap_inv_id = to_number(inv.reference_key1)
AND oklinv.funding_type_code = 'PREFUNDING'
--Bug# 10628703
--AND oklinv.vendor_invoice_number = inv.invoice_num -- sjalasut, is this required now?
AND inv.invoice_id = pay.invoice_id
AND pay.check_id = ac.check_id
AND ac.check_date >= v_start_date
AND ac.check_date <= v_end_date
UNION
SELECT oiv.datetime_valid change_date
FROM OKL_INDEX_VALUES oiv,
OKL_INDICES oi
WHERE oiv.idx_id = oi.id
AND oi.name = v_name
AND oiv.datetime_valid >= v_start_date
AND oiv.datetime_valid <= v_end_date;
SELECT SUM(pay.amount)
FROM OKL_TRX_AP_INVOICES_B oklinv,
okl_txl_ap_inv_lns_all_b okl_inv_ln,
okl_cnsld_ap_invs_all okl_cnsld,
AP_INVOICES inv,
AP_INVOICE_PAYMENTS pay,
AP_CHECKS AC,
fnd_application fnd_app
WHERE oklinv.id = okl_inv_ln.tap_id
AND okl_inv_ln.khr_id = v_khr_id
AND okl_inv_ln.cnsld_ap_inv_id = okl_cnsld.cnsld_ap_inv_id
AND inv.application_id = fnd_app.application_id
AND fnd_app.application_short_name = 'OKL'
AND inv.product_table = 'OKL_CNSLD_AP_INVS_ALL'
AND okl_cnsld.cnsld_ap_inv_id = to_number(inv.reference_key1)
AND oklinv.funding_type_code = 'PREFUNDING'
--Bug# 10628703
--AND oklinv.vendor_invoice_number = inv.invoice_num -- sjalasut, is this required now?
AND inv.invoice_id = pay.invoice_id
AND pay.check_id = ac.check_id
AND ac.check_date <= v_date;
SELECT idv.value
FROM OKL_INDEX_VALUES idv,
OKL_INDICES idx
WHERE idx.ID = idv.IDX_ID
AND idx.NAME = v_name
AND idv.datetime_valid = (SELECT MAX(idv.datetime_valid)
FROM OKL_INDEX_VALUES idv ,
OKL_INDICES idx
WHERE idx.id = idv.idx_id
AND idx.name = v_name
AND idv.datetime_valid <= v_interest_date);
SELECT okch.ID
FROM OKL_K_HEADERS oklh,
OKC_K_HEADERS_B okch
WHERE oklh.id = okch.id
AND okch.contract_number = v_contract_number
AND okch.scs_code = 'LEASE';
SELECT quantity
FROM okc_timeunit_v
WHERE uom_code = 'YR'
AND tce_code= 'DAY';
SELECT add_months(trunc(p_date,'year'),12) - trunc(p_date,'year')
FROM dual;
SELECT okch.contract_number contract_number,
oklh.DATE_LAST_INTERIM_INTEREST_CAL last_calc_date,
oklh.id khr_id,
oklh.pdt_id pdt_id,
okch.start_date start_date
FROM OKL_K_HEADERS oklh,
OKC_K_HEADERS_B okch,
OKC_RULES_B rule
WHERE okch.sts_code IN ('ENTERED', 'COMPLETE','PASSED','INCOMPLETE','PENDING_APPROVAL',
'APPROVED')
AND oklh.id = okch.id
AND rule.DNZ_CHR_ID = oklh.id
AND rule.rule_information_category = 'LACPLN'
AND rule.rule_information1 = 'N';
SELECT MIN(ac.check_date)
FROM OKL_TRX_AP_INVOICES_B oklinv,
okl_txl_ap_inv_lns_all_b okl_inv_ln,
okl_cnsld_ap_invs_all okl_cnsld,
AP_INVOICES inv,
AP_INVOICE_PAYMENTS pay,
AP_CHECKS AC,
fnd_application fnd_app
WHERE oklinv.id = okl_inv_ln.tap_id
AND okl_inv_ln.khr_id = v_khr_id
AND okl_inv_ln.cnsld_ap_inv_id = okl_cnsld.cnsld_ap_inv_id
AND inv.application_id = fnd_app.application_id
AND fnd_app.application_short_name = 'OKL'
AND inv.product_table = 'OKL_CNSLD_AP_INVS_ALL'
AND okl_cnsld.cnsld_ap_inv_id = to_number(inv.reference_key1)
AND oklinv.funding_type_code = 'PREFUNDING'
--Bug# 10628703
--AND oklinv.vendor_invoice_number = inv.invoice_num -- sjalasut, is this required now?
AND oklinv.ipvs_id = inv.vendor_site_id
AND inv.invoice_id = pay.invoice_id
AND pay.check_id = ac.check_id;
SELECT oklh.DATE_LAST_INTERIM_INTEREST_CAL,
oklh.PDT_ID,
oklh.ID
FROM OKL_K_HEADERS oklh,
OKC_K_HEADERS_B okch
WHERE oklh.id = okch.id
AND okch.contract_number = p_contract_number
AND okch.scs_code = 'LEASE';
SELECT MIN(ac.check_date)
FROM OKL_TRX_AP_INVOICES_B oklinv,
okl_txl_ap_inv_lns_all_b okl_inv_ln,
okl_cnsld_ap_invs_all okl_cnsld,
AP_INVOICES inv,
AP_INVOICE_PAYMENTS pay,
AP_CHECKS AC,
fnd_application fnd_app
WHERE oklinv.id = okl_inv_ln.tap_id
AND okl_inv_ln.khr_id = v_khr_id
AND okl_inv_ln.cnsld_ap_inv_id = okl_cnsld.cnsld_ap_inv_id
AND inv.application_id = fnd_app.application_id
AND fnd_app.application_short_name = 'OKL'
AND inv.product_table = 'OKL_CNSLD_AP_INVS_ALL'
AND okl_cnsld.cnsld_ap_inv_id = to_number(inv.reference_key1)
AND oklinv.funding_type_code = 'PREFUNDING'
--Bug# 10628703
--AND oklinv.vendor_invoice_number = inv.invoice_num -- sjalasut, is this required now?
AND oklinv.ipvs_id = inv.vendor_site_id
AND inv.invoice_id = pay.invoice_id
AND pay.check_id = ac.check_id;
SELECT rule_information1
FROM OKC_RULES_B
WHERE DNZ_CHR_ID = v_khr_id
AND rule_information_category = 'LACPLN';
SELECT kln.ID ID,
kln.OEC OEC,
--Added by kthiruva on 20-Feb-2006 for Bug 4899328
kln.CAPITAL_AMOUNT CAPITAL_AMOUNT,
kln.CAPITALIZED_INTEREST CAPITALIZED_INTEREST
FROM okl_k_lines kln,
okc_k_lines_b cln,
okc_k_headers_b chr,
okc_line_styles_b cls
WHERE chr.contract_number = v_contract_number AND
chr.scs_code = 'LEASE' AND
chr.ID = cln.chr_id AND
kln.ID = cln.ID AND
cln.lse_id = cls.ID AND
cls.lty_code = 'FREE_FORM1' AND
cln.STS_CODE <> 'ABANDONED';
OKL_CONTRACT_PUB.update_contract_line
(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_clev_tbl => l_clev_tbl_in,
p_klev_tbl => l_klev_tbl_in,
p_edit_mode => 'N',
x_clev_tbl => l_clev_tbl_out,
x_klev_tbl => l_klev_tbl_out);