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 codeSELECT 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 '%作废%');