[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT cs.cust_acct_site_id --, cp.standard_terms payment_term_id
FROM okc_k_headers_b khr
, okx_cust_site_uses_v cs
, okc_k_lines_b cle
, hz_customer_profiles cp
WHERE khr.id = p_khr_id
AND cle.dnz_chr_id = khr.id
AND cle.chr_id IS NOT NULL
AND cle.id = p_kle_id
AND cle.BILL_TO_SITE_USE_ID = cs.id1
AND khr.bill_to_site_use_id = cp.site_use_id(+)
UNION
SELECT cs.cust_acct_site_id --, cp.standard_terms payment_term_id
FROM okc_k_headers_b khr
, okc_k_lines_b cle
, okc_k_items item
, okc_k_lines_b linked_asset
, okx_cust_site_uses_v cs
, hz_customer_profiles cp
WHERE khr.id = p_khr_id
AND cle.dnz_chr_id = khr.id
AND cle.id = p_kle_id
AND cle.chr_id IS NULL
AND cle.id = item.cle_id
AND item.object1_id1 = linked_asset.id
AND linked_asset.BILL_TO_SITE_USE_ID = cs.id1
AND khr.bill_to_site_use_id = cp.site_use_id(+);
SELECT cs.cust_acct_site_id
-- , cp.standard_terms payment_term_id
FROM okc_k_headers_v khr
, okx_cust_site_uses_v cs
, hz_customer_profiles cp
WHERE khr.id = p_khr_id
AND khr.bill_to_site_use_id = cs.id1
AND khr.bill_to_site_use_id = cp.site_use_id(+);
SELECT id
FROM okl_trx_types_tl
WHERE name = p_try_name
AND language = 'US';
SELECT pdt_id
FROM okl_k_headers
WHERE id = p_khr_id;
SELECT
'SYNDICATION'
FROM
okc_k_headers_b chr
WHERE
EXISTS ( SELECT 'x' FROM okc_k_items cim
WHERE cim.object1_id1 = to_char(chr.id) AND
EXISTS ( SELECT 'x' FROM okc_k_lines_b cle, okc_line_styles_b lse
WHERE cle.lse_id = lse.id AND
lse.lty_code = 'SHARED' AND cle.id = cim.cle_id ) AND
EXISTS ( SELECT 'x' FROM okc_k_headers_b chr2
WHERE chr2.id = cim.dnz_chr_id AND
chr2.scs_code = 'SYNDICATION' AND
chr2.sts_code not in ('TERMINATED','ABANDONED') ) ) AND
chr.scs_code = 'LEASE' AND
id = p_khr_id;
select '1'
from okc_rules_b
where dnz_chr_id = p_khr_id
and rule_information_category = 'LAFCTG'
and (rule_information1 is not null
or rule_information2 is not null
or rule_information3 is not null);
SELECT scs_code
FROM okc_k_headers_b
WHERE scs_code = 'SYNDICATION'
AND id = p_khr_id;
SELECT '1'
FROM okc_rules_b
WHERE dnz_chr_id = p_khr_id
AND rule_information_category = 'LAFCTG';
PROCEDURE insert_request(p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
--p_lsm_id IN NUMBER, -- Bug 5897792
p_tld_id IN NUMBER,
p_credit_amount IN NUMBER,
p_credit_sty_id IN NUMBER,
p_credit_desc IN VARCHAR2,
p_credit_date IN DATE,
p_try_id IN NUMBER,
-- Bug 5897792
p_transaction_source IN VARCHAR2 DEFAULT NULL,
p_source_trx_number IN VARCHAR2 DEFAULT NULL,
-- Bug 5897792
x_tai_id OUT NOCOPY NUMBER,
x_taiv_rec OUT NOCOPY taiv_rec_type,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2) IS
CURSOR c_3LevelInvoice IS
SELECT tai.set_of_books_id set_of_books_id,
tai.currency_code currency_code,
tai.ixx_id ixx_id,
--tai.customer_address_id ibt_id,
tai.irm_id irm_id,
tai.irt_id irt_id,
tai.org_id org_id,
tai.id tai_id_reverses,
tai.khr_id khr_id,
tai.legal_entity_id legal_entity_id ,
tai.date_invoiced date_invoiced,
til.id til_id_reverses,
til.kle_id kle_id,
tld.id tld_id_reverses,
tld.sty_id sty_id,
tld.til_id_details til_id_details,
tld.sel_id sel_id -- 6237730
FROM
okl_txd_ar_ln_dtls_b tld,
okl_txl_ar_inv_lns_b til,
okl_trx_ar_invoices_b tai
WHERE tai.id = til.tai_id
AND til.id = tld.TIL_ID_DETAILS
--AND tld.lsm_id = p_tld_id;
SELECT tai.set_of_books_id set_of_books_id,
tai.currency_code currency_code,
tai.ixx_id ixx_id,
-- tai.customer_address_id ibt_id,
tai.irm_id irm_id,
tai.irt_id irt_id,
tai.org_id org_id,
tai.id tai_id_reverses,
tai.khr_id khr_id,
tai.legal_entity_id legal_entity_id ,
tai.date_invoiced date_invoiced,
til.id til_id_reverses,
til.kle_id kle_id,
til.sty_id sty_id
FROM
okl_txd_ar_ln_dtls_b tld,
okl_txl_ar_inv_lns_b til,
okl_trx_ar_invoices_b tai
WHERE tai.id = til.tai_id
AND til.id = tld.TIL_ID_DETAILS
--AND tld.lsm_id = p_tld_id;
SELECT cnr.legal_entity_id
FROM okl_cnsld_ar_strms_b lsm,
okl_cnsld_ar_lines_b lln,
okl_cnsld_ar_hdrs_b cnr
WHERE lsm.lln_id = lln.id
AND lln.cnr_id = cnr.id
AND lsm.id = p_lsm_id;*/ -- Bug 5897792
SELECT trx.legal_entity_id
FROM okl_txd_ar_ln_dtls_b tld,
okl_txl_ar_inv_lns_b til,
okl_trx_ar_invoices_b trx
WHERE tld.til_id_details = til.id
AND til.tai_id = trx.id
AND tld.id = p_tld_id;
END insert_request;
PROCEDURE insert_request(p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
p_credit_list IN credit_tbl,
--Bug 5897792
p_transaction_source IN VARCHAR2 DEFAULT NULL,
p_source_trx_number IN VARCHAR2 DEFAULT NULL,
-- Bug 5897792
x_taiv_tbl OUT NOCOPY taiv_tbl_type,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2) IS
l_return_status VARCHAR2(1);
insert_request(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
p_tld_id => p_credit_list(i).lsm_id,
p_credit_amount => p_credit_list(i).credit_amount,
p_credit_sty_id => p_credit_list(i).credit_sty_id,
p_credit_desc => p_credit_list(i).credit_desc,
p_credit_date => p_credit_list(i).credit_date,
p_try_id => l_try_id,
--Bug 5897792
p_transaction_source => p_credit_list(i).transaction_source,
p_source_trx_number => p_credit_list(i).source_trx_number,
-- Bug 5897792
x_tai_id => lx_tai_id,
x_taiv_rec => lx_taiv_rec,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
END insert_request;
PROCEDURE insert_on_acc_cm_request(p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
p_tld_id IN NUMBER,
p_credit_amount IN NUMBER,
p_credit_sty_id IN NUMBER,
p_credit_desc IN VARCHAR2,
p_credit_date IN DATE,
p_try_id IN NUMBER,
--Bug 5897792
p_transaction_source IN VARCHAR2 DEFAULT NULL,
p_source_trx_number IN VARCHAR2 DEFAULT NULL,
-- Bug 5897792
x_tai_id OUT NOCOPY NUMBER,
x_taiv_rec OUT NOCOPY taiv_rec_type,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2)IS
CURSOR c_3LevelInvoice IS
SELECT tai.set_of_books_id set_of_books_id,
tai.currency_code currency_code,
tai.ixx_id ixx_id,
--tai.customer_address_id ibt_id,
tai.irm_id irm_id,
tai.irt_id irt_id,
tai.org_id org_id,
tai.id tai_id_reverses,
tai.khr_id khr_id,
tai.legal_entity_id legal_entity_id ,
tai.date_invoiced date_invoiced,
til.id til_id_reverses,
til.kle_id kle_id,
tld.id tld_id_reverses,
tld.sty_id sty_id,
tld.til_id_details til_id_details,
tld.sel_id sel_id
FROM
okl_txd_ar_ln_dtls_b tld,
okl_txl_ar_inv_lns_b til,
okl_trx_ar_invoices_b tai
WHERE tai.id = til.tai_id
AND til.id = tld.TIL_ID_DETAILS
AND tld.id = p_tld_id;
SELECT tai.set_of_books_id set_of_books_id,
tai.currency_code currency_code,
tai.ixx_id ixx_id,
-- tai.customer_address_id ibt_id,
tai.irm_id irm_id,
tai.irt_id irt_id,
tai.org_id org_id,
tai.id tai_id_reverses,
tai.khr_id khr_id,
tai.legal_entity_id legal_entity_id ,
tai.date_invoiced date_invoiced,
til.id til_id_reverses,
til.kle_id kle_id,
til.sty_id sty_id
FROM
okl_txd_ar_ln_dtls_b tld,
okl_txl_ar_inv_lns_b til,
okl_trx_ar_invoices_b tai
WHERE tai.id = til.tai_id
AND til.id = tld.TIL_ID_DETAILS
AND tld.id = p_tld_id;
END insert_on_acc_cm_request;