Tuesday, 17 April 2012

Query to find the Responsibilites

SELECT B.RESPONSIBILITY_ID,
                 A.RESPONSIBILITY_NAME,
                 A.LANGUAGE,
                 B.RESPONSIBILITY_KEY ,
                 B.APPLICATION_ID
  FROM APPS.FND_RESPONSIBILITY_TL A,
       APPS.FND_RESPONSIBILITY B
  WHERE A.RESPONSIBILITY_ID(+)=B.RESPONSIBILITY_ID
  AND A.LANGUAGE = USERENV('LANG')
  ORDER BY A.RESPONSIBILITY_NAME

Query to Find the REQUEST_GROUP

select * from fnd_responsibility WHERE APPLICATION_ID =101 AND RESPONSIBILITY_ID = 20479 --REQUEST_GROUP_ID

select * from fnd_responsibility_tl WHERE APPLICATION_ID =101 AND RESPONSIBILITY_ID = 20479

select * from fnd_request_groups where REQUEST_GROUP_ID =111
 

No comments:

Post a Comment