一些常用的EBS移植脚本

youbo1

/*特别注意*/
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