The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT id
FROM OKL_TRX_TYPES_TL
WHERE name = cp_name
AND LANGUAGE = cp_language;
SELECT jtot_object1_code,
object1_id1,
object1_id2
FROM okc_rules_b
WHERE rgp_id =
(SELECT id
FROM okc_rule_groups_b
WHERE dnz_chr_id = p_khr_id
AND cle_id IS NULL
AND rgd_code = 'LABILL')
AND rule_information_category = p_rule_category;
SELECT id1
FROM okx_cust_trx_types_v
WHERE name = 'Invoice-OKL'
AND set_of_books_id = p_sob_id
AND org_id = p_org_id;
SELECT id1
FROM okx_cust_trx_types_v
WHERE name = 'Credit Memo-OKL'
AND set_of_books_id = p_sob_id
AND org_id = p_org_id;
SELECT authoring_org_id
FROM okc_k_headers_b
WHERE id = p_khr_id;
SELECT a.cust_acct_id cust_account_id,
b.cust_acct_site_id,
c.standard_terms payment_term_id
FROM okc_k_headers_v a,
okx_cust_site_uses_v b,
hz_customer_profiles c
WHERE a.id = p_contract_id
AND a.bill_to_site_use_id = b.id1
AND a.bill_to_site_use_id = c.site_use_id(+);
SELECT c.receipt_method_id
FROM ra_cust_receipt_methods c
WHERE c.cust_receipt_method_id = p_cust_rct_mthd;
SELECT bank_account_id
FROM okx_rcpt_method_accounts_v
WHERE id1 = p_id;
SELECT B.TERM_ID
FROM RA_TERMS_TL T, RA_TERMS_B B
where T.name = 'IMMEDIATE' and T.LANGUAGE = userenv('LANG')
and B.TERM_ID = T.TERM_ID;
SELECT c.creation_method_code
FROM ar_receipt_methods m,
ar_receipt_classes c
WHERE m.receipt_class_id = c.receipt_class_id
AND m.receipt_method_id = p_rct_method_id;
SELECT currency_code,
currency_conversion_type,
currency_conversion_rate,
currency_conversion_date
FROM okl_k_headers_full_v
WHERE id = cp_khr_id;
SELECT to_number(rul.rule_information1), -- inf.id, --sechawla 26-may-09 6826580
rul.rule_information4 review_invoice_yn
FROM okc_rule_groups_v rgp,
okc_rules_v rul
--, okl_invoice_formats_v inf --sechawla 26-may-09 6826580
WHERE rgp.dnz_chr_id = cp_khr_id
AND rgp.chr_id = rgp.dnz_chr_id
AND rgp.id = rul.rgp_id
AND rgp.cle_id IS NULL
AND rgp.rgd_code = 'LABILL'
AND rul.rule_information_category = 'LAINVD';
SELECT rule_information1 private_label
FROM okc_rule_groups_b a,
okc_rules_b b
WHERE a.dnz_chr_id = cp_khr_id
AND a.rgd_code = 'LALABL'
AND a.id = b.rgp_id
AND b.rule_information_category = 'LALOGO';
SELECT rl.rule_information2
FROM okc_rule_groups_b rg,
okc_rules_b rl
WHERE rg.dnz_chr_id = p_khr_id
AND rg.rgd_code = 'LAHDTX'
AND rl.rgp_id = rg.id
AND rl.dnz_chr_id = rg.dnz_chr_id
AND rl.rule_information_category = 'LASTPR';
SELECT r1.rule_information1 asset_upfront_tax
FROM okc_rule_groups_b rg,
okc_rules_b r1
WHERE rg.dnz_chr_id = cp_khr_id
AND rg.rgd_code = 'LAHDTX'
AND r1.rgp_id = rg.id
AND r1.dnz_chr_id = rg.dnz_chr_id
AND r1.rule_information_category = 'LASTPR';
SELECT trx_id,
trx_line_id,
entity_code,
event_class_code,
application_id,
trx_level_type,
kle_id,
org_id
FROM okl_tax_sources txs,
okc_rule_groups_b rg,
okc_rules_b r1
WHERE txs.khr_id = cp_khr_id
AND txs.application_id = 540
AND txs.trx_id = cp_trx_id
AND txs.trx_level_type = 'LINE'
AND txs.tax_call_type_code = 'UPFRONT_TAX'
AND rg.dnz_chr_id = txs.khr_id
AND rg.cle_id = txs.kle_id
AND rg.rgd_code = 'LAASTX'
AND r1.rgp_id = rg.id --akrangan added for perfomance --hash cartesian join fixed
AND nvl(r1.rule_information11, 'BILLED') = 'BILLED' --sechawla 08-nov-07 6618649 : changed rule_information1 to rule_information11
AND r1.dnz_chr_id = cp_khr_id --sechawla 08-nov-07 6618649 : added for performance
AND r1.RULE_INFORMATION_CATEGORY ='LAASTX' --sechawla 08-nov-07 6618649 : Added this condition
AND txs.total_tax <> 0
UNION
SELECT trx_id,
trx_line_id,
entity_code,
event_class_code,
application_id,
trx_level_type,
NULL,
org_id
FROM okl_tax_sources txs
WHERE txs.khr_id = cp_khr_id
AND txs.kle_id IS NULL
AND txs.application_id = 540
AND txs.trx_id = cp_trx_id
AND txs.trx_level_type = 'LINE'
AND txs.tax_call_type_code = 'UPFRONT_TAX'
AND txs.total_tax <> 0 ;
SELECT trx_id,
trx_line_id,
entity_code,
event_class_code,
application_id,
trx_level_type,
kle_id,
org_id
FROM okl_tax_sources txs,
okc_rule_groups_b rg,
okc_rules_b r1
WHERE txs.khr_id = cp_khr_id
AND txs.application_id = 540
AND txs.trx_id = cp_trx_id
AND txs.trx_level_type = 'LINE'
AND txs.tax_call_type_code = 'UPFRONT_TAX'
AND rg.dnz_chr_id = txs.khr_id
AND rg.cle_id = txs.kle_id
AND rg.rgd_code = 'LAASTX'
AND r1.rgp_id = rg.id --akrangan added for perfomance --hash cartesian join fixed
AND r1.rule_information11 = 'BILLED' --sechawla 08-nov-07 6618649 : changed rule_information1 to rule_information11
AND r1.dnz_chr_id = cp_khr_id --sechawla 08-nov-07 6618649 : added for performance
AND r1.RULE_INFORMATION_CATEGORY ='LAASTX' --sechawla 08-nov-07 6618649 : Added this condition
AND txs.total_tax <> 0
UNION
SELECT trx_id,
trx_line_id,
entity_code,
event_class_code,
application_id,
trx_level_type,
NULL,
org_id
FROM okl_tax_sources txs
WHERE txs.khr_id = cp_khr_id
AND txs.kle_id IS NULL
AND txs.application_id = 540
AND txs.trx_id = cp_trx_id
AND txs.trx_level_type = 'LINE'
AND txs.tax_call_type_code = 'UPFRONT_TAX'
AND txs.total_tax <> 0;
SELECT language_code,
installed_flag
FROM fnd_languages
WHERE installed_flag IN ('I', 'B')
ORDER BY installed_flag;
SELECT NVL(inv_organization_id, -99),
org_id --akrangan added for tax only invoice changes
FROM okc_k_headers_b
WHERE id = p_contract_id;
SELECT tax_line_id, tax_amt
FROM zx_lines
WHERE trx_id = cp_trx_id
AND trx_line_id = cp_trx_line_id
AND application_id = cp_application_id
AND event_class_code = cp_event_class_code
AND entity_code = cp_entity_code
AND trx_level_type = cp_trx_level_type
AND nvl(cancel_flag, 'N') <> 'Y';
SELECT id1
FROM okx_cust_trx_types_v
WHERE name = 'Invoice-OKL'
AND set_of_books_id = p_sob_id
AND org_id = p_org_id;
SELECT id1
FROM okx_cust_trx_types_v
WHERE name = 'Credit Memo-OKL'
AND set_of_books_id = p_sob_id
AND org_id = p_org_id;
SELECT to_number(rul.rule_information1), --inf.id, --sechawla 26-may-09 6826580
rul.rule_information4 review_invoice_yn
FROM okc_rule_groups_v rgp,
okc_rules_v rul
--, okl_invoice_formats_v inf --sechawla 26-may-09 6826580
WHERE rgp.dnz_chr_id = cp_khr_id
AND rgp.chr_id = rgp.dnz_chr_id
AND rgp.id = rul.rgp_id
AND rgp.cle_id IS NULL
AND rgp.rgd_code = 'LABILL'
AND rul.rule_information_category = 'LAINVD';
lp_taiv_rec.amount := l_zero_amount; --sechawla 13-may-2008 6619311 : This amount will be updated later with
lp_taiv_rec.try_id := l_billing_try_id; -- sechawla 13-may-2008 6619311 : This try_id will get updated later
OKL_TRX_AR_INVOICES_PUB.insert_trx_ar_invoices(
p_api_version => p_api_version
,p_init_msg_list => p_init_msg_list
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_taiv_rec => lx_taiv_rec
,x_taiv_rec => xp_taiv_rec);
l_txl_ar_inv_lns_tbl.DELETE;
l_txl_ar_inv_lns_tbl(i).last_updated_by := g_user_id;
l_txl_ar_inv_lns_tbl(i).last_update_date := SYSDATE;
l_txl_ar_inv_lns_tbl(i).last_update_login := g_login_id;
l_txl_ar_inv_lns_tbl(i).program_update_date := NULL;
l_txd_ar_inv_ln_dtls_tbl(i).last_updated_by := g_user_id;
l_txd_ar_inv_ln_dtls_tbl(i).last_update_date := SYSDATE;
l_txl_ar_inv_lns_tl_tbl(k).last_updated_by := g_user_id;
l_txl_ar_inv_lns_tl_tbl(k).last_update_date := SYSDATE;
l_txl_ar_inv_lns_tl_tbl(k).last_update_login := g_login_id;
l_txl_ar_inv_lns_tbl(i).last_updated_by := g_user_id;
l_txl_ar_inv_lns_tbl(i).last_update_date := SYSDATE;
l_txl_ar_inv_lns_tbl(i).last_update_login := g_login_id;
l_txl_ar_inv_lns_tbl(i).program_update_date := NULL;
l_txd_ar_inv_ln_dtls_tbl(i).last_updated_by := g_user_id;
l_txd_ar_inv_ln_dtls_tbl(i).last_update_date := SYSDATE;
l_txl_ar_inv_lns_tl_tbl(k).last_updated_by := g_user_id;
l_txl_ar_inv_lns_tl_tbl(k).last_update_date := SYSDATE;
l_txl_ar_inv_lns_tl_tbl(k).last_update_login := g_login_id;
OKL_TRX_AR_INVOICES_PUB.update_trx_ar_invoices(
p_api_version => p_api_version
,p_init_msg_list => p_init_msg_list
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_taiv_rec => lp_taiv_rec
,x_taiv_rec => lx_taiv_rec);
INSERT INTO okl_txl_ar_inv_lns_b
VALUES l_txl_ar_inv_lns_tbl(i);
INSERT INTO OKL_TXD_AR_LN_DTLS_B
VALUES l_txd_ar_inv_ln_dtls_tbl(i);
INSERT INTO okl_txd_ar_ln_dtls_tl(
ID,
LANGUAGE,
SOURCE_LANG,
SFWT_FLAG,
DESCRIPTION,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
ERROR_MESSAGE)
SELECT tld.ID,
l.language_code,
userenv('LANG'),
'N',
l_def_desc,
g_user_id,
sysdate,
g_user_id,
sysdate,
g_login_id,
null
FROM okl_txd_ar_ln_dtls_b tld, fnd_languages l
WHERE l.installed_flag IN ('I', 'B')
and tld.id = l_txd_ar_inv_ln_dtls_tbl(m).id ;
INSERT INTO okl_txl_ar_inv_lns_tl
VALUES l_txl_ar_inv_lns_tl_tbl(i);
l_tldv_tbl(n).program_update_date := l_txd_ar_inv_ln_dtls_tbl(n).program_update_date ;
l_tldv_tbl(n).last_updated_by := l_txd_ar_inv_ln_dtls_tbl(n).last_updated_by ;
l_tldv_tbl(n).last_update_date := l_txd_ar_inv_ln_dtls_tbl(n).last_update_date ;
l_tldv_tbl(n).last_update_login := l_txd_ar_inv_ln_dtls_tbl(n).last_update_login ;