msiv.item_type in (
select
flv.lookup_code
from
fnd_lookup_values flv
where
flv.meaning=:item_type and
flv.lookup_type='ITEM_TYPE' and
flv.language=userenv('lang') and
flv.view_application_id=3 and
flv.security_group_id=0
)