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