一些常用的EBS移植脚本

<pre name="code" class="sql"><pre name="code" class="sql">/*特别注意*/ export NLS_LANG="SIMPLIFIED CHINESE_CHINA.UTF8" /*profile*/ select 'FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct  ' || fpo.profile_option_name || '.ldt ' ||        ' PROFILE  APPLICATION_SHORT_NAME=' || fa.application_short_name || '  PROFILE_NAME=' || fpo.profile_option_name   from FND_PROFILE_OPTIONS fpo,        fnd_application fa where fpo.application_id = fa.application_id    AND fa.application_short_name = 'CUX'; select fpo.USER_PROFILE_OPTION_NAME,        'FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct   ' || fpo.profile_option_name || '.ldt'   from FND_PROFILE_OPTIONS_vl fpo, fnd_application fa where fpo.application_id = fa.application_id    AND fa.application_short_name = 'CUX'    --AND fpo.profile_option_name NOT IN ()    ; /*lookup_type*/ select 'FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct  ' || flt.LOOKUP_TYPE || '.ldt ' ||        ' FND_LOOKUP_TYPE   APPLICATION_SHORT_NAME=' || fa.application_short_name || ' LOOKUP_TYPE=' || flt.LOOKUP_TYPE   from FND_LOOKUP_TYPES flt, fnd_application fa where flt.application_id = fa.application_id    and fa.application_short_name = 'CUX'; select flt.LOOKUP_TYPE,        flt.MEANING,        'FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct  ' || flt.LOOKUP_TYPE || '.ldt'  || ' -'   from FND_LOOKUP_TYPES_vl flt, fnd_application fa where flt.application_id = fa.application_id    and fa.application_short_name = 'CUX'    AND flt.LOOKUP_TYPE NOT IN ('SRG_STATUS','SRG_EXPENSE_TYPE','SRG_RATE_TYPE','SRG_SETTLE_STATUS')    ; --export NLS_LANG="SIMPLIFIED CHINESE_CHINA.UTF8" /*message*/ SELECT 'FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct  ' || fnm.message_name || '.ldt ' ||        ' FND_NEW_MESSAGES APPLICATION_SHORT_NAME=' || fa.application_short_name || '  MESSAGE_NAME=' || fnm.message_name   FROM FND_NEW_MESSAGES fnm,        fnd_application  fa WHERE fnm.application_id = fa.application_id    AND fa.application_short_name = 'CUX'    AND fnm.language_code = 'ZHS' ;    SELECT fnm.message_name,        'FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afmdmsg.lct  ' || fnm.message_name || '.ldt '  || ' -'   FROM FND_NEW_MESSAGES fnm,        fnd_application  fa WHERE fnm.application_id = fa.application_id    AND fa.application_short_name = 'CUX'    AND fnm.message_name NOT IN ('CUX_ZSW_TEST') ;    /*concurrent program*/   select  'FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct  ' || fcp.CONCURRENT_PROGRAM_NAME || '.ldt ' ||         ' PROGRAM   APPLICATION_SHORT_NAME=' || fa.application_short_name || '   CONCURRENT_PROGRAM_NAME=' || fcp.CONCURRENT_PROGRAM_NAME   from fnd_concurrent_programs fcp, fnd_application fa where fcp.application_id = fa.application_id and        fa.application_short_name = 'CUX'; select fcp.USER_CONCURRENT_PROGRAM_NAME,        'FNDLOAD apps/apps 0 Y UPLOAD  $FND_TOP/patch/115/import/afcpprog.lct  ' || fcp.CONCURRENT_PROGRAM_NAME || '.ldt'   from fnd_concurrent_programs_vl fcp, fnd_application fa where fcp.application_id = fa.application_id and        fa.application_short_name = 'CUX'    AND fcp.CONCURRENT_PROGRAM_NAME NOT IN ('CUX_TEST_FNDUSER','CUX_TEST_FNDUSER_PDF','CUX_TEST_PO','CUXTEST','CUXTEMPTEST',                                            'CUXINTRP','CUXLYINS','CUXLYINT','CUXASSLYPROD','CUXASSLY','CUXASSYL',                                            'CUXSCARCASH','CUXSCCASH','CUX_TEST_FNDUSRE_PDF')           ;        /*function*/ SELECT 'FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct  ' || fcp.function_name || '.ldt ' ||        ' FUNCTION   FUNC_APP_SHORT_NAME=' || fa.application_short_name || '   FUNCTION_NAME=' || fcp.function_name   FROM fnd_form_functions fcp, fnd_application fa WHERE fcp.application_id = fa.application_id    AND fa.application_short_name = 'CUX' ; SELECT fcp.USER_FUNCTION_NAME,        'FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct  ' || fcp.function_name || '.ldt'    FROM fnd_form_functions_vl fcp, fnd_application fa WHERE fcp.application_id = fa.application_id    AND fa.application_short_name = 'CUX'    AND fcp.function_name NOT IN ('CUXVATREQN'); /*个性化*/ SELECT DISTINCT 'FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct  ' || fcr.function_name || '.ldt ' ||                 ' FND_FORM_CUSTOM_RULES  function_name=' || fcr.function_name   FROM FND_FORM_CUSTOM_RULES fcr;   SELECT DISTINCT 'FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct  ' || fcr.function_name || '.ldt '   FROM FND_FORM_CUSTOM_RULES fcr;     /*menu*/ FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct CUX_menu.ldt MENU MENU_NAME='CUX_SUPER' FNDLOAD apps/apps 0 Y UPLOAD  $FND_TOP/patch/115/import/afsload.lct CUX_menu.ldt  /*request group*/ FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct CUX_reqgrp.ldt REQUEST_GROUP APPLICATION_SHORT_NAME=CUX REQUEST_GROUP_NAME='CUX: All Reports' FNDLOAD apps/apps 0 Y UPLOAD  $FND_TOP/patch/115/import/afcpreqg.lct CUX_reqgrp.ldt