select
con.user_concurrent_program_name,
a.description,
a.request_id,
a.phase_code,
a.status_code,
a.requested_by,
a.REQUEST_DATE,
a.REQUESTED_START_DATE,
a.actual_start_date,
a.actual_completion_date,
a.RESUBMIT_INTERVAL,
a.RESUBMIT_INTERVAL_UNIT_CODE,
a.root_request_id,
a.ARGUMENT_TEXT
from apps.fnd_concurrent_requests a, apps.FND_CONCURRENT_PROGRAMS_TL con
where a.concurrent_program_id = con.concurrent_program_id
--and con.user_concurrent_program_name like 'Receiving Transaction%'
and a.status_code in ('I','Q')
con.user_concurrent_program_name,
a.description,
a.request_id,
a.phase_code,
a.status_code,
a.requested_by,
a.REQUEST_DATE,
a.REQUESTED_START_DATE,
a.actual_start_date,
a.actual_completion_date,
a.RESUBMIT_INTERVAL,
a.RESUBMIT_INTERVAL_UNIT_CODE,
a.root_request_id,
a.ARGUMENT_TEXT
from apps.fnd_concurrent_requests a, apps.FND_CONCURRENT_PROGRAMS_TL con
where a.concurrent_program_id = con.concurrent_program_id
--and con.user_concurrent_program_name like 'Receiving Transaction%'
and a.status_code in ('I','Q')