[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT NULL AS VIEWBY,
NULL AS ENI_MEASURE60,
NULL AS ENI_MEASURE1,
NULL AS ENI_MEASURE9,
NULL AS ENI_MEASURE3,
NULL AS ENI_MEASURE11,
NULL AS ENI_MEASURE31,
NULL AS ENI_MEASURE32,
NULL AS ENI_MEASURE33,
NULL AS ENI_MEASURE34,
NULL AS ENI_MEASURE20,
NULL AS ENI_MEASURE21,
NULL AS ENI_MEASURE22,
NULL AS ENI_MEASURE23,
NULL AS ENI_MEASURE25,
NULL AS ENI_MEASURE26,
NULL AS ENI_MEASURE27,
NULL AS ENI_MEASURE28,
NULL AS ENI_MEASURE35,
NULL AS ENI_MEASURE36,
NULL AS ENI_MEASURE37,
NULL AS ENI_MEASURE38,
NULL AS ENI_MEASURE40
FROM DUAL';
select value as VIEWBY,
ID AS VIEWBYID,
ENI_MEASURE60, '
|| l_common_part ||'
FROM ( SELECT EIV.VALUE AS VALUE, eiv.id as id,
'|| l_description ||',
'|| l_inner_part ||'
ENI_DBI_CO_DNUM_MV edcd
' || l_lookup_from || '
WHERE
1=1
AND
((edcd.creation_date
<= &BIS_CURRENT_ASOF_DATE ) AND
( nvl(IMPLEMENTATION_DATE,&BIS_CURRENT_ASOF_DATE +1) > &BIS_CURRENT_ASOF_DATE ) AND
( nvl(CANCELLATION_DATE,&BIS_CURRENT_ASOF_DATE +1) > &BIS_CURRENT_ASOF_DATE )
OR
(edcd.creation_date
<= &BIS_PREVIOUS_ASOF_DATE ) AND
( nvl(IMPLEMENTATION_DATE,&BIS_PREVIOUS_ASOF_DATE +1) > &BIS_PREVIOUS_ASOF_DATE ) AND
( nvl(CANCELLATION_DATE,&BIS_PREVIOUS_ASOF_DATE +1) > &BIS_PREVIOUS_ASOF_DATE))
' || l_item_where ||'
' || l_lookup_outer_where ||'
' || l_org_where || '
' || l_type_where || '
' || l_priority_where || '
' || l_reason_where|| '
' || l_status_where || '
GROUP BY
eiv.id,eiv.value'||l_inner_group_by||'
) t
WHERE
ENI_MEASURE1 > 0 OR ENI_MEASURE9 > 0
group by
id,value,ENI_MEASURE1, ENI_MEASURE9, ENI_MEASURE3, ENI_MEASURE11,
ENI_MEASURE31, ENI_MEASURE32, ENI_MEASURE33, ENI_MEASURE34,
ENI_MEASURE60,INNER11,INNER12,INNER21,INNER22
order by
' || l_order_by ;