[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
-- Update Pay Status
-- u_lsmv_rec Okl_Cnsld_Ar_Strms_Pub.lsmv_rec_type; -- rmunjulu R12 Billing Fixes: commented
SELECT khr.pdt_id
FROM okl_k_headers khr
WHERE khr.id = p_khr_id;
select tap.id tap_id
,tap.nettable_yn
,tap.wait_vendor_invoice_yn
,tap.ipvs_id
,tap.payment_method_code
,tap.ippt_id
,tap.pay_group_lookup_code
,tap.try_id
,tap.set_of_books_id
,tap.org_id tap_org
,tpl.khr_id
,tap.currency_code
,tap.currency_conversion_date
,tap.currency_conversion_rate
,tap.currency_conversion_type
,tap.trx_status_code
,tap.date_invoiced
,tap.date_entered
,tap.workflow_yn
,tap.invoice_type
,tap.amount tap_amount
,tap.invoice_number
,tap.invoice_category_code
,tap.vendor_invoice_number
,tap.date_gl
,tpl.id
,tpl.disbursement_basis_code
,tpl.amount
,tpl.org_id
,tpl.kle_id
,tpl.lsm_id
,tpl.sty_id
,tpl.line_number
,tpl.inv_distr_line_code
,tld.id tld_id -- rmunjulu R12 Billing Fixes: added
-- 02-NOV-2006 ANSETHUR R12B - Legal Entity
,tap.legal_entity_id
from -- okl_cnsld_ar_strms_v lsm -- rmunjulu R12 Billing Fixes: commented
okl_trx_ap_invoices_v tap
, okl_txl_ap_inv_lns_v tpl
, okl_txd_ar_ln_dtls_b tld -- rmunjulu R12 Billing Fixes: added
where tap.id = tpl.tap_id
-- and tpl.lsm_id = lsm.id -- rmunjulu R12 Billing Fixes: commented
and tpl.tld_id = tld.id -- rmunjulu R12 Billing Fixes: added
and tld.sel_id = cp_sel_id -- rmunjulu R12 Billing Fixes: changed to use TLD
and tld.pay_status_code = 'PROCESSED' -- rmunjulu R12 Billing Fixes: changed to use TLD
and tld.amount > 0 -- rmunjulu R12 Billing Fixes: changed to use TLD
and tap.trx_status_code in ('ENTERED', 'APPROVED', 'PROCESSED');
SELECT id
FROM okl_trx_types_tl
WHERE name = 'Debit Memo'
AND language= 'US';
SELECT currency_code
,currency_conversion_type
,currency_conversion_rate
,currency_conversion_date
FROM okl_k_headers_full_v
WHERE id = cp_khr_id;
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'evaluating whether to update TLD with Reversed status');
Okl_Cnsld_Ar_Strms_Pub.update_cnsld_ar_strms
(p_api_version
,p_init_msg_list
,l_return_status
,x_msg_count
,x_msg_data
,u_lsmv_rec
,r_lsmv_rec);
okl_txd_ar_ln_dtls_pub.update_txd_ar_ln_dtls
(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_tldv_rec => l_tldv_rec
,x_tldv_rec => lx_tldv_rec);
cursor l_kle_status_code_csr(cp_kle_id IN NUMBER) IS SELECT ste_code
FROM okc_k_lines_b kle,
okc_statuses_b kls
WHERE kle.id = cp_kle_id
AND kle.sts_code = kls.code;
SELECT stm.khr_id khr_id,
stm.kle_id kle_id,
TRUNC (ste.stream_element_date) stream_element_date,
ste.id sel_id,
stm.id stm_id,
stm.sty_id sty_id,
sty.name sty_name,
ste.amount,
ste.se_line_number,
ste.source_id,
ste.source_table
FROM okl_strm_elements ste,
okl_streams stm,
okl_strm_type_v sty,
okc_k_headers_b khr,
okl_k_headers khl,
okc_k_lines_b kle,
okc_statuses_b khs
WHERE trunc(ste.stream_element_date) > trunc(nvl(cp_term_date_from, ste.stream_element_date))
AND trunc(ste.stream_element_date) <= trunc(nvl(cp_term_date_to, ste.stream_element_date))
AND ste.amount <> 0
AND stm.id = ste.stm_id
AND ste.date_billed IS NOT NULL
AND stm.active_yn = 'Y'
AND stm.say_code = 'CURR'
AND sty.id = stm.sty_id
AND sty.billable_yn = 'Y'
AND khr.id = stm.khr_id
AND khr.scs_code IN ('LEASE', 'LOAN')
AND khr.sts_code IN ( 'BOOKED','EVERGREEN')
AND khr.id = cp_khr_id
AND khl.id = stm.khr_id
AND khl.deal_type IS NOT NULL
AND khs.code = khr.sts_code
AND khs.ste_code = 'ACTIVE'
AND stm.kle_id = kle.id(+)
AND nvl(stm.kle_id, -99) = nvl(cp_kle_id, nvl(stm.kle_id, -99))
AND OKL_BPD_TERMINATION_ADJ_PVT.get_kle_status_code(stm.kle_id) IN ('ACTIVE', 'TERMINATED', 'HEADER_LEVEL')
ORDER BY 1, 2, 3;
Select lnk.id link_kle_id
--lnk.cle_id link_kle_id
From okc_k_lines_b lnk,
okc_line_styles_b lnk_lse,
okc_statuses_b sts,
okc_k_items cim
Where lnk.id = cim.cle_id
and lnk.dnz_chr_id = cim.dnz_chr_id
and lnk.lse_id = lnk_lse.id
and lnk_lse.lty_code in ('LINK_FEE_ASSET','LINK_SERV_ASSET')
and sts.code = lnk.sts_code
and sts.ste_code not in ('EXPIRED','TERMINATED','CANCELLED')
and cim.jtot_object1_code = 'OKX_COVASST'
and cim.object1_id1 = to_char(p_line_id)
and cim.object1_id2 = '#';
SELECT stm.khr_id khr_id,
stm.kle_id kle_id,
TRUNC (ste.stream_element_date) stream_element_date,
ste.id sel_id,
stm.id stm_id,
stm.sty_id sty_id,
sty.name sty_name,
ste.amount,
ste.se_line_number,
ste.source_id,
ste.source_table
FROM okl_strm_elements ste,
okl_streams stm,
okl_strm_type_v sty,
okc_k_headers_b khr,
okl_k_headers khl,
okc_k_lines_b kle,
okc_statuses_b khs
WHERE trunc(ste.stream_element_date) >= trunc(nvl(cp_term_date_from, ste.stream_element_date))
AND trunc(ste.stream_element_date) <= trunc(nvl(cp_term_date_to, ste.stream_element_date))
AND ste.amount <> 0
AND stm.id = ste.stm_id
AND ste.date_billed IS NULL
AND stm.active_yn = 'Y'
AND stm.say_code = 'CURR'
AND sty.id = stm.sty_id
AND sty.billable_yn = 'Y'
AND khr.id = stm.khr_id
AND khr.scs_code IN ('LEASE', 'LOAN')
AND khr.sts_code IN ( 'BOOKED','EVERGREEN')
AND khr.id = cp_khr_id
AND khl.id = stm.khr_id
AND khl.deal_type IS NOT NULL
AND khs.code = khr.sts_code
AND khs.ste_code = 'ACTIVE'
AND stm.kle_id = kle.id(+)
AND nvl(stm.kle_id, -99) = nvl(cp_kle_id, nvl(stm.kle_id, -99))
AND OKL_BPD_TERMINATION_ADJ_PVT.get_kle_status_code(stm.kle_id) IN ('ACTIVE', 'TERMINATED', 'HEADER_LEVEL')
ORDER BY 1, 2, 3;
SELECT stm.khr_id khr_id,
stm.kle_id kle_id,
TRUNC (ste.stream_element_date) stream_element_date,
ste.id sel_id,
stm.id stm_id,
stm.sty_id sty_id,
sty.name sty_name,
ste.amount amount,
ste.se_line_number,
ste.source_id,
ste.source_table
FROM okl_strm_elements ste,
okl_streams stm,
okl_strm_type_v sty,
okc_k_headers_b khr,
okl_k_headers khl,
okc_k_lines_b kle,
okc_statuses_b khs
WHERE trunc(ste.stream_element_date) >= trunc(nvl(cp_term_date_from, ste.stream_element_date))
AND trunc(ste.stream_element_date) <= trunc(nvl(cp_term_date_to, ste.stream_element_date))
AND ste.amount <> 0
AND stm.id = ste.stm_id
AND ste.date_billed IS NULL
AND stm.active_yn = 'Y'
AND stm.say_code = 'CURR'
AND sty.id = stm.sty_id
AND sty.billable_yn = 'Y'
AND khr.id = stm.khr_id
AND khr.scs_code IN ('LEASE', 'LOAN')
AND khr.sts_code IN ( 'BOOKED','EVERGREEN')
AND khr.id = cp_khr_id
AND khl.id = stm.khr_id
AND khl.deal_type IS NOT NULL
AND khs.code = khr.sts_code
AND khs.ste_code = 'ACTIVE'
AND stm.kle_id = kle.id(+)
AND nvl(stm.kle_id, -99) = nvl(cp_kle_id, nvl(stm.kle_id, -99))
AND OKL_BPD_TERMINATION_ADJ_PVT.get_kle_status_code(stm.kle_id) IN ('ACTIVE', 'TERMINATED', 'HEADER_LEVEL')
AND exists (select 1 from okc_rule_groups_b rgp
, okc_rules_b rul
where rgp.dnz_chr_id = kle.dnz_chr_id
and rgp.cle_id = kle.id
and rgp.rgd_code = 'LAASTX'
and rgp.id = rul.rgp_id
and rul.rule_information_category = 'LAPRTX'
and rul.rule_information1 = 'Y'
and (rul.rule_information3 = 'ESTIMATED' or rul.rule_information3 = 'ESTIMATED_AND_ACTUAL')
)
AND sty.stream_type_purpose = 'ESTIMATED_PROPERTY_TAX'
ORDER BY 1, 2, 3;
SELECT chr.authoring_org_id,
chr.currency_code,
hr.set_of_books_id
-- 02-NOV-2006 ANSETHUR R12B - Legal Entity
,khr.legal_entity_id
FROM okc_k_headers_b chr,hr_operating_units hr
-- 02-NOV-2006 ANSETHUR R12B - Legal Entity
,OKL_K_HEADERS khr
WHERE chr.authoring_org_id = hr.organization_id
AND chr.id = p_chr_id
-- 02-NOV-2006 ANSETHUR R12B - Legal Entity
AND khr.id = chr.id;
SELECT id,
passthru_stream_type_id,
payout_basis,
payout_basis_formula
FROM okl_party_payment_hdr
WHERE dnz_chr_id = p_chr_id
AND cle_id = p_cle_id
--Bug# 4884423
AND passthru_term = 'BASE';