查找Request

Select * From  Apps.Fnd_Request_Groups  -----«@µÃApplication_id
 
Select * /*Fefv.Executable_Id*/
From   apps.Fnd_Executables_Form_v Fefv
Where   Fefv.Execution_Method_Code = 'P'
    And Fefv.Application_Id = 201;

Select *
From   apps.Fnd_Concurrent_Programs_Vl Fcpl
Where  Fcpl.Executable_Id =
    (Select Fefv.Executable_Id From apps.Fnd_Executables_Form_v Fefv Where Fefv.Executable_Name = 'VSINV029R');

Select Frg.Request_Group_Name, Fcpt.User_Concurrent_Program_Name
From   Apps.Fnd_Request_Groups Frg,
       Apps.Fnd_Request_Group_Units Frgu,
       Apps.Fnd_Concurrent_Programs_Tl Fcpt   
Where  Frg.Request_Group_Id = Frgu.Request_Group_Id
    And Frgu.Request_Unit_Id = Fcpt.Concurrent_Program_Id
   --And  frg.request_group_name='AUS_INV_SP'
   And Fcpt.User_Concurrent_Program_Name =  'VSINV029R ëŠ×Ó»¯ˆóUÇåƒÔ(180 x 66)'--'Material Shortage Check Processor' --'SDBOM001P.Main Copy BOM Procedure'--Like 'VSHR%'