读书人

EBS 查寻用户在某段时间内运行了什么请

发布时间: 2013-04-02 12:35:26 作者: rapoo

EBS 查找用户在某段时间内运行了什么请求

    select fu.user_name               用户名,         frt.responsibility_name    职责,         fcr.completion_text        完成,         fcr.RESPONSIBILITY_ID      职责号,         fcr.actual_completion_date 完成日期,         fcr.request_id             请求号,         fcrsv.USER_CONCURRENT_PROGRAM_NAME 使用并发程序名    from fnd_concurrent_requests fcr,         fnd_responsibility_tl   frt,         fnd_user                fu,         FND_CONC_REQ_SUMMARY_V fcrsv   where fcr.RESPONSIBILITY_ID = frt.RESPONSIBILITY_ID     and fcr.actual_completion_date <= sysdate - 1     and fu.user_id = fcr.requested_by     and fcrsv.REQUEST_ID = fcr.request_id     and fu.user_name = 'ZMSUP006'     and fcr.actual_completion_date >= sysdate -3-- ;--两天内       order by fcr.actual_completion_date;    

读书人网 >其他数据库

热点推荐