[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT rul.rule_information1
FROM okc_rule_groups_b rgp,
okc_rules_b rul
WHERE rgp.rgd_code = 'LAASTX'
AND RGP.ID = RUL.rgp_id
AND RUL.RULE_INFORMATION_CATEGORY = 'LAASTX'
AND RGP.CLE_ID = p_kle_id; */
SELECT CTL.NAME,
CIM.object1_id1
FROM OKC_K_LINES_B CLE1,
OKC_K_LINEs_B CLE2,
OKC_LINE_STYLES_B CLS1,
OKC_LINE_STYLES_B CLS2,
OKC_K_LINES_TL CTL,
OKC_K_ITEMS CIM
WHERE CLE1.LSE_ID = CLS1.ID
AND CLS1.LTY_CODE = 'FREE_FORM1'
AND CLE1.id = CLE2.cle_id
AND CLE2.lse_id = CLS2.id
AND CLS2.lty_code = 'FIXED_ASSET'
AND CLE1.id = CTL.id
AND CTL.LANGUAGE(+) = USERENV('LANG')
AND CIM.CLE_ID = CLE2.id
AND CIM.JTOT_OBJECT1_CODE = 'OKX_ASSET'
AND CLE1.ID = p_kle_id;
SELECT csi.install_location_id,
-- csi.location_id
csi.install_location_type_code
FROM csi_item_instances csi,
okc_k_items cim,
okc_k_lines_b inst,
okc_k_lines_b ib,
okc_line_styles_b lse
WHERE csi.instance_id = TO_NUMBER(cim.object1_id1)
AND cim.cle_id = ib.id
AND ib.cle_id = inst.id
AND inst.lse_id = lse.id
AND lse.lty_code = 'FREE_FORM2'
AND inst.cle_id = p_kle_id ;
SELECT hzp.location_id
FROM HZ_PARTY_SITES HZP
WHERE HZP.PARTY_SITE_ID = p_party_site_id;
SELECT HZP.PARTY_SITE_ID
FROM HZ_PARTY_SITES HZP,
HZ_PARTY_SITE_USES HZU
WHERE HZP.LOCATION_ID = p_location_id
AND HZP.party_site_id = HZU.PARTY_SITE_ID
AND HZU.SITE_USE_TYPE = 'INSTALL_AT' ;
SELECT
--rkuttiya modified to site use id for bug:3977770
b.site_use_id
FROM hz_cust_acct_sites_all a,
hz_cust_site_uses_all b,
hz_party_sites c
WHERE a.CUST_ACCT_SITE_ID = b.CUST_ACCT_SITE_ID
AND b.site_use_code = 'SHIP_TO'
AND a.party_site_id = c.party_site_id
AND a.cust_account_id = p_cust_acct_id
AND a.org_id = NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'),1,10)),-99)
AND c.party_site_id = p_inst_loc_id
AND c.location_id = p_loc_id;
SELECT HZA.loc_id,
HZ.postal_code
FROM HZ_LOC_ASSIGNMENTS HZA,
HZ_LOCATIONS HZ
WHERE HZ.location_id = p_location_id
AND HZ.LOCATION_ID = HZA.LOCATION_ID
AND ORG_ID = NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'),1,10)),-99);
SELECT cust_acct_id
FROM OKC_K_HEADERS_B
WHERE ID = p_khr_id;
SELECT typ.code Stream_Type,
typ.billable_yn Billable,
strm.id stream_id,
strm.transaction_number,
strm.sty_id type_id,
strm.kle_id line_id,
strm.khr_id contract_id,
selm.id stream_element_id,
selm.amount,
selm.stream_element_date
FROM okl_strm_type_b typ,
okl_streams_v strm,
okl_strm_elements_v selm
WHERE strm.sty_id = typ.id
AND strm.id = selm.stm_id
AND typ.billable_yn = 'Y'
AND typ.taxable_default_yn = 'Y'
AND strm.say_code ='CURR'
and strm.active_yn = 'Y'
and strm.purpose_code is null
and strm.khr_id = p_contract_id
and selm.stream_element_date between p_date_from and p_date_to
AND NOT EXISTS
(SELECT NULL
FROM okl_cnsld_ar_strms_b CNSLD
WHERE cnsld.sel_id = selm.id
and cnsld.receivables_invoice_id IS NOT NULL);
SELECT typ.code Stream_Type,
typ.billable_yn Billable,
selm.id stream_element_id,
strm.transaction_number,
strm.sty_id type_id,
strm.kle_id line_id,
strm.khr_id contract_id,
selm.amount,
selm.stream_element_date,
rtrh.invoice_currency_code,
rtrl.extended_amount,
rtrl.tax_rate,
rtrl.taxable_amount,
ATX.tax_code,
RTRL.SALES_TAX_ID,
rtrl.customer_trx_id,
RTRL.tax_exemption_id,
RTRL.item_exception_rate_id
FROM okl_strm_type_b typ,
okl_streams_v strm,
okl_strm_elements_v selm,
OKL_CNSLD_AR_STRMS_B CNSLD,
RA_CUSTOMER_TRX_ALL RTRH,
RA_CUSTOMER_TRX_LINES_ALL RTRL,
AR_VAT_TAX_ALL ATX
WHERE strm.khr_id = p_contract_id
AND strm.sty_id = typ.id
AND strm.id = selm.stm_id
AND typ.billable_yn = 'Y'
AND typ.taxable_default_yn = 'Y'
AND strm.say_code ='CURR'
AND strm.active_yn = 'Y'
AND strm.purpose_code is null
AND selm.id = cnsld.sel_id
AND selm.stream_element_date between p_date_from and p_date_to
AND cnsld.receivables_invoice_id = rtrh.customer_trx_id
AND rtrh.customer_trx_id = rtrl.customer_trx_id
AND RTRL.ORG_ID = NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'),1,10)),-99)
AND RTRL.VAT_TAX_ID = ATX.VAT_TAX_ID
AND rtrl.line_type = 'TAX' ;
SELECT loc_assign.loc_id location_id
FROM HZ_PARTY_SITES party_site,
HZ_LOC_ASSIGNMENTS loc_assign,
HZ_LOCATIONS loc,
HZ_CUST_ACCT_SITES_ALL acct_site,
HZ_PARTIES party,
HZ_CUST_ACCOUNTS cust_acct,
HZ_CUST_SITE_USES cust_site_uses
WHERE acct_site.party_site_id = party_site.party_site_id
AND loc.location_id = party_site.location_id
AND loc.location_id = loc_assign.location_id
AND acct_site.cust_acct_site_id = cust_site_uses.cust_acct_site_id
AND party.party_id = cust_acct.party_id
AND cust_site_uses.site_use_id = p_bill_to_site_use_id
AND cust_acct.cust_account_id = p_cust_acct_id
AND loc_assign.org_id= NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'),1,10)),-99);
SELECT fa.id
FROM okc_k_lines_b fa,
okc_line_styles_b stl,
okc_k_lines_b top_cle,
okc_line_styles_b top_stl,
okc_k_lines_b sub_cle,
okc_line_styles_b sub_stl,
okc_k_items cim
WHERE top_cle.lse_id = top_stl.id
AND top_stl.lty_code in ('SOLD_SERVICE','FEE')
AND top_cle.id = sub_cle.cle_id
AND sub_cle.lse_id = sub_stl.id
AND sub_stl.lty_code in ('LINK_SERV_ASSET','LINK FEE ASSET')
AND cim.cle_id = sub_cle.id
AND CIM.JTOT_OBJECT1_CODE = 'OKX_COVASST'
AND CIM.OBJECT1_ID1 = FA.ID
AND FA.LSE_ID = STL.ID
AND STL.LTY_CODE = 'FREE_FORM1'
AND sub_cle.id = p_kle_id;
SELECT B.LTY_CODE
FROM OKC_K_LINES_B A,
OKC_LINE_STYLES_B B
WHERE A.LSE_ID = B.ID
AND A.ID = p_kle_id;
update okl_tax_lines
set history_yn = 'Y'
where history_yn = 'N'
and khr_id = p_tax_in_rec.contract_id;
OKL_TAX_PVT.insert_row(p_api_version => l_api_version,
p_init_msg_list => 'F',
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_okl_tax_lines_v_rec => l_okl_tax_rec,
x_okl_tax_lines_v_rec => lx_tax_rec);
update okl_tax_lines
set history_yn = 'Y'
where history_yn = 'N'
and khr_id = p_tax_in_rec.contract_id;
OKL_TAX_PVT.insert_row(p_api_version => l_api_version,
p_init_msg_list => 'F',
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_okl_tax_lines_v_rec => l_okl_tax_rec,
x_okl_tax_lines_v_rec => lx_tax_rec);