Profile "GL: Data Access Set"

最新推荐文章于 2020-07-20 23:05:37 发布

hanshuyong

最新推荐文章于 2020-07-20 23:05:37 发布

阅读量304

点赞数

分类专栏： Oracle ERP技术文章标签： access application user date

本文链接：https://blog.csdn.net/hanshuyong/article/details/7638540

版权

Oracle ERP技术专栏收录该内容

5 篇文章 0 订阅

订阅专栏

SELECT U.USER_ID,
       U.USER_NAME,
       R.RESPONSIBILITY_ID,
       R.RESPONSIBILITY_NAME,
       ASL.ACCESS_SET_ID,
       GLE.LEDGER_ID,
       GLE.NAME LEDGER_NAME
FROM FND_USER                       U,
       FND_USER_RESP_GROUPS           G,
       FND_RESPONSIBILITY_VL          R,
       APPS.FND_PROFILE_OPTIONS       F,
       APPS.FND_PROFILE_OPTION_VALUES V,
       GL_ACCESS_SET_LEDGERS          ASL,
       GL_LEDGERS                     GLE
WHERE U.USER_ID = G.USER_ID
   AND G.RESPONSIBILITY_ID = R.RESPONSIBILITY_ID
   AND G.RESPONSIBILITY_APPLICATION_ID = R.APPLICATION_ID
   AND G.START_DATE < SYSDATE
   AND NVL(G.END_DATE, SYSDATE) >= SYSDATE
   AND (UPPER(R.RESPONSIBILITY_NAME) LIKE '%SUPPORT%AND%SETUP%' OR
       UPPER(R.RESPONSIBILITY_NAME) LIKE '%TRANSACTION%' OR
       UPPER(R.RESPONSIBILITY_NAME) LIKE '%CLOSE%SUPPORT%' OR
       UPPER(R.RESPONSIBILITY_NAME) LIKE '%IMPLEMENTATION SUPERUSER%')
   AND F.PROFILE_OPTION_NAME = 'GL_ACCESS_SET_ID'
   AND F.APPLICATION_ID = V.APPLICATION_ID
   AND F.PROFILE_OPTION_ID = V.PROFILE_OPTION_ID
   AND ASL.ACCESS_SET_ID = V.PROFILE_OPTION_VALUE
   AND ASL.LEDGER_ID = GLE.LEDGER_ID
   AND V.LEVEL_VALUE = R.RESPONSIBILITY_ID
   AND U.USER_NAME = &P_USER_NAME;