Showing posts with label Query to find concurrent request set attached Responsibility. Show all posts
Showing posts with label Query to find concurrent request set attached Responsibility. Show all posts

Wednesday, 24 August 2016

Query to find concurrent request set attached Responsibility

SELECT   FRT.RESPONSIBILITY_NAME
       , FRG.REQUEST_GROUP_NAME
       , FRGU.REQUEST_UNIT_TYPE
       , FRGU.REQUEST_UNIT_ID
       , FCPT.USER_REQUEST_SET_NAME
FROM     APPS.FND_RESPONSIBILITY FR
       , APPS.FND_RESPONSIBILITY_TL FRT
       , APPS.FND_REQUEST_GROUPS FRG
       , APPS.FND_REQUEST_GROUP_UNITS FRGU
       , APPS.FND_REQUEST_SETS_TL FCPT
WHERE    FRT.RESPONSIBILITY_ID = FR.RESPONSIBILITY_ID
AND      FRG.REQUEST_GROUP_ID = FR.REQUEST_GROUP_ID
AND      FRGU.REQUEST_GROUP_ID = FRG.REQUEST_GROUP_ID
AND      FCPT.REQUEST_SET_ID = FRGU.REQUEST_UNIT_ID
AND      FRT.LANGUAGE = USERENV ('LANG')
AND      FCPT.LANGUAGE = USERENV ('LANG')
AND      FCPT.USER_REQUEST_SET_NAME = :REQUEST_SET_NAME
ORDER BY 1, 2, 3, 4