• EBS客户化迁移SQL


    检查一些作废了的东西是否在程序包中还有用
    
    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 '%作废%');
        
    


     

  • 相关阅读:
    容器基础(三): 使用Cgroups进行资源限制
    如何使用微软认知服务
    【PAT甲级】1004. Counting Leaves (30)
    PAT 1003. Emergency
    蓝桥杯2017模拟赛-风险度量
    HDU1242 Rescue
    HDU2437 Jerboas 深度优先遍历 + 剪枝
    HDU1257 最少拦截系统
    HDU1789 Doing Homework again
    UWP 打开、保存文件示例
  • 原文地址:https://www.cnblogs.com/wanghang/p/6299569.html
Copyright © 2020-2023  润新知