[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.inv_org_id)
OR EXISTS
(SELECT 1
FROM mtl_parameters org
WHERE org.organization_id = f.inv_org_id
AND NOT EXISTS
(SELECT 1
FROM org_access ora
WHERE org.organization_id = ora.organization_id)))';
l_stmt := 'SELECT CURRENCY,
ISC_ATTRIBUTE_2,
ISC_MEASURE_1,
org.name ISC_ATTRIBUTE_5,
cust.value ISC_ATTRIBUTE_3,
ISC_ATTRIBUTE_4,
ISC_MEASURE_2,
ISC_MEASURE_3,ISC_MEASURE_4,ISC_MEASURE_5,ISC_MEASURE_6
FROM (select (rank() over (&ORDER_BY_CLAUSE nulls last,ISC_MEASURE_2,ISC_MEASURE_1)) - 1 rnk,
customer_id,
inv_org_id,
ISC_ATTRIBUTE_2,ISC_ATTRIBUTE_4,ISC_MEASURE_1,
ISC_MEASURE_2,ISC_MEASURE_3,ISC_MEASURE_4,ISC_MEASURE_5,ISC_MEASURE_6,CURRENCY
FROM(select customer_id,
inv_org_id,
order_number ISC_ATTRIBUTE_2,
time_shipped_date_id ISC_ATTRIBUTE_4,
line_number ISC_MEASURE_1,
header_id ISC_MEASURE_2,
days_late ISC_MEASURE_3,
null ISC_MEASURE_4, -- obsolted item from DBI 5.0
null ISC_MEASURE_5, -- obsolted item from DBI 5.0
null ISC_MEASURE_6, -- obsolted item from DBI 5.0
null CURRENCY -- obsolted item from DBI 5.0
FROM ISC_DBI_FM_0003_MV f
WHERE f.time_shipped_date_id between
&BIS_CURRENT_EFFECTIVE_START_DATE and &BIS_CURRENT_ASOF_DATE
AND f.late_schedule_flag = :ISC_LATE_SCHEDULE_FLAG'
||l_org_where||l_inv_cat_where||l_item_where||l_cust_where||')) a,
FII_CUSTOMERS_V cust,
HR_ALL_ORGANIZATION_UNITS_TL org
WHERE a.customer_id = cust.id
AND 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';