The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
rgpv.ID,
rgpv.OBJECT_VERSION_NUMBER,
rgpv.SFWT_FLAG,
rgpv.RGD_CODE,
rgpv.SAT_CODE,
rgpv.RGP_TYPE,
rgpv.CLE_ID,
rgpv.CHR_ID,
rgpv.DNZ_CHR_ID,
rgpv.PARENT_RGP_ID,
rgpv.COMMENTS,
rgpv.ATTRIBUTE_CATEGORY,
rgpv.ATTRIBUTE1,
rgpv.ATTRIBUTE2,
rgpv.ATTRIBUTE3,
rgpv.ATTRIBUTE4,
rgpv.ATTRIBUTE5,
rgpv.ATTRIBUTE6,
rgpv.ATTRIBUTE7,
rgpv.ATTRIBUTE8,
rgpv.ATTRIBUTE9,
rgpv.ATTRIBUTE10,
rgpv.ATTRIBUTE11,
rgpv.ATTRIBUTE12,
rgpv.ATTRIBUTE13,
rgpv.ATTRIBUTE14,
rgpv.ATTRIBUTE15,
rgpv.CREATED_BY,
rgpv.CREATION_DATE,
rgpv.LAST_UPDATED_BY,
rgpv.LAST_UPDATE_DATE,
rgpv.LAST_UPDATE_LOGIN
FROM Okc_Rule_Groups_V rgpv
WHERE rgpv.chr_id = p_chr_id
AND rgpv.dnz_chr_id = p_chr_id
AND rgpv.cle_id is NULL
AND rgpv.RGD_CODE = decode(p_rgd_code,null,rgpv.RGD_CODE,p_rgd_code);
SELECT
rgpv.ID,
rgpv.OBJECT_VERSION_NUMBER,
rgpv.SFWT_FLAG,
rgpv.RGD_CODE,
rgpv.SAT_CODE,
rgpv.RGP_TYPE,
rgpv.CLE_ID,
rgpv.CHR_ID,
rgpv.DNZ_CHR_ID,
rgpv.PARENT_RGP_ID,
rgpv.COMMENTS,
rgpv.ATTRIBUTE_CATEGORY,
rgpv.ATTRIBUTE1,
rgpv.ATTRIBUTE2,
rgpv.ATTRIBUTE3,
rgpv.ATTRIBUTE4,
rgpv.ATTRIBUTE5,
rgpv.ATTRIBUTE6,
rgpv.ATTRIBUTE7,
rgpv.ATTRIBUTE8,
rgpv.ATTRIBUTE9,
rgpv.ATTRIBUTE10,
rgpv.ATTRIBUTE11,
rgpv.ATTRIBUTE12,
rgpv.ATTRIBUTE13,
rgpv.ATTRIBUTE14,
rgpv.ATTRIBUTE15,
rgpv.CREATED_BY,
rgpv.CREATION_DATE,
rgpv.LAST_UPDATED_BY,
rgpv.LAST_UPDATE_DATE,
rgpv.LAST_UPDATE_LOGIN
FROM Okc_Rule_Groups_V rgpv
WHERE rgpv.cle_id = p_cle_id
AND rgpv.dnz_chr_id = p_chr_id
AND rgpv.chr_id is NULL
AND rgpv.RGD_CODE = decode(p_rgd_code,null,rgpv.RGD_CODE,p_rgd_code);
select cleb.dnz_chr_id
from okc_k_lines_b cleb
where cleb.id = p_cle_id;
l_rgpv_rec.LAST_UPDATED_BY,
l_rgpv_rec.LAST_UPDATE_DATE,
l_rgpv_rec.LAST_UPDATE_LOGIN;
l_rgpv_rec.LAST_UPDATED_BY,
l_rgpv_rec.LAST_UPDATE_DATE,
l_rgpv_rec.LAST_UPDATE_LOGIN;
l_rgpv_rec.LAST_UPDATED_BY,
l_rgpv_rec.LAST_UPDATE_DATE,
l_rgpv_rec.LAST_UPDATE_LOGIN;
SELECT
ID,
OBJECT_VERSION_NUMBER,
SFWT_FLAG,
OBJECT1_ID1,
OBJECT2_ID1,
OBJECT3_ID1,
OBJECT1_ID2,
OBJECT2_ID2,
OBJECT3_ID2,
JTOT_OBJECT1_CODE,
JTOT_OBJECT2_CODE,
JTOT_OBJECT3_CODE,
DNZ_CHR_ID,
RGP_ID,
PRIORITY,
STD_TEMPLATE_YN,
COMMENTS,
WARN_YN,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
--TEXT,
RULE_INFORMATION_CATEGORY,
RULE_INFORMATION1,
RULE_INFORMATION2,
RULE_INFORMATION3,
RULE_INFORMATION4,
RULE_INFORMATION5,
RULE_INFORMATION6,
RULE_INFORMATION7,
RULE_INFORMATION8,
RULE_INFORMATION9,
RULE_INFORMATION10,
RULE_INFORMATION11,
RULE_INFORMATION12,
RULE_INFORMATION13,
RULE_INFORMATION14,
RULE_INFORMATION15,
TEMPLATE_YN,
ans_set_jtot_object_code,
ans_set_jtot_object_id1,
ans_set_jtot_object_id2,
DISPLAY_SEQUENCE
FROM Okc_Rules_V
WHERE okc_rules_v.rgp_id = p_rgp_id
AND RULE_INFORMATION_CATEGORY = decode(p_rdf_code,null,RULE_INFORMATION_CATEGORY,p_rdf_code);
l_rulv_rec.LAST_UPDATED_BY,
l_rulv_rec.LAST_UPDATE_DATE,
l_rulv_rec.LAST_UPDATE_LOGIN,
--l_rulv_rec.TEXT,
l_rulv_rec.RULE_INFORMATION_CATEGORY,
l_rulv_rec.RULE_INFORMATION1,
l_rulv_rec.RULE_INFORMATION2,
l_rulv_rec.RULE_INFORMATION3,
l_rulv_rec.RULE_INFORMATION4,
l_rulv_rec.RULE_INFORMATION5,
l_rulv_rec.RULE_INFORMATION6,
l_rulv_rec.RULE_INFORMATION7,
l_rulv_rec.RULE_INFORMATION8,
l_rulv_rec.RULE_INFORMATION9,
l_rulv_rec.RULE_INFORMATION10,
l_rulv_rec.RULE_INFORMATION11,
l_rulv_rec.RULE_INFORMATION12,
l_rulv_rec.RULE_INFORMATION13,
l_rulv_rec.RULE_INFORMATION14,
l_rulv_rec.RULE_INFORMATION15,
l_rulv_rec.TEMPLATE_YN,
l_rulv_rec.ans_set_jtot_object_code,
l_rulv_rec.ans_set_jtot_object_id1,
l_rulv_rec.ans_set_jtot_object_id2,
l_rulv_rec.DISPLAY_SEQUENCE ;
x_select OUT NOCOPY VARCHAR2) is
Cursor rule_dff_cur is
-- select dflex.descriptive_flex_context_code
-- , dflex.flex_value_set_id
-- from fnd_descr_flex_col_usage_vl dflex
-- where dflex.application_id=510
-- and dflex.descriptive_flexfield_name='OKC Rule Developer DF'
-- and dflex.descriptive_flex_context_code = p_rdf_code
-- and dflex.application_column_name = p_appl_col_name
--code added for rule striping (remove top union when finalized)
--union
select dflex.descriptive_flex_context_code
, dflex.flex_value_set_id
from fnd_descr_flex_col_usage_vl dflex,
okc_rule_defs_v rdefv
where dflex.application_id = rdefv.application_id
and dflex.descriptive_flexfield_name = rdefv.descriptive_flexfield_name
and dflex.descriptive_flex_context_code = rdefv.rule_code
and dflex.application_column_name = p_appl_col_name
and rdefv.rule_code = p_rdf_code
order by dflex.descriptive_flex_context_code;
Select validation_type
from fnd_flex_value_sets
where flex_value_set_id = p_flex_value_set_id;
SELECT fvt.id_column_name,
fvt.value_column_name,
fvt.meaning_column_name,
fvt.application_table_name,
fvt.additional_where_clause,
fvt.enabled_column_name,
fvt.start_date_column_name,
fvt.end_date_column_name
FROM fnd_flex_validation_tables fvt
WHERE fvt.flex_value_set_id = p_flex_value_set_id;
l_select_clause varchar2(2000) default null;
fnd_flex_val_api.get_independent_vset_select(p_value_set_id => rule_dff_rec.flex_value_set_id,
p_inc_id_col => 'N',
p_inc_user_where_clause => l_inc_user_where_clause,
p_user_where_clause => l_user_where_clause,
x_select => l_query_string,
x_mapping_code => l_mapping_code,
x_success => l_success);
fnd_flex_val_api.get_dependent_vset_select( p_value_set_id => rule_dff_rec.flex_value_set_id,
p_inc_id_col => 'N',
p_inc_user_where_clause => l_inc_user_where_clause,
p_user_where_clause => l_user_where_clause,
x_select => l_query_string,
x_mapping_code => l_mapping_code,
x_success => l_success);
l_select_clause := ' SELECT '||l_select_clause||' '||flex_query_t_rec.value_column_name||' , ';
l_select_clause := ' SELECT '||l_select_clause||' '||flex_query_t_rec.id_column_name||' , ';
l_select_clause := l_select_clause||' '||flex_query_t_rec.value_column_name;
select l_where_clause||' '||decode(l_where_clause,null,' ',decode(instr(ltrim(flex_query_t_rec.additional_where_clause,' '),'ORDER BY'),1,' ',' AND '))||flex_query_t_rec.additional_where_clause
into l_add_where_clause from dual;
l_query_string := rtrim(ltrim(l_select_clause,' '),' ')||' '||
rtrim(ltrim(l_from_clause,' '),' ')||' '||
rtrim(ltrim(l_where_clause,' '),' ')||' '||
rtrim(ltrim(l_order_by_clause,' '),' ');
x_select := l_query_string;
x_select OUT NOCOPY VARCHAR2) is
l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
l_select_clause Varchar2(2000) default Null;
Select job.from_table from_table,
' FROM '||job.from_table from_clause,
decode(where_clause,null,null,' WHERE ')||job.where_clause where_clause,
decode(order_by_clause,null,null,' ORDER BY ')||job.order_by_clause order_by_clause
From jtf_objects_vl job
Where job.object_code = p_object_code
And nvl(job.start_date_active,sysdate) <= sysdate
And nvl(job.end_date_active,sysdate+1) > sysdate;
Select 'Y'
From dba_tab_columns
Where table_name = p_table_name
And column_name = p_col_name
-----------------
--Bug# 3431854 :
-----------------
And owner = USER;
l_select_clause := 'SELECT ID1,ID2,NAME,DESCRIPTION';
l_select_clause := l_select_clause||','||'null';
l_select_clause := l_select_clause||','||'to_number(null)';
l_select_clause := l_select_clause||','||l_col_name;
l_query_string := ltrim(rtrim(l_select_clause,' '),' ')||' '||
ltrim(rtrim(l_from_clause,' '),' ')||' '||
ltrim(rtrim(l_where_clause,' '),' ')||' '||
ltrim(rtrim(l_order_by_clause,' '),' ');
x_select := l_query_string;
l_select Varchar2(2000) default null;
l_select := null;
x_select => l_select);
l_rulv_disp_rec.obj1_select := l_select;
l_select := null;
x_select => l_select);
l_rulv_disp_rec.obj2_select := l_select;
l_select := null;
x_select => l_select);
l_rulv_disp_rec.obj3_select := l_select;
l_select := null;
l_select := null;
x_select => l_select);
l_rulv_disp_rec.rul_info1_select := l_select;
l_select := null;
x_select => l_select);
l_rulv_disp_rec.rul_info2_select := l_select;
l_select := null;
x_select => l_select);
l_rulv_disp_rec.rul_info3_select := l_select;
l_select := null;
x_select => l_select);
l_rulv_disp_rec.rul_info4_select := l_select;
l_select := null;
x_select => l_select);
l_rulv_disp_rec.rul_info5_select := l_select;
l_select := null;
x_select => l_select);
l_rulv_disp_rec.rul_info6_select := l_select;
l_select := null;
x_select => l_select);
l_rulv_disp_rec.rul_info7_select := l_select;
l_select := null;
x_select => l_select);
l_rulv_disp_rec.rul_info8_select := l_select;
l_select := null;
x_select => l_select);
l_rulv_disp_rec.rul_info9_select := l_select;
l_select := null;
x_select => l_select);
l_rulv_disp_rec.rul_info10_select := l_select;
l_select := null;
x_select => l_select);
l_rulv_disp_rec.rul_info11_select := l_select;
l_select := null;
x_select => l_select);
l_rulv_disp_rec.rul_info12_select := l_select;
l_select := null;
x_select => l_select);
l_rulv_disp_rec.rul_info13_select := l_select;
l_select := null;
x_select => l_select);
l_rulv_disp_rec.rul_info14_select := l_select;
l_select := null;
x_select => l_select);
l_rulv_disp_rec.rul_info15_select := l_select;
x_select OUT NOCOPY VARCHAR2) is
l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
Select dflex.descriptive_flex_context_code
, dflex.application_column_name
from fnd_descr_flex_col_usage_vl dflex,
okc_rule_defs_v rdefv
where dflex.application_id = rdefv.application_id
and dflex.descriptive_flexfield_name = rdefv.descriptive_flexfield_name
and dflex.descriptive_flex_context_code = rdefv.rule_code
and dflex.form_left_prompt = p_rdf_name
and rdefv.rule_code = p_rdf_code
-- order by 1;
x_select => x_select);
x_select => x_select);
x_select => x_select);
x_select => x_select);
x_select => x_select);
x_select => x_select);
x_select => x_select);
x_select => x_select);
x_select => x_select);
x_select => x_select);
x_select => x_select);
x_select => x_select);
x_select => x_select);
x_select => x_select);
x_select => x_select);
x_select => x_select);
x_select => x_select);
x_select => x_select);
x_select OUT NOCOPY VARCHAR2) is
l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
x_select => x_select);
x_select => x_select);
x_select => x_select);
x_select => x_select);
x_select => x_select);
x_select => x_select);
x_select => x_select);
x_select => x_select);
x_select => x_select);
x_select => x_select);
x_select => x_select);
x_select => x_select);
x_select => x_select);
x_select => x_select);
x_select => x_select);
x_select => x_select);
x_select => x_select);
x_select => x_select);