ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Query the concurrent programs at DB site

Query the concurrent programs at DB site

原创 Linux操作系统 作者:CoolEasy 时间:2011-06-08 12:43:40 0 删除 编辑
Select Cr.Request_Id,
Cr.Concurrent_Program_Id,
Decode(Cp.User_Concurrent_Program_Name,
      'Report Set',
      'Report Set: ' || Cr.Description,
      Cp.User_Concurrent_Program_Name) Name,
Argument_Text,
Cr.Resubmit_Interval,
Nvl2(Cr.Resubmit_Interval,
    'PERIODICALLY',
    Nvl2(Cr.Release_Class_Id, 'ON SPECIFIC DAYS', 'ONCE')) Schedule_Type,
Decode(Nvl2(Cr.Resubmit_Interval,
           'PERIODICALLY',
           Nvl2(Cr.Release_Class_Id, 'ON SPECIFIC DAYS', 'ONCE')),
      'PERIODICALLY',
      'EVERY ' || Cr.Resubmit_Interval || ' ' ||
      Cr.Resubmit_Interval_Unit_Code || ' FROM ' ||
      Cr.Resubmit_Interval_Type_Code || ' OF PREV RUN',
      'ONCE',
      'AT :' ||
      To_Char(Cr.Requested_Start_Date, 'DD-MON-RR HH24:MI'),
      'EVERY: ' || Fcr.Class_Info) Schedule,
Fu.User_Name,
Requested_Start_Date,
Actual_Start_Date,
Actual_Completion_Date
From Apps.Fnd_Concurrent_Programs_Tl Cp,
Apps.Fnd_Concurrent_Requests    Cr,
Apps.Fnd_User                   Fu,
Apps.Fnd_Conc_Release_Classes   Fcr
Where Cp.Application_Id = Cr.Program_Application_Id
And Cp.Concurrent_Program_Id = Cr.Concurrent_Program_Id
And Cr.Requested_By = Fu.User_Id
And Cr.Phase_Code In ('P', 'R', 'C') --- Pending and Running Requests
--And Cr.Requested_Start_Date > Sysdate
And Cp.Language = 'US'
And Fcr.Release_Class_Id(+) = Cr.Release_Class_Id
And Fcr.Application_Id(+) = Cr.Release_Class_App_Id
/*and Cr.Request_Id = 2699964*/
And Nvl(Cr.Description, Cp.User_Concurrent_Program_Name) Like :1
AND Actual_Start_Date >SYSDATE-3; 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/16793185/viewspace-697380/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-06-08

  • 博文量
    5
  • 访问量
    6361