徐氏SQL宝典 之三

查看Request状态:

-------
Select r.Request_Id,
    L1.Meaning || '.' || L2.Meaning b,
    Pb.Concurrent_Program_Name d,
    Pt.User_Concurrent_Program_Name e,
    Fa.Application_Short_Name f,
    Decode(r.Resubmit_Interval, Null, 'N', 'Y') g,
    r.Resubmit_Interval || r.Resubmit_Interval_Unit_Code,
    Fu.User_Name h,
    r.Request_Date,
    r.Argument_Text,
    r.*
From
    Applsys.Fnd_Concurrent_Programs_Tl Pt,
    Applsys.Fnd_Concurrent_Programs Pb,
    Applsys.Fnd_Concurrent_Requests r,
    Apps.Fnd_Lookups L1,
    Apps.Fnd_Lookups L2,
    Apps.Fnd_Application Fa,
    Apps.Fnd_User Fu
Where  Pb.Application_Id = r.Program_Application_Id
And    Pb.Application_Id = Fa.Application_Id
And    Pb.Concurrent_Program_Id = r.Concurrent_Program_Id
And    Pb.Application_Id = Pt.Application_Id
And    Pb.Concurrent_Program_Id = Pt.Concurrent_Program_Id
And    r.Requested_By = Fu.User_Id
And    L1.Lookup_Type = 'CP_PHASE_CODE'
And    L1.Lookup_Code = r.Phase_Code
And    L1.Lookup_Code = 'P'    ------- Running Phase: Running/Pending....
And    L2.Lookup_Type = 'CP_STATUS_CODE'
And    L2.Lookup_Code = r.Status_Code
--And    L2.Lookup_Code = 'E'   -------- Running Status:Normal/Error....
And    Fa.Application_Short_Name != 'ALR'   ----°Ñ Alert µÄ Request ÅųýÔÚÍâ
And    r.Request_Date > Trunc(Sysdate)   ---time
--AND fu.USER_NAME = 'SYSADMIN'     ----Requested_By
--And pt.USER_CONCURRENT_PROGRAM_NAME ='Import Items'   ----Request Name
--And r.request_id=10567183    ----Request ID
--And FA.APPLICATION_SHORT_NAME ='INV'   -----Module