报表对应程序包查询

转载于 2018-08-21 19:26:00 发布 · 102 阅读

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/lizicheng/p/9513451.html

SELECT Cpv.User_Concurrent_Program_Name
       ,Cpv.Creation_Date
       ,Ds.Name
       ,Ds.line 
       ,Ds.Text
       --select count(1) 
   FROM Dba_Source                 Ds
       ,Fnd_Executables_Form_v     Efv
       ,Fnd_Concurrent_Programs_Vl Cpv
  WHERE ds.TYPE = 'PACKAGE BODY'
    and Ds.Name = Upper(Substrb(Efv.Execution_File_Name
                               ,1
                               ,Instrb(Efv.Execution_File_Name
                                      ,'.') - 1))
    AND Efv.Executable_Id = Cpv.Executable_Id
    and  Efv.Execution_File_Name like 'CUX%';