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

No comments:

Post a Comment