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
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