[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT id,element_name
FROM okc_action_attributes_b
WHERE acn_id = p_acn_id;
SELECT aav.value
FROM okc_action_att_vals aav
,okc_condition_occurs coe
WHERE coe.id = aav.coe_id
AND coe.cnh_id = p_cnh_id
AND aav.aae_id = X
ORDER BY coe.datetime desc;
select net_reading counter_reading
from csi_counter_readings
where counter_id = p_counter_id
and nvl(disabled_flag,'N') = 'N'
order by value_timestamp desc;
/*SELECT cv.counter_reading
FROM okx_counter_values_v cv,
okx_counters_v c
WHERE cv.counter_id = c.counter_id
AND cv.counter_grp_log_id = p_counter_grp_log_id
AND (cv.counter_id = p_counter_id OR
c.created_from_counter_tmpl_id = p_counter_id);*/
SELECT element_name,format_mask
FROM okc_action_attributes_b
WHERE acn_id = p_acn_id
AND data_type = 'DATE'
AND date_of_interest_yn = 'Y'
AND rownum = 1;
select id
from okc_function_expr_params
where cnl_id = p_cnl_id;
select pdf.package_name||'.'||pdf.procedure_name function_name
from okc_condition_lines_b cnl,
okc_process_defs_b pdf
where cnl.pdf_id = pdf.id
and cnl.id = p_cnl_id
and UPPER(pdf.usage) = 'FUNCTION';
SELECT pdf.package_name||'.'||pdf.procedure_name function_name,
pdp.name parameter_name,
aae.element_name element_name,
pdp.default_value default_value,
decode(pdp.data_type,'CHAR','''',
'DATE','''',NULL) prefix_param,
fep.value fep_value
FROM okc_process_defs_b pdf,
okc_process_def_parameters_v pdp,
okc_function_expr_params fep,
okc_action_attributes_b aae
WHERE pdf.id = p_pdf_id
AND pdp.pdf_id = pdf.id
AND pdp.id = fep.pdp_id
AND fep.cnl_id = p_cnl_id
AND fep.aae_id = aae.id(+)
AND UPPER(pdf.usage) = 'FUNCTION';
SELECT c.counter_id counter_id,
cv.counter_reading counter_reading
FROM okx_counter_values_v cv, okx_counters_v c
WHERE cv.counter_id = c.counter_id
AND c.ctr_val_max_seq_no = cv.seq_no
AND c.created_from_counter_tmpl_id = p_counter_master_id;
select net_reading counter_reading
from csi_counter_readings
where counter_id = p_counter_id
and nvl(disabled_flag,'N') = 'N'
order by value_timestamp desc;
/*SELECT c.counter_id counter_id,
cv.counter_reading counter_reading
FROM okx_counter_values_v cv, okx_counters_v c
WHERE c.counter_id = cv.counter_id
AND c.ctr_val_max_seq_no = cv.seq_no
AND c.counter_id = p_counter_id;*/
SELECT left_counter_id
,right_operand
,tolerance
,start_at
FROM okc_condition_lines_b cnl
WHERE id = p_cnl_id;
SELECT 'X'
FROM okc_condition_occurs coe
WHERE coe.cnh_id = p_cnh_id;
SELECT cnl.id id,
cnl.pdf_id pdf_id,
cnl.aae_id aae_id,
aae.element_name element_name,
decode(aae.data_type,'CHAR','''',
'DATE','trunc(to_date('||'''',NULL) prefix_param_start,
decode(aae.data_type,'CHAR','''',
'DATE',''''||'))',NULL) prefix_param_end,
cnl.left_ctr_master_id left_ctr_master_id,
cnl.right_ctr_master_id right_ctr_master_id,
cnl.left_counter_id left_counter_id,
cnl.right_counter_id right_counter_id,
cnl.cnl_type cnl_type,
cnl.left_parenthesis left_parenthesis,
cnl.relational_operator relational_operator,
cnl.right_parenthesis right_parenthesis,
cnl.logical_operator logical_operator,
cnl.right_operand right_operand,
cnl.tolerance tolerance,
cnl.start_at start_at,
cnh.counter_group_id counter_group_id,
cnh.acn_id acn_id,
cnh.one_time_yn one_time_yn
FROM okc_condition_lines_b cnl,
okc_action_attributes_b aae,
okc_condition_headers_b cnh
WHERE cnl.cnh_id = p_cnh_id
AND cnl.cnh_id = cnh.id
AND cnl.aae_id = aae.id(+)
ORDER BY cnl.sortseq;
l_string := 'BEGIN select ''X'' INTO :v_result from dual where '||l_string||'; END;';
SELECT oce.id oce_id,
decode(pdf.pdf_type,'ALERT',pdf.message_name,
'SCRIPT',pdf.script_name,
'PPS',pdf.package_name||'.'||pdf.procedure_name,
'WPS',pdf.wf_name||'.'||pdf.wf_process_name,NULL) outcome,
pdf.pdf_type pdf_type,
pdf.name name,
pdp.id pdp_id,
pdp.name parameter,
decode(pdp.data_type,'CHAR','''',
'DATE','''',NULL) prefix_param,
nvl(pdp.default_value,
decode(pdp.data_type,
'CHAR' ,'OKC_API.G_MISS_CHAR',
'NUMBER','OKC_API.G_MISS_NUM',
'DATE' ,'OKC_API.G_MISS_DATE',
'OKC_API.G_MISS_CHAR')) default_value,
pdp.data_type datatype,
pdp.required_yn required_yn
FROM okc_outcomes_b oce,
okc_process_defs_v pdf,
okc_process_def_parameters_v pdp
WHERE oce.cnh_id = p_cnh_tab(x).v_id
AND oce.pdf_id = pdf.id
AND pdf.id = pdp.pdf_id(+)
AND UPPER(pdf.usage) = 'OUTCOME'
AND UPPER(oce.enabled_yn) = 'Y'
ORDER BY outcome,parameter;
SELECT oat.value value,aae.element_name element_name
FROM okc_outcome_arguments oat,
okc_action_attributes_b aae
WHERE oat.oce_id = l_oce_id
AND oat.pdp_id = l_pdp_id
AND oat.aae_id = aae.id(+);
SELECT oce.id oce_id,
decode(pdf.pdf_type,'ALERT',pdf.message_name,
'SCRIPT',pdf.script_name,
'PPS',pdf.package_name||'.'||pdf.procedure_name,
'WPS',pdf.wf_name||'.'||pdf.wf_process_name,NULL) outcome,
pdf.pdf_type pdf_type,
pdf.name name,
pdp.id pdp_id,
pdp.name parameter,
decode(pdp.data_type,'CHAR','''',
'DATE','''',NULL) prefix_param,
nvl(pdp.default_value,
decode(pdp.data_type,
'CHAR' ,'OKC_API.G_MISS_CHAR',
'NUMBER','OKC_API.G_MISS_NUM',
'DATE' ,'OKC_API.G_MISS_DATE',
'OKC_API.G_MISS_CHAR')) default_value,
pdp.data_type datatype,
pdp.required_yn required_yn
FROM okc_outcomes_b oce,
okc_process_defs_v pdf,
okc_process_def_parameters_v pdp
WHERE oce.cnh_id = p_cnh_tab(x).v_id
AND oce.pdf_id = pdf.id
AND pdf.id = pdp.pdf_id(+)
AND UPPER(pdf.usage) = 'OUTCOME'
AND UPPER(oce.enabled_yn) = 'Y'
ORDER BY outcome,parameter;
SELECT oat.value value,aae.element_name element_name
FROM okc_outcome_arguments oat,
okc_action_attributes_b aae
WHERE oat.oce_id = l_oce_id
AND oat.pdp_id = l_pdp_id
AND oat.aae_id = aae.id(+);
SELECT name,
tracked_yn,
task_owner_id,
dnz_chr_id
FROM OKC_CONDITION_HEADERS_V
WHERE id = x;
SELECT name,
tracked_yn,
task_owner_id,
dnz_chr_id
FROM OKC_CONDITION_HEADERS_V
WHERE id = x;
x_sync_outcome_tab.delete;
SELECT id
FROM okc_condition_headers_b
WHERE acn_id = p_acn_id
AND dnz_chr_id is null
AND condition_valid_yn = 'Y'
AND template_yn = 'N'
AND trunc(date_active) <= trunc(SYSDATE)
AND NVL(trunc(date_inactive),trunc(SYSDATE)) >= trunc(SYSDATE);
x_sync_outcome_tab.delete;
SELECT cnh.id id,
cnh.one_time_yn one_time_yn,
acn.counter_action_yn counter_action_yn,
cnh.jtot_object_code jtot_object_code,
cnh.counter_group_id counter_group_id
FROM okc_condition_headers_b cnh,
okc_actions_b acn
WHERE cnh.acn_id = acn.id
AND (cnh.dnz_chr_id = p_k_id or cnh.dnz_chr_id IS NULL)
AND cnh.condition_valid_yn = 'Y'
AND cnh.template_yn = 'N'
AND trunc(cnh.date_active) <= trunc(SYSDATE)
AND NVL(trunc(cnh.date_inactive),trunc(SYSDATE)) >= trunc(SYSDATE)
AND acn.id = p_acn_id;
SELECT cnh.id id,
cnh.acn_id acn_id,
cnh.one_time_yn one_time_yn
FROM okc_condition_headers_b cnh
WHERE cnh.condition_valid_yn = 'Y'
AND cnh.template_yn = 'N'
AND trunc(cnh.date_active) <= trunc(SYSDATE)
AND NVL(trunc(cnh.date_inactive),trunc(SYSDATE)) >= trunc(SYSDATE)
AND cnh.id = p_cnh_id;