[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT fii.start_date
INTO l_date
FROM fii_time_ent_year fii
WHERE (SELECT fii.start_date - 1
FROM fii_time_ent_year fii
WHERE as_of_date BETWEEN fii.start_date AND fii.end_date) BETWEEN fii.start_date AND fii.end_date;
SELECT fii.start_date
INTO l_date
FROM fii_time_ent_qtr fii
WHERE (SELECT fii.start_date - 1
FROM fii_time_ent_qtr fii
WHERE as_of_date BETWEEN fii.start_date AND fii.end_date) BETWEEN fii.start_date AND fii.end_date;
SELECT fii.start_date
INTO l_date
FROM fii_time_ent_period fii
WHERE (SELECT fii.start_date - 1
FROM fii_time_ent_period fii
WHERE as_of_date BETWEEN fii.start_date AND fii.end_date) BETWEEN fii.start_date AND fii.end_date;
SELECT SEQUENCE
INTO l_curr_year
FROM fii_time_ent_year
WHERE as_of_date BETWEEN start_date AND end_date;
SELECT start_date
INTO l_date
FROM fii_time_ent_year
WHERE SEQUENCE = l_curr_year - 3;
SELECT SEQUENCE
, ent_year_id
INTO l_curr_qtr
, l_curr_year
FROM fii_time_ent_qtr
WHERE as_of_date BETWEEN start_date AND end_date;
SELECT start_date
INTO l_date
FROM fii_time_ent_qtr
WHERE SEQUENCE = l_curr_qtr + 1
AND ent_year_id = l_curr_year - 1;
SELECT p.SEQUENCE
, q.ent_year_id
INTO l_curr_period
, l_curr_year
FROM fii_time_ent_period p
, fii_time_ent_qtr q
WHERE p.ent_qtr_id = q.ent_qtr_id
AND as_of_date BETWEEN p.start_date AND p.end_date;
SELECT start_date
INTO l_date
FROM (SELECT p.start_date
FROM fii_time_ent_period p
, fii_time_ent_qtr q
WHERE p.ent_qtr_id = q.ent_qtr_id
AND ( ( p.SEQUENCE = l_curr_period + 1
AND q.ent_year_id = l_curr_year - 1)
OR ( p.SEQUENCE = 1
AND q.ent_year_id = l_curr_year))
ORDER BY p.start_date)
WHERE ROWNUM <= 1;
/* select p.start_date
into l_date
from fii_time_ent_period p, fii_time_ent_qtr q
where p.ent_qtr_id=q.ent_qtr_id
and p.sequence=l_curr_period+1 -- temp fix for 12 points on graph else 13 points brrao modified
and q.ent_year_id=l_curr_year-1;
SELECT start_date
INTO l_week_start_date
FROM fii_time_week
WHERE as_of_date BETWEEN start_date AND end_date;
SELECT start_date
INTO l_date
FROM fii_time_week
WHERE start_date = l_week_start_date - 7 * 12;
SELECT pol.organization_id
FROM per_organization_list pol
WHERE pol.security_profile_id
= &SEC_ID ) ';
, p_selected_operating_unit IN VARCHAR2)
RETURN VARCHAR2
IS
l_global_currency_code VARCHAR2 (3);
IF (p_selected_operating_unit <> 'ALL')
THEN
IF ( p_selected_operating_unit <> l_operating_unit
OR l_operating_unit IS NULL)
THEN
SELECT currency_code
INTO l_functional_currency_code
FROM financials_system_params_all fsp
, gl_sets_of_books gsob
WHERE fsp.org_id = p_selected_operating_unit
AND fsp.set_of_books_id = gsob.set_of_books_id;
l_operating_unit := p_selected_operating_unit;
SELECT DISTINCT currency_code
INTO l_common_functional_currency
FROM financials_system_params_all fsp
, gl_sets_of_books gsob
WHERE fsp.set_of_books_id = gsob.set_of_books_id
AND fsp.org_id IN (SELECT organization_id
FROM per_organization_list
WHERE security_profile_id = l_sec_profile);
SELECT d.child_id
FROM eni_denorm_hierarchies d
WHERE d.parent_id = &ITEM+ENI_ITEM_VBH_CAT
AND item_assgn_flag = ''Y''
AND dbi_flag = ''Y''
) ';
SELECT d.parent_id
FROM eni_denorm_hierarchies d
WHERE d.top_node_flag = ''Y''
)'; */
RETURN ' fact.resource_group_id IN ( SELECT sgr2.rg_id FROM oki_rs_group_mv sgr2 WHERE sgr2.prg_id = &OKI_RG ) ';
RETURN ' fact.rg_id IN ( SELECT sgr2.rg_id FROM oki_rs_group_mv sgr2 WHERE sgr2.prg_id = &OKI_RG ) ';
RETURN ' ((fact.rg_id in (select rg_id from oki_rs_group_mv where prg_id = &OKI_RG
and denorm_level = 1) and fact.resource_id = -999)
or (fact.rg_id = &OKI_RG and fact.resource_id <> -999)) ';
THEN '(select organization_id id, name value from hr_all_organization_units_tl where language = userenv(''LANG''))'
WHEN g_sales_grp_dim
-- THEN '(SELECT rg.group_id as id , rg.group_name value from JTF_RS_GROUPS_VL rg)'
-- THEN '(SELECT rg.group_id as id , rg.group_name value from JTF_RS_GROUPS_TL rg where language = userenv(''LANG''))'
THEN 'OKI_DBI_SRM_GRP_RES_V'
WHEN g_sitem_dim
THEN 'ENI_ITEM_V'
WHEN g_prod_ctgy_dim
THEN 'OKI_ENI_ITEM_VBH_NODES_V'
WHEN g_sales_rep_dim
THEN 'OKI_DIM_SALESFORCE'
WHEN g_cncl_reason_dim
THEN 'OKI_CANCEL_STATUSES_V'
WHEN g_trm_reason_dim
THEN 'OKI_TERM_REASONS_V'
WHEN g_cust_class_dim
THEN 'FII_PARTNER_MKT_CLASS_V'
ELSE ''
END);
l_rec.mv_name := '(SELECT * FROM oki_srm_or_50_mv where ogrp_id=1 and lmarker= 1)';
l_rec.mv_name := '(SELECT * FROM oki_srm_or_50_mv where ogrp_id=0 and lmarker= 1)';
l_rec.mv_name := '(SELECT * FROM oki_srm_or_50_mv where ogrp_id=0 and lmarker= 2)';
l_rec.mv_name := '(SELECT * FROM oki_srm_or_50_mv where ogrp_id=3 and lmarker= 1)';
FUNCTION get_viewby_select_clause (
p_viewby IN VARCHAR2
, p_func_area IN VARCHAR2
, p_version IN VARCHAR2)
RETURN VARCHAR2
IS
l_directs VARCHAR2 (100);
RETURN 'SELECT decode(oset.resource_id,-999,to_char(oset.rg_id),oset.resource_id||''.''||oset.rg_id) VIEWBYID ,decode(oset.resource_id,-999,g.group_name, decode(oset.resource_id, -1, &UNASSIGNED,r.resource_name)) VIEWBY ';
RETURN 'select v.value VIEWBY
,v.id VIEWBYID ';
OR (p_dim_map(i).view_by_table = '(select organization_id id, name value from hr_all_organization_units_tl where language = userenv(''LANG''))' AND p_dim_map(i).value <> 'All'))
THEN l_ou_flag := 0;
'select '||join_column1||
' , '||sel_clause ||
' from ( ( '|| query1 ||' ) UNION ALL ('|| query2 ||' ) )'||
' GROUP BY '||join_column1;
SELECT id
INTO l_sg_id
FROM
(
SELECT id, rank() over (order by value nulls last) rnk
FROM jtf_rs_dbi_res_grp_vl
WHERE usage = 'SALES'
AND current_id = -1111
AND denorm_level = 0
)
where rnk = 1;