[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
(SELECT 1
FROM org_access o
WHERE o.responsibility_id = fnd_global.resp_id
AND o.resp_application_id = fnd_global.resp_appl_id
AND o.organization_id = f.organization_id)
OR EXISTS
(SELECT 1
FROM mtl_parameters org
WHERE org.organization_id = f.organization_id
AND NOT EXISTS
(SELECT 1
FROM org_access ora
WHERE org.organization_id = ora.organization_id)))';
SELECT 0 VIEWBY,
0 VIEWBYID,
0 ISC_ATTRIBUTE_1,
0 ISC_MEASURE_1,
0 ISC_MEASURE_2,
0 ISC_MEASURE_3,
0 ISC_MEASURE_4,
0 ISC_MEASURE_5
FROM dual
WHERE 1 = 2 /* PLAN_SNAPSHOT dimension has not been populated */';
SELECT items.value VIEWBY,
items.id VIEWBYID,
items.description ISC_ATTRIBUTE_1, -- Description
'||l_outer_sql||'
FROM (SELECT (rank() over (&ORDER_BY_CLAUSE NULLS LAST,item_id))-1 RNK,
item_id,
'||l_outer_sql||'
FROM (SELECT item_id,
'||l_formula_sql||'
FROM (SELECT f.item_id ITEM_ID,
'||l_inner_sql||'
GROUP BY f.item_id) c)'
||l_row_filter||'
) a,
ENI_ITEM_ORG_V items
WHERE a.item_id = items.id
AND ((a.rnk between &START_INDEX and &END_INDEX) OR (&END_INDEX = -1))
ORDER BY rnk';
SELECT org.name VIEWBY,
org.organization_id VIEWBYID,
null ISC_ATTRIBUTE_1, -- Description
'||l_outer_sql||'
FROM (SELECT (rank() over (&ORDER_BY_CLAUSE NULLS LAST,organization_id))-1 RNK,
organization_id,
'||l_outer_sql||'
FROM (SELECT organization_id,
'||l_formula_sql||'
FROM (SELECT f.organization_id ORGANIZATION_ID,
'||l_inner_sql||'
GROUP BY f.organization_id) c)'
||l_row_filter||'
) a,
HR_ALL_ORGANIZATION_UNITS_TL org
WHERE org.organization_id = a.organization_id
AND org.language = :ISC_LANG
AND ((a.rnk between &START_INDEX and &END_INDEX) OR (&END_INDEX = -1))
ORDER BY rnk';
SELECT eni.value VIEWBY,
eni.id VIEWBYID,
null ISC_ATTRIBUTE_1, -- Description
'||l_outer_sql||'
FROM (SELECT (rank() over (&ORDER_BY_CLAUSE NULLS LAST,item_category_id))-1 RNK,
item_category_id,
'||l_outer_sql||'
FROM (SELECT item_category_id,
'||l_formula_sql||'
FROM (SELECT f.item_category_id ITEM_CATEGORY_ID,
'||l_inner_sql||'
GROUP BY f.item_category_id) c)'
||l_row_filter||'
) a,
ENI_ITEM_INV_CAT_V eni
WHERE a.item_category_id = eni.id
AND ((a.rnk between &START_INDEX and &END_INDEX) OR (&END_INDEX = -1))
ORDER BY rnk';
SELECT decode( sup.value, NULL,
fnd_message.get_string(''POA'', ''POA_DBI_APL_UNASSIGNED''),
sup.value) VIEWBY,
sup.id VIEWBYID,
null ISC_ATTRIBUTE_1, -- Description
'||l_outer_sql||'
FROM (SELECT (rank() over (&ORDER_BY_CLAUSE NULLS LAST,supplier_id))-1 RNK,
supplier_id,
'||l_outer_sql||'
FROM (SELECT supplier_id,
'||l_formula_sql||'
FROM (SELECT f.sr_supplier_id SUPPLIER_ID,
'||l_inner_sql||'
GROUP BY f.sr_supplier_id) c)'
||l_row_filter||'
) a,
POA_SUPPLIERS_V sup
WHERE a.supplier_id = sup.id(+)
AND ((a.rnk between &START_INDEX and &END_INDEX) OR (&END_INDEX = -1))
ORDER BY rnk';