[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT prv.id1,
prv.id2,
prv.name,
prv.description
FROM okx_parties_v prv
WHERE prv.name = NVL(p_name,prv.name)
AND prv.id1 = NVL(p_id1,prv.id1)
AND prv.id2 = NVL(p_id2,prv.id2)
ORDER BY prv.name;
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.id1 = p_id1
AND vev.id2 = NVL(p_id2,vev.id2)
ORDER BY vev.NAME;
SELECT srv.ID1,
srv.ID2,
srv.NAME,
srv.DESCRIPTION
FROM OKX_SALESREPS_V srv
WHERE ((nvl(srv.ORG_ID, -99) = nvl(mo_global.get_current_org_id, -99)) or (nvl(mo_global.get_current_org_id, -99) = -99))
AND srv.ID1 = p_id1
AND srv.ID2 = NVL(p_id2,srv.ID2)
ORDER BY srv.NAME;
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_party_role_cur (p_role_code VARCHAR2, p_intent 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 jtf_objects_b job,
okc_role_sources rs
where job.object_code = rs.jtot_object_code
and nvl(job.start_date_active,sysdate) <= sysdate
and nvl(job.end_date_active,sysdate + 1) > sysdate
and rs.rle_code = p_role_code
and rs.start_date <= sysdate
and nvl(rs.end_date,sysdate+1) > sysdate
and rs.buy_or_sell = p_intent;
x_select_clause := 'NOT FOUND';
x_select_clause := jtf_party_role_rec.select_clause;
select x_where_clause || decode(x_where_clause,null,null,' AND ')||
' ID1 = '||''''||p_id1||''''||' AND '||' ID2 = '||''''||p_id2||''''
into l_where_clause
from dual;
select x_where_clause || decode(x_where_clause,null,null,' AND ')||
' NAME like '||''''||p_name||'%'||''''
into l_where_clause
from dual;
-- Updated the sql for performance fix -bug#5484903 - varangan - 25-9-06
SELECT
CPLB.OBJECT1_ID1 object1_id1,
CPLB.OBJECT1_ID2 object1_id2,
CPLB.JTOT_OBJECT1_CODE jtot_object1_code,
CPLB.RLE_CODE rle_code
FROM OKC_K_PARTY_ROLES_B CPLB,
FND_LOOKUPS FNDV
WHERE CPLB.RLE_CODE = FNDV.lookup_code
AND FNDV.lookup_type = 'OKC_ROLE'
AND CPLB.rle_code = nvl(p_role_code,CPLB.rle_code)
and nvl(CPLB.cle_id,-99999) = p_cle_id
and nvl(CPLB.chr_id,-99999) = p_chr_id
and CPLB.dnz_chr_id = decode(p_chr_id,null,CPLB.dnz_chr_id,p_dnz_chr_id)
order by rle_code;
select object1_id1,
object1_id2,
jtot_object1_code,
rle_code
from OKC_K_PARTY_ROLES_V
where rle_code = nvl(p_role_code,rle_code)
and nvl(cle_id,-99999) = p_cle_id
and nvl(chr_id,-99999) = p_chr_id
and dnz_chr_id = decode(p_chr_id,null,dnz_chr_id,p_dnz_chr_id)
order by rle_code; */
l_select_clause varchar2(2000) default null;
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,' '),' ')||' '||
'ORDER BY '||ltrim(rtrim(l_order_by_clause,' '),' ');
l_select_clause varchar2(2000) default null;
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,' '),' ')||' '||
'ORDER BY '||ltrim(rtrim(l_order_by_clause,' '),' ');
select scs_code,
rle_code
from okc_subclass_roles
where scs_code = p_scs_code
and nvl(start_date,sysdate) <= sysdate
and nvl(end_date,sysdate+1) > sysdate;
select scs_code
from OKC_K_HEADERS_V
where id = p_chr_id;
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_contact_cur (p_cro_code VARCHAR2, p_intent 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 jtf_objects_b job,
okc_contact_sources rs
where job.object_code = rs.jtot_object_code
and nvl(job.start_date_active,sysdate) <= sysdate
and nvl(job.end_date_active,sysdate + 1) > sysdate
and rs.rle_code = p_rle_code
and rs.cro_code = p_cro_code
and rs.start_date <= sysdate
and nvl(rs.end_date,sysdate+1) > sysdate
and rs.buy_or_sell = p_intent;
x_select_clause := 'NOT FOUND';
x_select_clause := jtf_contact_rec.select_clause;
select '(' || x_where_clause || ')' || decode(x_where_clause,null,null,' AND ')||
' ID1 = '||''''||p_id1||''''||' AND '||' ID2 = '||''''||p_id2||''''
into l_where_clause
from dual;
select '(' || x_where_clause || ')' || decode(x_where_clause,null,null,' AND ')||
' NAME like '||''''||p_name||'%'||''''
into l_where_clause
from dual;
l_select_clause varchar2(2000) default null;
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,' '),' ')||' '||
'ORDER BY '||ltrim(rtrim(l_order_by_clause,' '),' ');
l_select_clause VARCHAR2(1000);
select job.object_code OBJECT_CODE,
job.object_code||'.ID1 ID1, '||
job.object_code||'.ID2 ID2, '||
job.object_code||'.NAME PARTY_NAME, '||
job.object_code||'.DESCRIPTION DESCRIPTION, ' ||
''''|| job.object_code ||''''|| ' JTOT_OBJECT_CODE' SELECT_CLAUSE,
from_table FROM_CLAUSE,
where_clause WHERE_CLAUSE,
order_by_clause ORDER_BY_CLAUSE
from jtf_objects_b job,
okc_role_sources rs
where job.object_code = rs.jtot_object_code
and nvl(job.start_date_active,sysdate) <= sysdate
and nvl(job.end_date_active,sysdate + 1) > sysdate
and rs.rle_code = p_role_code
and rs.start_date <= sysdate
and nvl(rs.end_date,sysdate+1) > sysdate
and rs.buy_or_sell = p_intent;
l_select_clause := 'NOT FOUND';
l_select_clause := jtf_party_role_rec.select_clause;
l_sql_str := 'SELECT ' || l_select_clause ||' FROM '|| l_from_clause
||' WHERE '|| NVL(l_where_clause,'1=1 ')
||'ORDER BY '|| l_order_by_clause;
l_select_clause VARCHAR2(1000);
select job.object_code OBJECT_CODE,
job.object_code||'.ID1, '||
job.object_code||'.ID2, '||
job.object_code||'.NAME, '||
job.object_code||'.DESCRIPTION, ' ||
''''|| job.object_code ||''''|| ' JTOT_OBJECT_CODE' SELECT_CLAUSE,
from_table FROM_CLAUSE,
where_clause WHERE_CLAUSE,
order_by_clause ORDER_BY_CLAUSE
from jtf_objects_b job,
okc_contact_sources rs
where job.object_code = rs.jtot_object_code
and nvl(job.start_date_active,sysdate) <= sysdate
and nvl(job.end_date_active,sysdate + 1) > sysdate
and rs.rle_code = c_rle_code
and rs.cro_code = c_cro_code
and rs.start_date <= sysdate
and nvl(rs.end_date,sysdate+1) > sysdate
and rs.buy_or_sell = c_intent;
l_select_clause := 'NOT FOUND';
l_select_clause := jtf_contact_rec.select_clause;
l_sql_str := 'SELECT ' || l_select_clause ||' FROM '|| l_from_clause
||' WHERE '|| NVL(l_where_clause,'1=1 ')
||' ORDER BY '|| l_order_by_clause;