The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT srv.SALESREP_ID ID1,
'#' ID2,
srv.NAME NAME,
NULL DESCRIPTION
FROM JTF_RS_SALESREPS_MO_V srv
WHERE srv.ORG_ID = mo_global.get_current_org_id
AND srv.name = p_name
AND srv.SALESREP_ID = NVL(p_id1,srv.SALESREP_ID)
AND '#' = NVL(p_id2,'#')
ORDER BY srv.NAME
--end modified abhsaxen for performance SQLID 20562570
;
SELECT pcv.ID1,
pcv.ID2,
pcv.NAME,
pcv.DESCRIPTION
FROM okx_party_contacts_v pcv
WHERE pcv.name = NVL(p_name,pcv.name)
AND pcv.ID1 = NVL(p_id1,pcv.ID1)
AND pcv.ID2 = NVL(p_id2,pcv.ID2)
ORDER BY pcv.NAME;
select prv.id1,
prv.id2,
prv.name,
prv.description
from okx_parties_v prv
where prv.name = p_name
and prv.id1 = nvl(p_id1,prv.id1)
and prv.id2 = nvl(p_id2,prv.id2)
order by prv.name
--end modified abhsaxen for performance SQLID 20562584
;
SELECT ord.id1,
ord.id2,
ord.name,
ord.description
FROM okx_organization_defs_v ord
WHERE ord.organization_type = 'OPERATING_UNIT'
AND ord.information_type = 'Operating Unit Information'
AND ord.name = NVL(p_name,ord.name)
AND ord.id1 = NVL(p_id1,ord.id1)
AND ord.id2 = NVL(p_id2,ord.id2)
ORDER BY ord.NAME;
SELECT vev.id1,
vev.id2,
vev.name,
vev.description
FROM okx_vendors_v vev
WHERE vev.name = p_name
AND vev.id1 = NVL(p_id1,vev.id1)
AND vev.id2 = NVL(p_id2,vev.id2)
ORDER BY vev.NAME
--end modified abhsaxen for performance SQLID 20562594
;
SELECT ssv.id1,
ssv.id2,
ssv.name,
ssv.description
FROM okl_strmtyp_source_v ssv
WHERE ssv.status = 'A'
AND ssv.name = NVL(p_name,ssv.name)
AND ssv.id1 = NVL(p_id1,ssv.id1)
AND ssv.id2 = NVL(p_id2,ssv.id2)
ORDER BY ssv.name;
select ulvb.id id1,
'#' id2,
ulv.name,
ulv.item_description description
from okc_k_lines_b ulvb,
okc_k_lines_tl ulv
where ulv.name = p_name
and ulvb.id = nvl(p_id1,ulvb.id)
and '#' = nvl(p_id2,'#')
and ulvb.id = ulv.id
and ulv.language =USERENV('LANG')
order by ulv.name
--end modified abhsaxen for performance SQLID 20562604
;
select asv.id1,
asv.id2,
asv.name,
asv.description
from okx_assets_v asv
where asv.name = p_name
and asv.id1 = nvl(p_id1,asv.id1)
and asv.id2 = nvl(p_id2,asv.id2)
order by asv.name
--end modified abhsaxen for performance SQLID 20562609
;
select cas.id1,
cas.id2,
cas.name,
cas.description
from okx_covered_asset_v cas
where cas.name = p_name
and cas.id1 = nvl(p_id1,cas.id1)
and cas.id2 = nvl(p_id2,cas.id2)
order by cas.name
--end modified abhsaxen for performance SQLID 20562614
;
select itv.id1,
itv.id2,
itv.name,
itv.description
from okx_install_items_v itv
where itv.name = p_name
and itv.id1 = nvl(p_id1,itv.id1)
and itv.id2 = nvl(p_id2,itv.id2)
order by itv.name
--end modified abhsaxen for performance SQLID 20562621
;
SELECT cnt.id1,
cnt.id2,
cnt.name,
cnt.description
FROM OKX_CONTRACTS_V cnt
WHERE cnt.SCS_CODE IN ('LEASE','LOAN')
AND NVL(cnt.ORG_ID, -99) = mo_global.get_current_org_id
AND cnt.name = NVL(p_name,cnt.name)
AND cnt.id1 = NVL(p_id1,cnt.id1)
AND cnt.id2 = NVL(p_id2,cnt.id2)
ORDER BY cnt.NAME;
SELECT syi.id1,
syi.id2,
syi.name,
syi.description
FROM OKX_SYSTEM_ITEMS_V syi
WHERE syi.VENDOR_WARRANTY_FLAG='N'
AND syi.SERVICE_ITEM_FLAG='Y'
AND syi.ORGANIZATION_ID = SYS_CONTEXT('OKC_CONTEXT','ORGANIZATION_ID')
AND syi.name = NVL(p_name,syi.name)
AND syi.id1 = NVL(p_id1,syi.id1)
AND syi.id2 = NVL(p_id2,syi.id2)
ORDER BY syi.NAME;
SELECT syi.id1,
syi.id2,
syi.name,
syi.description
FROM OKX_SYSTEM_ITEMS_V syi
WHERE syi.ORGANIZATION_ID = SYS_CONTEXT('OKC_CONTEXT','ORGANIZATION_ID')
AND syi.name = NVL(p_name,syi.name)
AND syi.id1 = NVL(p_id1,syi.id1)
AND syi.id2 = NVL(p_id2,syi.id2)
ORDER BY syi.NAME;
select a.attribute_label_long
from ak_region_items ri, ak_regions r, ak_attributes_vl a
where ri.region_code = r.region_code
and ri.region_application_id = r.region_application_id
and ri.attribute_code = a.attribute_code
and ri.attribute_application_id = a.attribute_application_id
and ri.region_code = p_ak_region
and ri.attribute_code = p_ak_attribute
--end modified abhsaxen for performance SQLID 20562645
;
select fnd.meaning
from okc_subclass_roles sur,
okc_k_headers_b chr,
fnd_lookup_values fnd
where fnd.lookup_code = sur.rle_code
and sur.rle_code = p_rle_code
and fnd.lookup_type = 'OKC_ROLE'
and fnd.language = userenv('LANG')
and sur.scs_code = chr.scs_code
and chr.id = p_chr_id
and nvl(sur.start_date,sysdate) <= sysdate
and nvl(sur.end_date,sysdate+1) > sysdate;
x_select_clause OUT NOCOPY VARCHAR2,
x_from_clause OUT NOCOPY VARCHAR2,
x_where_clause OUT NOCOPY VARCHAR2,
x_order_by_clause OUT NOCOPY VARCHAR2,
x_object_code OUT NOCOPY VARCHAR2) is
CURSOR jtf_rule_cur (p_chr_id NUMBER, p_rgd_code VARCHAR2, p_rdf_code VARCHAR2) is
select job.object_code OBJECT_CODE,job.object_code||'.ID1, '||job.object_code||'.ID2, '||
job.object_code||'.NAME, '||job.object_code||'.DESCRIPTION ' SELECT_CLAUSE,
from_table FROM_CLAUSE,where_clause WHERE_CLAUSE,order_by_clause ORDER_BY_CLAUSE
from okc_k_headers_b chr,
okc_subclass_rg_defs rgdfsrc,
OKC_RULE_DEF_SOURCES rdfsrc,
jtf_objects_b job
where job.object_code = rdfsrc.jtot_object_code
and nvl(job.start_date_active,sysdate) <= sysdate
and nvl(job.end_date_active,sysdate + 1) > sysdate
and chr.id = p_chr_id
and chr.scs_code = rgdfsrc.scs_code
and rgdfsrc.rgd_code = p_rgd_code -- 'LACAN'
and rdfsrc.rgr_rgd_code = p_rgd_code -- 'LACAN'
and rdfsrc.rgr_rdf_code = p_rdf_code -- 'CAN'
and chr.buy_or_sell = rdfsrc.buy_or_sell
and rdfsrc.object_id_number = 1
and nvl(rgdfsrc.start_date,sysdate) <= sysdate
and nvl(rgdfsrc.end_date,sysdate + 1) > sysdate
and nvl(rdfsrc.start_date,sysdate) <= sysdate
and nvl(rdfsrc.end_date,sysdate + 1) > sysdate;
x_select_clause := null;
x_select_clause := jtf_rule_rec.select_clause;
select x_where_clause || decode(x_where_clause,null,null,' AND ')||
' DESCRIPTION like :name'
into l_where_clause
from dual;
select x_where_clause || decode(x_where_clause,null,null,' AND ')||
' ID1 = '||''''||p_id1||''''||' AND '||' ID2 = '||''''||p_id2||''''
into l_where_clause
from dual;
l_select_clause varchar2(2000) default null;
select count(1)
from okc_rule_groups_v rgp, okc_rules_v rul
where rgp.id = rul.rgp_id
and rgp.rgd_code = p_rgd_code
and rul.rule_information_category = p_rdf_code
and rgp.dnz_chr_id = p_chr_id
and rgp.chr_id = p_chr_id
and rul.dnz_chr_id = p_chr_id
and rul.object1_id1 = p_id1
and rul.object1_id2 = p_id2;
x_select_clause => l_select_clause ,
x_from_clause => l_from_clause ,
x_where_clause => l_where_clause ,
x_order_by_clause => l_order_by_clause ,
x_object_code => l_object_code);
l_query_string := 'SELECT '||ltrim(rtrim(l_select_clause,' '),' ')||' '||
'FROM '||ltrim(rtrim(l_from_clause,' '),' ')||' '||
'WHERE '||ltrim(rtrim(l_where_clause,' '),' ');
SELECT 1
FROM OKL_TRX_AP_INVOICES_B
WHERE KHR_ID = p_khr_id
AND FUNDING_TYPE_CODE IS NOT NULL
AND TRX_STATUS_CODE <> 'CANCELED';
SELECT 1
FROM OKL_TRX_CSH_RECEIPT_B A,
OKL_TXL_RCPT_APPS_B B
WHERE A.ID = B.RCT_ID_DETAILS
AND A.RECEIPT_TYPE = 'ADV'
AND B.KHR_ID = p_khr_id;
SELECT 1
FROM OKL_INS_POLICIES_B
WHERE KHR_ID =p_khr_id;
l_select_clause varchar2(2000) default null;
select count(1)
from okc_rule_groups_v rgp, okc_rules_v rul
where rgp.id = rul.rgp_id
and rgp.rgd_code = p_rgd_code
and rul.rule_information_category = p_rdf_code
and rgp.dnz_chr_id = p_chr_id
and rgp.chr_id = p_chr_id
and rul.dnz_chr_id = p_chr_id
and rul.object1_id1 = p_id1
and rul.object1_id2 = p_id2;
l_select_clause varchar2(2000) default null;
select count(1)
from okc_k_party_roles_B
where dnz_chr_id = p_chr_id
and chr_id = p_chr_id
and rle_code = p_rle_code
and object1_id1 = p_id1
and object1_id2 = p_id2
--end modified abhsaxen for performance SQLID 20562697
;
SELECT rle_code, object1_id1, object1_id2
FROM okc_k_party_roles_v
WHERE id = p_cpl_id;
l_select_clause varchar2(2000) default null;
l_select_clause varchar2(2000) default null;
SELECT lty_code
FROM okc_line_styles_b lse,
okc_k_lines_b cle
WHERE lse.lse_parent_id = cle.lse_id
AND cle.id = p_cle_id
AND cle.chr_id = p_chr_id;
l_select_clause varchar2(2000) default null;
select count(1)
from okc_k_items cim
, okc_k_lines_b cle
, okc_line_style_sources lss
, okc_line_styles_b lse
where nvl(lss.start_date,sysdate) <= sysdate
and nvl(lss.end_date,sysdate + 1) > sysdate
and lse.id = lss.lse_id
and cle.lse_id = lse.id
and cle.id = cim.cle_id
and cim.object1_id1 = p_id1
and cim.object1_id2 = p_id2
and cim.chr_id = p_chr_id
and cim.dnz_chr_id = p_chr_id
and lse.lty_code = p_lty_code;
SELECT lse.lty_code, cim.object1_id1, cim.object1_id2
from okc_k_items cim
, okc_k_lines_b cle
, okc_line_style_sources lss
, okc_line_styles_b lse
where nvl(lss.start_date,sysdate) <= sysdate
and nvl(lss.end_date,sysdate + 1) > sysdate
and lse.id = lss.lse_id
and cle.lse_id = lse.id
and cle.id = cim.cle_id
and cim.chr_id = p_chr_id
and cim.dnz_chr_id = p_chr_id
and cle.id = p_cle_id;
l_select_clause varchar2(2000) default null;
select count(1)
from okc_k_items cim
, okc_k_lines_b cle
, okc_line_style_sources lss
, okc_line_styles_b lse
where nvl(lss.start_date,sysdate) <= sysdate
and nvl(lss.end_date,sysdate + 1) > sysdate
and lse.id = lss.lse_id
and cle.lse_id = lse.id
and cle.id = cim.cle_id
and cim.object1_id1 = p_id1
and cim.object1_id2 = p_id2
and cim.chr_id = p_chr_id
and cim.dnz_chr_id = p_chr_id
and lse.lty_code = p_lty_code;
SELECT lse.lty_code, cim.object1_id1, cim.object1_id2
from okc_k_items cim
, okc_k_lines_b cle
, okc_line_style_sources lss
, okc_line_styles_b lse
where nvl(lss.start_date,sysdate) <= sysdate
and nvl(lss.end_date,sysdate + 1) > sysdate
and lse.id = lss.lse_id
and cle.lse_id = lse.id
and cle.id = cim.cle_id
and cim.chr_id = p_chr_id
and cim.dnz_chr_id = p_chr_id
and cle.id = p_cle_id;
select cl.id, cl.contract_number
from okc_governances gvr,
okc_k_headers_b chr,
okc_k_headers_b cl,
okl_k_headers khr
where chr.id = gvr.chr_id
and chr.id = gvr.dnz_chr_id
and gvr.cle_id is null
and gvr.chr_id_referred = cl.id
and cl.id = khr.id
and cl.scs_code = 'CREDITLINE_CONTRACT'
and chr.id = p_chr_id;
select 'Y'
from okc_governances gvr,
okc_k_headers_b mla,
okc_k_headers_b cl,
okl_k_headers khr
where mla.id = gvr.chr_id
and mla.id = gvr.dnz_chr_id
and gvr.cle_id is null
and gvr.chr_id_referred = cl.id
and cl.id = khr.id
and cl.scs_code = 'CREDITLINE_CONTRACT'
and mla.contract_number = p_mla_no;
* select cl.id, mla.contract_number, khr.revolving_credit_yn
* from okc_governances gvr,
* okc_k_headers_b mla,
* okc_k_headers_b cl,
* okl_k_headers khr
* where mla.id = gvr.chr_id
* and mla.id = gvr.dnz_chr_id
* and gvr.cle_id is null
* and gvr.chr_id_referred = cl.id
* and cl.id = khr.id
* and cl.scs_code = 'CREDITLINE_CONTRACT'
* and exists ( select 1
* from okc_k_headers_b chr,
* okc_governances mla_gvr
* where chr.id = mla_gvr.chr_id
* and chr.id = mla_gvr.dnz_chr_id
* and mla_gvr.cle_id is null
* and mla_gvr.chr_id_referred = mla.id
* and chr.id = p_chr_id
* );
select cl.id, mla.contract_number, khr.revolving_credit_yn
from okc_governances gvr,
okc_k_headers_b mla,
okc_k_headers_b cl,
okl_k_headers khr,
okc_governances mla_gvr
where mla.id = gvr.chr_id
and mla.id = gvr.dnz_chr_id
and gvr.cle_id is null
and gvr.chr_id_referred = cl.id
and cl.id = khr.id
and cl.scs_code = 'CREDITLINE_CONTRACT'
and mla_gvr.dnz_chr_id = p_chr_id -- contract id
and mla_gvr.cle_id is null
and mla.id = mla_gvr.chr_id_referred
and mla.scs_code = 'MASTER_LEASE';
select 'Y'
from okl_trx_ap_invoices_b ap
where ap.khr_id = p_chr_id
and ap.funding_type_code is not null
and ap.trx_status_code in ('APPROVED', 'PROCESSED');
select khr.revolving_credit_yn
from okc_k_headers_b cl1,
okl_k_headers khr
where cl1.scs_code = 'CREDITLINE_CONTRACT'
and khr.id = cl1.id
and cl1.contract_number = l_cl_no;
select khr.revolving_credit_yn
from okc_governances gvr,
okc_k_headers_b mla,
okc_k_headers_b cl,
okl_k_headers khr
where mla.id = gvr.chr_id
and mla.id = gvr.dnz_chr_id
and gvr.cle_id is null
and gvr.chr_id_referred = cl.id
and cl.id = khr.id
and cl.scs_code = 'CREDITLINE_CONTRACT'
and mla.contract_number = p_mla_no;
select id
from okl_k_headers_full_v
where contract_number = p_k_no;
select ca.id1
from okx_customer_accounts_v ca, okx_parties_v p
where p.id1 = ca.party_id
and ca.description = p_cust_acc_id1
and p.name = p_name;
select id, description
from OKL_PRODUCTS_V
where name = p_product_name
and nvl(from_date,p_start_date) <= p_start_date
and nvl(to_date,p_start_date+1) > p_start_date;
select id
from OKL_k_headers_full_V
where contract_number = p_mla_no
and scs_code = 'MASTER_LEASE'
and STS_CODE = 'ACTIVE'
and TEMPLATE_YN = 'N'
and BUY_OR_SELL = 'S';
select id
from OKL_k_headers_full_V prg_hdr
where contract_number = p_program_no
and scs_code = 'PROGRAM'
and nvl(TEMPLATE_YN, 'N') = 'N'
and sts_code = 'ACTIVE'
and exists (select 1 from okc_k_headers_b
where id = p_chr_id
and authoring_org_id = prg_hdr.authoring_org_id);
select id, revolving_credit_yn
from okl_k_hdr_crdtln_uv
where contract_number = p_credit_line_no
and currency_code = p_curr_code
and end_date >= p_start_date
and cust_name = p_customer_name
and cust_acc_number = p_customer_acc_name;
select CURRENCY_CODE
from okl_la_currencies_uv
where CURRENCY_CODE = p_currency_code;
select chr.orig_system_source_code, chr.cust_acct_id
from OKC_K_HEADERS_B chr
where chr.id = p_chr_id;
select object1_id1
from okc_k_party_roles_b
where rle_code = 'LESSEE'
and dnz_chr_id = p_chr_id
and chr_id = p_chr_id;
select 'Y'
from okc_k_lines_b cle,
okl_k_lines kle
where cle.id = kle.id
and cle.dnz_chr_id = p_chr_id
and cle.chr_id = p_chr_id
and kle.fee_type = 'ROLLOVER';
SELECT chrb.template_yn,
khr.template_type_code
FROM okc_k_headers_b chrb,
okl_k_headers khr
WHERE chrb.id = khr.id
AND chrb.id = p_chr_id;
select '1'
From OKX_ORGANIZATION_DEFS_V OKX_OPERUNIT
WHERE OKX_OPERUNIT.ORGANIZATION_TYPE = 'OPERATING_UNIT' AND
OKX_OPERUNIT.INFORMATION_TYPE = 'Operating Unit Information'
AND ID1 = p_id1
AND ID2 = p_id2;
select '1'
from OKX_VENDORS_V OKX_VENDOR
WHERE ID1 = p_id1
AND ID2 = p_id2;
select '1'
FROM OKX_PARTIES_V OKX_PARTY
WHERE ID1 = p_id1
AND ID2 = p_id2;
select '1' from
OKX_SALESREPS_V OKX_SALEPERS
WHERE
((nvl(OKX_SALEPERS.ORG_ID, -99) = nvl(mo_global.get_current_org_id, -99))
or (nvl(mo_global.get_current_org_id, -99) = -99))
AND ID1 = p_id1
AND ID2 = p_id2;
select '1' from
OKX_PARTY_CONTACTS_V OKX_PCONTACT
WHERE ID1 = p_id1
AND ID2 = p_id2;
SELECT '1'
from OKL_STRMTYP_SOURCE_V OKL_STRMTYP
where OKL_STRMTYP.STATUS = 'A'
AND ID1 = p_id1
AND ID2 = p_id2;
SELECT '1'
from OKL_USAGE_LINES_V OKL_USAGE
WHERE ID1 = p_id1
AND ID2 = p_id2;
SELECT '1'
from OKX_ASSETS_V OKX_ASSET
WHERE ID1 = p_id1
AND ID2 = p_id2;
SELECT '1'
from OKX_COVERED_ASSET_V OKX_COVASST
where OKX_COVASST.OKC_LINE_STATUS NOT IN ('EXPIRED','TERMINATED','CANCELLED')
AND ID1 = p_id1
AND ID2 = p_id2;
SELECT '1'
from OKX_INSTALL_ITEMS_V OKX_IB_ITEM
WHERE ID1 = p_id1
AND ID2 = p_id2;
SELECT '1'
from OKX_CONTRACTS_V OKX_LEASE
where OKX_LEASE.SCS_CODE IN ('LEASE','LOAN') AND NVL(OKX_LEASE.ORG_ID, -99) = mo_global.get_current_org_id
AND ID1 = p_id1
AND ID2 = p_id2;
SELECT '1'
from OKX_SYSTEM_ITEMS_V OKX_SERVICE
where OKX_SERVICE.VENDOR_WARRANTY_FLAG='N' AND OKX_SERVICE.SERVICE_ITEM_FLAG='Y' AND OKX_SERVICE.ORGANIZATION_ID = SYS_CONTEXT('OKC_CONTEXT','ORGANIZATION_ID')
AND ID1 = p_id1
AND ID2 = p_id2;
SELECT '1'
from OKX_SYSTEM_ITEMS_V OKX_SYSITEM
where
-- 4374085
-- OKX_SYSITEM.ORGANIZATION_ID = SYS_CONTEXT('OKC_CONTEXT','ORGANIZATION_ID')
--AND
ID1 = p_id1
AND ID2 = p_id2;
SELECT '1'
FROM OKL_I_POLICIES_V
WHERE ID1 = p_id1
AND ID2 = p_id2;
select gvr.id
from okc_governances gvr,
okc_k_headers_b chr,
okc_k_headers_b cl
where chr.id = gvr.chr_id
and chr.id = gvr.dnz_chr_id
and gvr.cle_id is null
and gvr.chr_id_referred = cl.id
and cl.scs_code = 'CREDITLINE_CONTRACT'
and chr.id = p_chr_id;
select gvr.id
from okc_governances gvr,
okc_k_headers_b chr,
okc_k_headers_b mla
where chr.id = gvr.chr_id
and chr.id = gvr.dnz_chr_id
and gvr.cle_id is null
and gvr.chr_id_referred = mla.id
and mla.scs_code = 'MASTER_LEASE'
and chr.id = p_chr_id
and exists (select 1
from okc_governances cl_gvr,
okc_k_headers_b cl
where cl_gvr.chr_id = mla.id
and cl_gvr.cle_id is null
and cl_gvr.chr_id_referred = cl.id
and cl.scs_code = 'CREDITLINE_CONTRACT'
);
select chr.deal_type
from okl_k_headers chr
where chr.id = p_chr_id;
select cl.contract_number
from okc_governances gvr,
okc_k_headers_b chr,
okc_k_headers_b cl
where chr.id = gvr.chr_id
and chr.id = gvr.dnz_chr_id
and gvr.cle_id is null
and gvr.chr_id_referred = cl.id
and cl.scs_code = 'CREDITLINE_CONTRACT'
and chr.id = p_chr_id;
select mla.contract_number
from okc_governances gvr,
okc_k_headers_b chr,
okc_k_headers_b mla
where chr.id = gvr.chr_id
and chr.id = gvr.dnz_chr_id
and gvr.cle_id is null
and gvr.chr_id_referred = mla.id
and mla.scs_code = 'MASTER_LEASE'
and chr.id = p_chr_id;