mmt.transaction_action_id not in
(
select
to_number(flv.lookup_code)
from
fnd_lookup_values flv
where
flv.meaning=:action and
flv.lookup_type='MTL_TRANSACTION_ACTION' and
flv.view_application_id=700 and
flv.language=userenv('lang') and
flv.security_group_id=0
)

mmt.transaction_action_id in
(
select
to_number(flv.lookup_code)
from
fnd_lookup_values flv
where
flv.meaning=:action and
flv.lookup_type='MTL_TRANSACTION_ACTION' and
flv.view_application_id=700 and
flv.language=userenv('lang') and
flv.security_group_id=0
)