以下脚本可以用来在EBS中查找特定profile option的设置,sql中,查找的profile option为并发%OPP%
sql
SELECT FPOT.USER_PROFILE_OPTION_NAME, DECODE(FPOV.LEVEL_ID, 10001, 'Site', 10002, 'Application', 10003, 'Responsibility', 10004, 'User', 10005, 'Server', 10006, 'Org', 10007, DECODE(TO_CHAR(FPOV.LEVEL_VALUE2), '-1', 'Responsibility', DECODE(TO_CHAR(FPOV.LEVEL_VALUE), '-1', 'Server', 'Server+Resp')), 'UnDef'), DECODE(TO_CHAR(FPOV.LEVEL_ID), '10001', '', '10002', APP.APPLICATION_SHORT_NAME, '10003', RSP.RESPONSIBILITY_KEY, '10004', USR.USER_NAME, '10005', SVR.NODE_NAME, '10006', ORG.NAME, '10007', DECODE(TO_CHAR(FPOV.LEVEL_VALUE2), '-1', RSP.RESPONSIBILITY_KEY, DECODE(TO_CHAR(FPOV.LEVEL_VALUE), '-1', (SELECT NODE_NAME FROM FND_NODES WHERE NODE_ID = FPOV.LEVEL_VALUE2), (SELECT NODE_NAME FROM FND_NODES WHERE NODE_ID = FPOV.LEVEL_VALUE2) || '-' || RSP.RESPONSIBILITY_KEY)), 'UnDef') "CONTEXT", FPOV.PROFILE_OPTION_VALUE, FPOT.DESCRIPTION FROM FND_PROFILE_OPTIONS_TL FPOT, FND_PROFILE_OPTIONS FPO, FND_PROFILE_OPTION_VALUES FPOV, FND_USER USR, FND_APPLICATION APP, FND_RESPONSIBILITY RSP, FND_NODES SVR, HR_OPERATING_UNITS ORG WHERE 1 = 1 AND FPO.PROFILE_OPTION_ID = FPOV.PROFILE_OPTION_ID AND FPO.PROFILE_OPTION_NAME = FPOT.PROFILE_OPTION_NAME AND FPOT.LANGUAGE = 'ZHS' AND FPOT.USER_PROFILE_OPTION_NAME LIKE '并发%OPP%' AND USR.USER_ID(+) = FPOV.LEVEL_VALUE AND RSP.APPLICATION_ID(+) = FPOV.LEVEL_VALUE_APPLICATION_ID AND RSP.RESPONSIBILITY_ID(+) = FPOV.LEVEL_VALUE AND APP.APPLICATION_ID(+) = FPOV.LEVEL_VALUE AND SVR.NODE_ID(+) = FPOV.LEVEL_VALUE AND ORG.ORGANIZATION_ID(+) = FPOV.LEVEL_VALUE ;
**粗体** _斜体_ [链接](http://example.com) `代码` - 列表 > 引用
。你还可以使用@
来通知其他用户。