查询所有ICX相关Profile的SQL
set pages 100
set line 120
column "Option" format 99999999
column "Profile Name" format A35
column "Profile Value" format A55
spool support_profile_value.txt
select a.PROFILE_OPTION_ID "Option"
,a.PROFILE_OPTION_NAME "Profile Name"
,b.PROFILE_OPTION_VALUE "Profile Value"
from
fnd_profile_options a
,fnd_profile_option_values b
where
a.PROFILE_OPTION_ID = b.PROFILE_OPTION_ID(+)
and a.PROFILE_OPTION_NAME like \'ICX%\'
/
spool offReference:
Scripts To Obtain ICX Profiles For Discoverer 4i And E-Business Suite Integration (Doc ID 222135.1)
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/26687597/viewspace-1204154/ ，如需转载，请注明出处，否则将追究法律责任。
