[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 = mv.inv_org_id)
OR EXISTS
(SELECT 1
FROM mtl_parameters org
WHERE org.organization_id = mv.inv_org_id
AND NOT EXISTS
(SELECT 1
FROM org_access ora
WHERE org.organization_id = ora.organization_id)))';
SELECT 1
FROM ISC_DBI_FM_0007_MV mv
WHERE mv.time_snapshot_date_id = :l_as_of_date
AND rownum = 1 ';
SELECT 1
FROM ISC_DBI_FM_0007_MV mv
WHERE mv.time_snapshot_date_id BETWEEN :l_effective_start_date
AND :l_as_of_date
AND rownum = 1 ';
SELECT 0 VIEWBY,
0 VIEWBYID,
0 ISC_ATTRIBUTE_1, -- Description
0 ISC_ATTRIBUTE_2, -- UOM
0 ISC_MEASURE_1, -- Backordered Quantity
0 ISC_MEASURE_2, -- Backordered Lines
0 ISC_MEASURE_3, -- Backordered Lines - prior
0 ISC_MEASURE_4, -- (Backordered Lines) Change
0 ISC_MEASURE_5, -- Backordered Items
0 ISC_MEASURE_6, -- Backordered Items - prior
0 ISC_MEASURE_7, -- (Backordered Items) Change
0 ISC_MEASURE_8, -- Grand Total - Backordered Lines
0 ISC_MEASURE_9, -- Grand Total - (Backordered Lines) Change
0 ISC_MEASURE_10, -- Grand Total - Backordered Items
0 ISC_MEASURE_11 -- Grand Total - (Backordered Items) Change
FROM dual
WHERE 1 = 2 /* No snapshot has been taken during this period */';
FROM (SELECT max(time_snapshot_date_id) DAY
FROM ISC_DBI_FM_0007_MV mv
WHERE mv.time_snapshot_date_id BETWEEN &BIS_CURRENT_EFFECTIVE_START_DATE
AND &BIS_CURRENT_ASOF_DATE
) a,
(SELECT max(time_snapshot_date_id) DAY
FROM ISC_DBI_FM_0007_MV mv
WHERE mv.time_snapshot_date_id BETWEEN &BIS_PREVIOUS_EFFECTIVE_START_DATE
AND &BIS_PREVIOUS_ASOF_DATE
) b,
ISC_DBI_FM_0007_MV mv
WHERE mv.time_snapshot_date_id IN (a.day, b.day)';
SELECT cust.value VIEWBY,
cust.id VIEWBYID,
null ISC_ATTRIBUTE_1, -- Description
null ISC_ATTRIBUTE_2, -- UOM
'||l_outer_sql||'
FROM (SELECT (rank() over (&ORDER_BY_CLAUSE NULLS LAST,customer_id))-1 rnk,
customer_id,
'||l_outer_sql||'
FROM (SELECT customer_id,
'||l_formula_sql||'
FROM (SELECT mv.customer_id CUSTOMER_ID,
'||l_inner_sql||'
GROUP BY mv.customer_id) c)) a,
FII_CUSTOMERS_V cust
WHERE a.customer_id = cust.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
null ISC_ATTRIBUTE_2, -- UOM
'||l_outer_sql||'
FROM (SELECT (rank() over (&ORDER_BY_CLAUSE NULLS LAST,inv_org_id))-1 rnk,
inv_org_id,
'||l_outer_sql||'
FROM (SELECT inv_org_id,
'||l_formula_sql||'
FROM (SELECT mv.inv_org_id INV_ORG_ID,
'||l_inner_sql||'
GROUP BY mv.inv_org_id) c)) a,
HR_ALL_ORGANIZATION_UNITS_TL org
WHERE a.inv_org_id = org.organization_id
AND org.language = :ISC_LANG
AND ((a.rnk between &START_INDEX and &END_INDEX) OR (&END_INDEX = -1))
ORDER BY rnk';
SELECT items.value VIEWBY,
items.id VIEWBYID,
items.description ISC_ATTRIBUTE_1, -- Description
mtl.unit_of_measure ISC_ATTRIBUTE_2, -- UOM
'||l_outer_sql||'
FROM (SELECT (rank() over (&ORDER_BY_CLAUSE NULLS LAST,item_id))-1 rnk,
item_id,
uom,
'||l_outer_sql||'
FROM (SELECT item_id,
uom,
'||l_formula_sql||'
FROM (SELECT mv.item_id ITEM_ID,
mv.uom UOM,
'||l_inner_sql||'
GROUP BY mv.item_id, mv.uom) c)) a,
ENI_ITEM_ORG_V items,
MTL_UNITS_OF_MEASURE_TL mtl
WHERE a.item_id = items.id
AND a.uom = mtl.uom_code
AND mtl.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
null ISC_ATTRIBUTE_2, -- UOM
'||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 mv.item_category_id ITEM_CATEGORY_ID,
'||l_inner_sql||'
GROUP BY mv.item_category_id) c)) 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';