EBS客户化迁移SQL

1042人阅读 评论(0) 收藏 举报
分类:
检查一些作废了的东西是否在程序包中还有用

SELECT t.* FROM ALL_SOURCE T WHERE T.TEXT LIKE '%CUX_AP_OA_OMS_PROGRAM_ELECT%' order by name;

--SELECT * FROM FND_FLEX_VALUE_SETS T WHERE T.FLEX_VALUE_SET_NAME LIKE 'HSST%';

 

--并发程序
SELECT T.*,B.*
  FROM fnd_concurrent_programs_tl t,
       fnd_concurrent_programs b
 WHERE b.application_id = t.application_id
   AND b.concurrent_program_id = t.concurrent_program_id
   AND (t.user_concurrent_program_name LIKE 'CUX%'
   or t.user_concurrent_program_name LIKE 'HEB%');
--值集
  SELECT t.*/*, v.**/
    FROM fnd_flex_value_sets t/*, fnd_flex_values v*/--表验证值集没有fnd_flex_values
   WHERE (t.description LIKE 'CUX%' OR t.description LIKE 'HEB%')
     AND t.validation_type = 'F'
     AND t.flex_value_set_id NOT IN
         (SELECT b.flex_value_set_id
            FROM fnd_flex_value_sets b
           WHERE b.description LIKE '%作废%');
    /* AND t.flex_value_set_id = v.flex_value_set_id*/
       
--配置文件
SELECT t.*, b.*
  FROM fnd_profile_options_tl t, fnd_profile_options b
 WHERE b.profile_option_name = t.profile_option_name
   AND b.profile_option_name LIKE 'HEB%';
 
--lookup code
SELECT b.*, t.*
  FROM fnd_lookup_types_tl t, fnd_lookup_types b
 WHERE b.lookup_type = t.lookup_type
   AND b.security_group_id = t.security_group_id
   AND b.view_application_id = t.view_application_id
   AND (t.meaning LIKE 'CUX%' OR t.meaning LIKE 'HEB%')
   AND t.meaning NOT IN (SELECT t1.meaning
                           FROM fnd_lookup_types_tl t1
                          WHERE t1.meaning LIKE '%作废%');
    


 

0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:1035176次
    • 积分:14124
    • 等级:
    • 排名:第864名
    • 原创:348篇
    • 转载:260篇
    • 译文:0篇
    • 评论:21条
    ★★★★★★★交流方式★★★★★★
    Mail:xingyun.cai@qq.com
    个人书籍
    《深入浅出Oracle Form开发》.电子工业出版社
    最新评论