[Home] [Help]
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 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 fnd_profile.value ('ORG_ID')
FROM dual;
SELECT ctt.cust_trx_type_id
FROM ra_cust_trx_types ctt
WHERE ctt.name = 'Invoice-OKL';
SELECT khr.bill_to_site_use_id
FROM okc_k_headers_b khr
WHERE khr.id = cp_chr_id;
SELECT con.object1_id1
FROM okc_k_headers_b CHR,
okc_contact_sources cso,
okc_k_party_roles_b kpr,
okc_contacts con
WHERE CHR.id = cp_chr_id
AND cso.cro_code = 'SALESPERSON'
AND cso.rle_code = 'LESSOR'
AND cso.buy_or_sell = CHR.buy_or_sell
AND kpr.chr_id = CHR.id
AND kpr.dnz_chr_id = CHR.id
AND kpr.rle_code = cso.rle_code
AND con.cpl_id = kpr.id
AND con.dnz_chr_id = CHR.id
AND con.cro_code = cso.cro_code
AND con.jtot_object1_code = cso.jtot_object_code;
SELECT --ite.object1_id1
RPAD (ite.object1_id1, 50, ' ') || khr.inv_organization_id
FROM okc_k_lines_b kle_fa,
okc_line_styles_b lse_fa,
okc_k_lines_b kle_ml,
okc_line_styles_b lse_ml,
okc_k_items ite,
okl_k_headers_full_v khr
WHERE kle_fa.id = cp_cle_id
AND kle_fa.chr_id = cp_chr_id
AND lse_fa.id = kle_fa.lse_id
AND lse_fa.lty_code = 'FREE_FORM1'
AND kle_ml.cle_id = kle_fa.id
AND lse_ml.id = kle_ml.lse_id
AND lse_ml.lty_code = 'ITEM'
AND ite.cle_id = kle_ml.id
AND kle_fa.dnz_chr_id = khr.id
AND ite.jtot_object1_code = 'OKX_SYSITEM';
SELECT RPAD (oal.depreciation_category, 50, ' ') || oal.corporate_book
FROM okx_asset_lines_v oal
WHERE oal.parent_line_id = cp_cle_id
AND oal.dnz_chr_id = cp_chr_id;
SELECT khr.pdt_id pdt_id,
LN.sty_id sty_id,
hd.try_id Try_id,
LN.Amount line_amount,
hd.date_invoiced,
hd.currency_code,
--Start code added by pgomes on 11/22/2002
hd.currency_conversion_type currency_conversion_type,
hd.currency_conversion_rate currency_conversion_rate,
hd.currency_conversion_date currency_conversion_date,
--End code added by pgomes on 11/22/2002
LN.id line_id,
'OKL_TXL_AR_INV_LNS_B' source_table,
hd.ID header_id,
hd.khr_id,
-- Added for bug 4228207
hd.qte_id,
LN.kle_id,
LN.til_id_reverses,
-- Bug# 4488818
LN.qte_line_id
FROM okl_txl_ar_inv_lns_v LN,
okl_trx_ar_invoices_v hd,
okl_k_headers_v khr
WHERE hd.id = LN.Tai_id AND
khr.id = hd.khr_id AND
LN.ID = l_id;
SELECT khr.pdt_id pdt_id,
dtls.sty_id sty_id,
hd.try_id Try_id,
dtls.Amount line_amount,
hd.date_invoiced date_invoiced,
hd.currency_code,
--Start code added by pgomes on 11/22/2002
hd.currency_conversion_type currency_conversion_type,
hd.currency_conversion_rate currency_conversion_rate,
hd.currency_conversion_date currency_conversion_date,
--End code added by pgomes on 11/22/2002
dtls.id line_id,
'OKL_TXD_AR_LN_DTLS_B' source_table,
hd.ID header_id,
hd.khr_id,
-- Added for bug 4228207
hd.qte_id,
LN.kle_id,
--Bug# 4488818
dtls.tld_id_reverses,
-- Bug# 4488818
LN.qte_line_id
FROM okl_txl_ar_inv_lns_v LN,
okl_trx_ar_invoices_v hd,
okl_txd_ar_ln_dtls_v dtls,
okl_k_headers_v khr
WHERE hd.id = LN.Tai_id AND
LN.ID = dtls.til_id_details AND
khr.ID = hd.KHR_ID AND
dtls.ID = l_id;
SELECT c.minimum_accountable_unit, c.precision
FROM fnd_currencies c
WHERE c.currency_code = cp_currency_code;
SELECT currency_code
FROM GL_LEDGERS_PUBLIC_V
WHERE ledger_id = p_sob_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 NVL(accrual_yn, '1')
FROM okl_strm_type_b
WHERE id = cp_sty_id;
SELECT count(*)
FROM okl_trns_acc_dstrs
WHERE source_id = cp_source_id
AND source_table = cp_source_table;
SELECT rl.rule_information1 asset_upfront_tax
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 SUM(NVL(tax_amt,0)) tax_amt,
SUM(NVL(taxable_amt,0)) taxable_amt,
tax_rate_code
FROM (
SELECT NVL(tax_amt,0) tax_amt,
NVL(taxable_amt,0) taxable_amt,
tax_rate_code
FROM okl_tax_sources txs,
okl_tax_trx_details txl,
okc_rule_groups_b rg,
okc_rules_b rl
WHERE txs.khr_id = p_khr_id
AND txs.trx_id = p_trx_id
AND txs.tax_line_status_code = 'ACTIVE'
AND txs.tax_call_type_code = 'UPFRONT_TAX'
AND txl.txs_id = txs.id
AND rg.dnz_chr_id = txs.khr_id
AND rg.cle_id = txs.kle_id
AND rg.rgd_code = 'LAASTX'
AND rl.rgp_id = rg.id
AND rl.dnz_chr_id = txs.khr_id
AND rl.rule_information_category = 'LAASTX'
AND NVL(rl.rule_information11,'BILLED') = 'BILLED'
UNION ALL
SELECT NVL(tax_amt,0) tax_amt,
NVL(taxable_amt,0) taxable_amt,
tax_rate_code
FROM okl_tax_sources txs,
okl_tax_trx_details txl
WHERE txs.khr_id = p_khr_id
AND txs.kle_id IS NULL
AND txs.trx_id = p_trx_id
AND txs.tax_line_status_code = 'ACTIVE'
AND txs.tax_call_type_code = 'UPFRONT_TAX'
AND txl.txs_id = txs.id
)
GROUP BY tax_rate_code;
SELECT SUM(NVL(tax_amt,0)) tax_amt,
SUM(NVL(taxable_amt,0)) taxable_amt,
tax_rate_code
FROM
(
SELECT NVL(tax_amt,0) tax_amt,
NVL(taxable_amt,0) taxable_amt,
tax_rate_code
FROM okl_tax_sources txs,
okl_tax_trx_details txl,
okc_rule_groups_b rg,
okc_rules_b rl
WHERE txs.khr_id = p_khr_id
AND txs.trx_id = p_trx_id
AND txs.tax_line_status_code = 'ACTIVE'
AND txs.tax_call_type_code = 'UPFRONT_TAX'
AND txl.txs_id = txs.id
AND rg.dnz_chr_id = txs.khr_id
AND rg.cle_id = txs.kle_id
AND rg.rgd_code = 'LAASTX'
AND rl.rgp_id = rg.id
AND rl.dnz_chr_id = txs.khr_id
AND rl.rule_information_category = 'LAASTX'
AND rl.rule_information11 = 'BILLED'
UNION ALL
SELECT NVL(tax_amt,0) tax_amt,
NVL(taxable_amt,0) taxable_amt,
tax_rate_code
FROM okl_tax_sources txs,
okl_tax_trx_details txl
WHERE txs.khr_id = p_khr_id
AND txs.kle_id IS NULL
AND txs.trx_id = p_trx_id
AND txs.tax_line_status_code = 'ACTIVE'
AND txs.tax_call_type_code = 'UPFRONT_TAX'
AND txl.txs_id = txs.id
)
GROUP BY tax_rate_code;
SELECT name
FROM okl_trx_types_tl
WHERE id = p_id
AND language = p_language;
SELECT til.tai_id orig_tai_id,
til.id orig_til_id
FROM okl_trx_ar_invoices_b tai,
okl_txl_ar_inv_lns_b til
WHERE tai.qte_id = p_orig_qte_id
AND tai.try_id = p_orig_try_id
AND til.tai_id = tai.id
AND til.qte_line_id = p_orig_quote_line_id;
SELECT txs.id,
txs.khr_id,
txs.kle_id,
txs.line_name,
txs.trx_id,
txs.trx_line_id,
txs.entity_code,
txs.event_class_code,
txs.trx_level_type,
txs.adjusted_doc_entity_code,
txs.adjusted_doc_event_class_code,
txs.adjusted_doc_trx_id,
txs.adjusted_doc_trx_line_id,
txs.adjusted_doc_trx_level_type,
txs.adjusted_doc_number,
txs.adjusted_doc_date,
txs.tax_call_type_code,
txs.sty_id,
txs.trx_business_category,
txs.tax_line_status_code,
txs.sel_id,
-- Modified by dcshanmu for eBTax - modification starts
txs.tax_reporting_flag,
txs.application_id,
txs.default_taxation_country,
txs.product_category,
txs.user_defined_fisc_class,
txs.line_intended_use,
txs.inventory_item_id,
txs.bill_to_cust_acct_id,
txs.org_id,
txs.legal_entity_id,
txs.line_amt,
txs.assessable_value,
txs.total_tax,
txs.product_type,
txs.product_fisc_classification,
txs.trx_date,
txs.provnl_tax_determination_date,
txs.try_id,
txs.ship_to_location_id,
txs.ship_from_location_id,
txs.trx_currency_code,
txs.currency_conversion_type,
txs.currency_conversion_rate,
txs.currency_conversion_date
-- Modified by dcshanmu for eBTax - modification end
FROM okl_tax_sources txs
WHERE txs.trx_id = p_orig_trx_id
AND txs.trx_line_id =p_orig_trx_line_id;
SELECT ttd.txs_id,
ttd.tax_determine_date,
ttd.tax_rate_id,
ttd.tax_rate_code,
ttd.taxable_amt,
ttd.tax_exemption_id,
ttd.tax_rate,
ttd.tax_amt,
ttd.billed_yn,
-- Modified by dcshanmu for eBTax - modification starts
ttd.tax_call_type_code,
ttd.tax_date,
ttd.line_amt,
ttd.internal_organization_id,
ttd.application_id,
ttd.entity_code,
ttd.event_class_code,
ttd.event_type_code,
ttd.trx_id,
ttd.trx_line_id,
ttd.trx_level_type,
ttd.trx_line_number,
ttd.tax_line_number,
ttd.tax_regime_id,
ttd.tax_regime_code,
ttd.tax_id,
ttd.tax,
ttd.tax_status_id,
ttd.tax_status_code,
ttd.tax_apportionment_line_number,
ttd.legal_entity_id,
ttd.trx_number,
ttd.trx_date,
ttd.tax_jurisdiction_id,
ttd.tax_jurisdiction_code,
ttd.tax_type_code,
ttd.tax_currency_code,
ttd.taxable_amt_tax_curr,
ttd.trx_currency_code,
ttd.minimum_accountable_unit,
ttd.precision,
ttd.currency_conversion_type,
ttd.currency_conversion_rate,
ttd.currency_conversion_date
-- Modified by dcshanmu for eBTax - modification end
FROM okl_tax_trx_details ttd
WHERE ttd.txs_id = p_orig_txs_id;
SELECT til.amount,
til.tai_id
FROM okl_txl_ar_inv_lns_b til
WHERE til.id = p_til_id;
SELECT tld.amount,
til.tai_id
FROM okl_txd_ar_ln_dtls_b tld,
okl_txl_ar_inv_lns_b til
WHERE tld.id = p_tld_id
AND til.id = tld.til_id_details;
SELECT '!'
FROM okl_trx_contracts ktrx
WHERE ktrx.khr_id = p_chr_id
AND ktrx.id = p_trx_id
AND ktrx.tsu_code = 'ENTERED'
AND ktrx.rbr_code IS NOT NULL
AND ktrx.tcn_type = 'TRBK'
AND EXISTS (SELECT '1'
FROM okl_rbk_selected_contract rbk_khr
WHERE rbk_khr.khr_id = ktrx.khr_id
AND rbk_khr.status <> 'PROCESSED');
SELECT NVL(tax_amt,0) tax_amt,
NVL(taxable_amt,0) taxable_amt,
tax_rate_code
FROM okl_tax_sources txs,
okl_tax_trx_details txl
WHERE txs.khr_id = p_khr_id
AND txs.trx_id = p_trx_id
AND txs.tax_line_status_code = 'ACTIVE'
AND txs.tax_call_type_code = 'UPFRONT_TAX'
AND txl.txs_id = txs.id
GROUP BY tax_rate_code;
Okl_Tai_Pvt.update_row(
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 => p_taiv_rec,
x_taiv_rec => x_taiv_rec);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRACCB.pls call OKL_TAX_SOURCES_PUB.insert_tax_sources ');
OKL_TAX_SOURCES_PUB.insert_tax_sources(
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_txsv_rec => lp_txsv_rec,
x_txsv_rec => lx_txsv_rec);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRACCB.pls call OKL_TAX_SOURCES_PUB.insert_tax_sources ');
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRACCB.pls call OKL_TAX_TRX_DETAILS_PUB.insert_tax_trx_details ');
OKL_TAX_TRX_DETAILS_PUB.insert_tax_trx_details(
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_ttdv_tbl => lp_ttdv_tbl,
x_ttdv_tbl => lx_ttdv_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRACCB.pls call OKL_TAX_TRX_DETAILS_PUB.insert_tax_trx_details ');
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRACCB.pls call OKL_TAX_SOURCES_PUB.insert_tax_sources ');
OKL_TAX_SOURCES_PUB.insert_tax_sources(
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_txsv_rec => lp_txsv_rec,
x_txsv_rec => lx_txsv_rec);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRACCB.pls call OKL_TAX_SOURCES_PUB.insert_tax_sources ');
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRACCB.pls call OKL_TAX_TRX_DETAILS_PUB.insert_tax_trx_details ');
OKL_TAX_TRX_DETAILS_PUB.insert_tax_trx_details(
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_ttdv_tbl => lp_ttdv_tbl,
x_ttdv_tbl => lx_ttdv_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRACCB.pls call OKL_TAX_TRX_DETAILS_PUB.insert_tax_trx_details ');
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRACCB.pls call OKL_TAX_SOURCES_PUB.insert_tax_sources ');
OKL_TAX_SOURCES_PUB.insert_tax_sources(
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_txsv_rec => lp_txsv_rec,
x_txsv_rec => lx_txsv_rec);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRACCB.pls call OKL_TAX_SOURCES_PUB.insert_tax_sources ');
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRACCB.pls call OKL_TAX_TRX_DETAILS_PUB.insert_tax_trx_details ');
OKL_TAX_TRX_DETAILS_PUB.insert_tax_trx_details(
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_ttdv_tbl => lp_ttdv_tbl,
x_ttdv_tbl => lx_ttdv_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRACCB.pls call OKL_TAX_TRX_DETAILS_PUB.insert_tax_trx_details ');
SELECT khr.pdt_id pdt_id,
LN.sty_id sty_id,
hd.try_id Try_id,
LN.Amount line_amount,
hd.date_invoiced,
hd.currency_code,
--Start code added by pgomes on 11/22/2002
hd.currency_conversion_type currency_conversion_type,
hd.currency_conversion_rate currency_conversion_rate,
hd.currency_conversion_date currency_conversion_date,
--End code added by pgomes on 11/22/2002
LN.id line_id,
'OKL_TXL_AR_INV_LNS_B' source_table,
hd.ID header_id,
hd.khr_id,
-- Added for bug 4228207
hd.qte_id,
LN.kle_id,
LN.til_id_reverses,
-- Bug# 4488818
LN.qte_line_id
FROM okl_txl_ar_inv_lns_v LN,
okl_trx_ar_invoices_v hd,
okl_k_headers_v khr
WHERE hd.id = LN.Tai_id AND
khr.id = hd.khr_id AND
LN.ID = l_id;
SELECT khr.pdt_id pdt_id,
dtls.sty_id sty_id,
hd.try_id Try_id,
dtls.Amount line_amount,
hd.date_invoiced date_invoiced,
hd.currency_code,
--Start code added by pgomes on 11/22/2002
hd.currency_conversion_type currency_conversion_type,
hd.currency_conversion_rate currency_conversion_rate,
hd.currency_conversion_date currency_conversion_date,
--End code added by pgomes on 11/22/2002
dtls.id line_id,
'OKL_TXD_AR_LN_DTLS_B' source_table,
hd.ID header_id,
hd.khr_id,
-- Added for bug 4228207
hd.qte_id,
LN.kle_id,
--Bug# 4488818
dtls.tld_id_reverses,
-- Bug# 4488818
LN.qte_line_id
FROM okl_txl_ar_inv_lns_v LN,
okl_trx_ar_invoices_v hd,
okl_txd_ar_ln_dtls_v dtls,
okl_k_headers_v khr
WHERE hd.id = LN.Tai_id AND
LN.ID = dtls.til_id_details AND
khr.ID = hd.KHR_ID AND
dtls.ID = l_id;
SELECT c.minimum_accountable_unit, c.precision
FROM fnd_currencies c
WHERE c.currency_code = cp_currency_code;
SELECT currency_code
FROM GL_LEDGERS_PUBLIC_V
WHERE ledger_id = p_sob_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 NVL(accrual_yn, '1')
FROM okl_strm_type_b
WHERE id = cp_sty_id;
SELECT count(*)
FROM okl_trns_acc_dstrs
WHERE source_id = cp_source_id
AND source_table = cp_source_table;
SELECT rl.rule_information1 asset_upfront_tax
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 SUM(NVL(tax_amt,0)) tax_amt,
SUM(NVL(taxable_amt,0)) taxable_amt,
tax_rate_code
FROM (
SELECT NVL(tax_amt,0) tax_amt,
NVL(taxable_amt,0) taxable_amt,
tax_rate_code
FROM okl_tax_sources txs,
okl_tax_trx_details txl,
okc_rule_groups_b rg,
okc_rules_b rl
WHERE txs.khr_id = p_khr_id
AND txs.trx_id = p_trx_id
AND txs.tax_line_status_code = 'ACTIVE'
AND txs.tax_call_type_code = 'UPFRONT_TAX'
AND txl.txs_id = txs.id
AND rg.dnz_chr_id = txs.khr_id
AND rg.cle_id = txs.kle_id
AND rg.rgd_code = 'LAASTX'
AND rl.rgp_id = rg.id
AND rl.dnz_chr_id = txs.khr_id
AND rl.rule_information_category = 'LAASTX'
AND NVL(rl.rule_information11,'BILLED') = 'BILLED'
UNION ALL
SELECT NVL(tax_amt,0) tax_amt,
NVL(taxable_amt,0) taxable_amt,
tax_rate_code
FROM okl_tax_sources txs,
okl_tax_trx_details txl
WHERE txs.khr_id = p_khr_id
AND txs.kle_id IS NULL
AND txs.trx_id = p_trx_id
AND txs.tax_line_status_code = 'ACTIVE'
AND txs.tax_call_type_code = 'UPFRONT_TAX'
AND txl.txs_id = txs.id
)
GROUP BY tax_rate_code;
SELECT SUM(NVL(tax_amt,0)) tax_amt,
SUM(NVL(taxable_amt,0)) taxable_amt,
tax_rate_code
FROM
(
SELECT NVL(tax_amt,0) tax_amt,
NVL(taxable_amt,0) taxable_amt,
tax_rate_code
FROM okl_tax_sources txs,
okl_tax_trx_details txl,
okc_rule_groups_b rg,
okc_rules_b rl
WHERE txs.khr_id = p_khr_id
AND txs.trx_id = p_trx_id
AND txs.tax_line_status_code = 'ACTIVE'
AND txs.tax_call_type_code = 'UPFRONT_TAX'
AND txl.txs_id = txs.id
AND rg.dnz_chr_id = txs.khr_id
AND rg.cle_id = txs.kle_id
AND rg.rgd_code = 'LAASTX'
AND rl.rgp_id = rg.id
AND rl.dnz_chr_id = txs.khr_id
AND rl.rule_information_category = 'LAASTX'
AND rl.rule_information11 = 'BILLED'
UNION ALL
SELECT NVL(tax_amt,0) tax_amt,
NVL(taxable_amt,0) taxable_amt,
tax_rate_code
FROM okl_tax_sources txs,
okl_tax_trx_details txl
WHERE txs.khr_id = p_khr_id
AND txs.kle_id IS NULL
AND txs.trx_id = p_trx_id
AND txs.tax_line_status_code = 'ACTIVE'
AND txs.tax_call_type_code = 'UPFRONT_TAX'
AND txl.txs_id = txs.id
)
GROUP BY tax_rate_code;
SELECT name
FROM okl_trx_types_tl
WHERE id = p_id
AND language = p_language;
SELECT til.tai_id orig_tai_id,
til.id orig_til_id
FROM okl_trx_ar_invoices_b tai,
okl_txl_ar_inv_lns_b til
WHERE tai.qte_id = p_orig_qte_id
AND tai.try_id = p_orig_try_id
AND til.tai_id = tai.id
AND til.qte_line_id = p_orig_quote_line_id;
SELECT txs.id,
txs.khr_id,
txs.kle_id,
txs.line_name,
txs.trx_id,
txs.trx_line_id,
txs.entity_code,
txs.event_class_code,
txs.trx_level_type,
txs.adjusted_doc_entity_code,
txs.adjusted_doc_event_class_code,
txs.adjusted_doc_trx_id,
txs.adjusted_doc_trx_line_id,
txs.adjusted_doc_trx_level_type,
txs.adjusted_doc_number,
txs.adjusted_doc_date,
txs.tax_call_type_code,
txs.sty_id,
txs.trx_business_category,
txs.tax_line_status_code,
txs.sel_id,
-- Modified by dcshanmu for eBTax - modification starts
txs.tax_reporting_flag,
txs.application_id,
txs.default_taxation_country,
txs.product_category,
txs.user_defined_fisc_class,
txs.line_intended_use,
txs.inventory_item_id,
txs.bill_to_cust_acct_id,
txs.org_id,
txs.legal_entity_id,
txs.line_amt,
txs.assessable_value,
txs.total_tax,
txs.product_type,
txs.product_fisc_classification,
txs.trx_date,
txs.provnl_tax_determination_date,
txs.try_id,
txs.ship_to_location_id,
txs.ship_from_location_id,
txs.trx_currency_code,
txs.currency_conversion_type,
txs.currency_conversion_rate,
txs.currency_conversion_date
-- Modified by dcshanmu for eBTax - modification end
FROM okl_tax_sources txs
WHERE txs.trx_id = p_orig_trx_id
AND txs.trx_line_id =p_orig_trx_line_id;
SELECT ttd.txs_id,
ttd.tax_determine_date,
ttd.tax_rate_id,
ttd.tax_rate_code,
ttd.taxable_amt,
ttd.tax_exemption_id,
ttd.tax_rate,
ttd.tax_amt,
ttd.billed_yn,
-- Modified by dcshanmu for eBTax - modification starts
ttd.tax_call_type_code,
ttd.tax_date,
ttd.line_amt,
ttd.internal_organization_id,
ttd.application_id,
ttd.entity_code,
ttd.event_class_code,
ttd.event_type_code,
ttd.trx_id,
ttd.trx_line_id,
ttd.trx_level_type,
ttd.trx_line_number,
ttd.tax_line_number,
ttd.tax_regime_id,
ttd.tax_regime_code,
ttd.tax_id,
ttd.tax,
ttd.tax_status_id,
ttd.tax_status_code,
ttd.tax_apportionment_line_number,
ttd.legal_entity_id,
ttd.trx_number,
ttd.trx_date,
ttd.tax_jurisdiction_id,
ttd.tax_jurisdiction_code,
ttd.tax_type_code,
ttd.tax_currency_code,
ttd.taxable_amt_tax_curr,
ttd.trx_currency_code,
ttd.minimum_accountable_unit,
ttd.precision,
ttd.currency_conversion_type,
ttd.currency_conversion_rate,
ttd.currency_conversion_date
-- Modified by dcshanmu for eBTax - modification end
FROM okl_tax_trx_details ttd
WHERE ttd.txs_id = p_orig_txs_id;
SELECT til.amount,
til.tai_id
FROM okl_txl_ar_inv_lns_b til
WHERE til.id = p_til_id;
SELECT tld.amount,
til.tai_id
FROM okl_txd_ar_ln_dtls_b tld,
okl_txl_ar_inv_lns_b til
WHERE tld.id = p_tld_id
AND til.id = tld.til_id_details;
SELECT '!'
FROM okl_trx_contracts ktrx
WHERE ktrx.khr_id = p_chr_id
AND ktrx.id = p_trx_id
AND ktrx.tsu_code = 'ENTERED'
AND ktrx.rbr_code IS NOT NULL
AND ktrx.tcn_type = 'TRBK'
AND EXISTS (SELECT '1'
FROM okl_rbk_selected_contract rbk_khr
WHERE rbk_khr.khr_id = ktrx.khr_id
AND rbk_khr.status <> 'PROCESSED');
SELECT NVL(tax_amt,0) tax_amt,
NVL(taxable_amt,0) taxable_amt,
tax_rate_code
FROM okl_tax_sources txs,
okl_tax_trx_details txl
WHERE txs.khr_id = p_khr_id
AND txs.trx_id = p_trx_id
AND txs.tax_line_status_code = 'ACTIVE'
AND txs.tax_call_type_code = 'UPFRONT_TAX'
AND txl.txs_id = txs.id
GROUP BY tax_rate_code;
Okl_Tai_Pvt.update_row(
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 => p_taiv_rec,
x_taiv_rec => x_taiv_rec);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRACCB.pls call OKL_TAX_SOURCES_PUB.insert_tax_sources ');
OKL_TAX_SOURCES_PUB.insert_tax_sources(
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_txsv_rec => lp_txsv_rec,
x_txsv_rec => lx_txsv_rec);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRACCB.pls call OKL_TAX_SOURCES_PUB.insert_tax_sources ');
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRACCB.pls call OKL_TAX_TRX_DETAILS_PUB.insert_tax_trx_details ');
OKL_TAX_TRX_DETAILS_PUB.insert_tax_trx_details(
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_ttdv_tbl => lp_ttdv_tbl,
x_ttdv_tbl => lx_ttdv_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRACCB.pls call OKL_TAX_TRX_DETAILS_PUB.insert_tax_trx_details ');
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRACCB.pls call OKL_TAX_SOURCES_PUB.insert_tax_sources ');
OKL_TAX_SOURCES_PUB.insert_tax_sources(
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_txsv_rec => lp_txsv_rec,
x_txsv_rec => lx_txsv_rec);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRACCB.pls call OKL_TAX_SOURCES_PUB.insert_tax_sources ');
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRACCB.pls call OKL_TAX_TRX_DETAILS_PUB.insert_tax_trx_details ');
OKL_TAX_TRX_DETAILS_PUB.insert_tax_trx_details(
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_ttdv_tbl => lp_ttdv_tbl,
x_ttdv_tbl => lx_ttdv_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRACCB.pls call OKL_TAX_TRX_DETAILS_PUB.insert_tax_trx_details ');
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRACCB.pls call OKL_TAX_SOURCES_PUB.insert_tax_sources ');
OKL_TAX_SOURCES_PUB.insert_tax_sources(
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_txsv_rec => lp_txsv_rec,
x_txsv_rec => lx_txsv_rec);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRACCB.pls call OKL_TAX_SOURCES_PUB.insert_tax_sources ');
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRACCB.pls call OKL_TAX_TRX_DETAILS_PUB.insert_tax_trx_details ');
OKL_TAX_TRX_DETAILS_PUB.insert_tax_trx_details(
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_ttdv_tbl => lp_ttdv_tbl,
x_ttdv_tbl => lx_ttdv_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRACCB.pls call OKL_TAX_TRX_DETAILS_PUB.insert_tax_trx_details ');