Tuesday, 6 February 2018

Responsibilities Name wise User Name and User Id in Oracle Apps EBS R12

----****************************************************************************----
----           Responsibilities Name wise User Name and User Id in Oracle Apps EBS R12                 ----
----****************************************************************************----

SELECT USR.USER_ID,
       USR.USER_NAME,
       RES.RESPONSIBILITY_ID,
       RES.RESPONSIBILITY_NAME
  FROM APPS.FND_USER USR,
       APPS.FND_RESPONSIBILITY_TL RES,
       APPS.FND_USER_RESP_GROUPS GRP
 WHERE GRP.RESPONSIBILITY_ID   = RES.RESPONSIBILITY_ID
   AND GRP.USER_ID             = USR.USER_ID
   AND RES.RESPONSIBILITY_NAME = NVL(:RESPONSIBILITY_NAME,RES.RESPONSIBILITY_NAME)
   AND USR.USER_NAME           = NVL(:USER_NAME,USR.USER_NAME);

No comments:

Post a Comment

How to make responsibilities as read only in oracle apps EBS R12 Using Custom.Pll Or Creating a read only Responsibility in oracle apps EBS R12 Using Custom.Pll

  How to make responsibilities as read only in oracle apps EBS R12 Using Custom.Pll Or Creating a read only Responsibility in oracle apps ...