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/,如需转载,请注明出处,否则将追究法律责任。