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')
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/23169974/viewspace-755493/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
年过完了
请登录后发表评论
登录
全部评论
