oracle ebs的权限设计,Oracle EBS 数据访问权限集

SELECT T.RESPONSIBILITY_NAME,

TPO.PROFILE_OPTION_NAME,

TPO.USER_PROFILE_OPTION_NAME,

FPV.PROFILE_OPTION_VALUE,

CASE

WHEN TPO.PROFILE_OPTION_NAME = 'GL_SET_OF_BKS_ID' THEN

(SELECT T.NAME

FROM GL_LEDGERS T

WHERE T.LEDGER_ID = FPV.PROFILE_OPTION_VALUE

AND ROWNUM = 1)

WHEN TPO.PROFILE_OPTION_NAME = 'GL_ACCESS_SET_ID' THEN

(SELECT T.NAME

FROM GL_ACCESS_SETS T

WHERE T.ACCESS_SET_ID = FPV.PROFILE_OPTION_VALUE

AND ROWNUM = 1)

WHEN TPO.PROFILE_OPTION_NAME IN

('XLA_MO_SECURITY_PROFILE_LEVEL', 'FA_SECURITY_PROFILE_ID') THEN

(SELECT TT.SECURITY_PROFILE_NAME

FROM PER_SECURITY_PROFILES TT

WHERE TT.SECURITY_PROFILE_ID = FPV.PROFILE_OPTION_VALUE

AND ROWNUM = 1)

ELSE

FPV.PROFILE_OPTION_VALUE

END AS PROFILE_OPTION_VALUE_DESC

FROM FND_PROFILE_OPTION_VALUES FPV,

FND_PROFILE_OPTIONS_TL    TPO,

FND_PROFILE_OPTIONS       BPO,

FND_RESPONSIBILITY_TL     T,

FND_RESPONSIBILITY        B

WHERE FPV.LEVEL_ID = 10003

AND FPV.PROFILE_OPTION_ID = BPO.PROFILE_OPTION_ID

AND FPV.APPLICATION_ID = BPO.APPLICATION_ID

-- AND tpo.USER_PROFILE_OPTION_NAME = 'MO：安全性配置文件'

AND FPV.LEVEL_VALUE = B.RESPONSIBILITY_ID

AND B.RESPONSIBILITY_ID = T.RESPONSIBILITY_ID

AND B.APPLICATION_ID = T.APPLICATION_ID

AND T.LANGUAGE = 'ZHS'

AND BPO.PROFILE_OPTION_NAME = TPO.PROFILE_OPTION_NAME

AND TPO.LANGUAGE = 'ZHS'

-- AND T.responsibility_name LIKE '%AP%';