The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
DECODE(FROM_ITEM
,NULL
,DECODE(TO_ITEM
,NULL
,'Item Range All '
,' Item Range All - ' || TO_ITEM)
,DECODE(TO_ITEM
,NULL
,'Item Range ' || FROM_ITEM || ' - All'
,'Item Range ' || FROM_ITEM || ' - ' || TO_ITEM))
INTO RANGEV
FROM
DUAL;
SELECT
USER_NAME
INTO USERNAME
FROM
FND_USER
WHERE USER_ID = USER_ID_1;
SELECT
'All'
INTO FROM_WHSECP
FROM
DUAL;
SELECT
'All'
INTO FROM_ITEMCP
FROM
DUAL;
SELECT
'All'
INTO TO_WHSECP
FROM
DUAL;
SELECT
'All'
INTO TO_ITEMCP
FROM
DUAL;