关闭

查找Request

标签: application
490人阅读 评论(0) 收藏 举报
分类:

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%'
     
     
     
     

0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:42674次
    • 积分:973
    • 等级:
    • 排名:千里之外
    • 原创:50篇
    • 转载:4篇
    • 译文:0篇
    • 评论:1条
    最新评论