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博客

Query the concurrent programs at DB site