wdj.status_type in (
select
to_number(flv.lookup_code) status
from
fnd_lookup_values flv
where
flv.meaning=:job_status and
flv.lookup_type='WIP_JOB_STATUS' and
flv.language=userenv('lang') and
flv.view_application_id=700 and
flv.security_group_id=0
)