SELECT FRT.RESPONSIBILITY_NAME,
FRG.REQUEST_GROUP_NAME,
FRGU.REQUEST_UNIT_TYPE,
FRGU.REQUEST_UNIT_ID,
FCPT.USER_CONCURRENT_PROGRAM_NAME
FROM FND_RESPONSIBILITY FR,
FND_RESPONSIBILITY_TL FRT,
FND_REQUEST_GROUPS FRG,
FND_REQUEST_GROUP_UNITS FRGU,
FND_CONCURRENT_PROGRAMS_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.CONCURRENT_PROGRAM_ID =
FRGU.REQUEST_UNIT_ID
AND FRT.LANGUAGE = USERENV('LANG')
AND FCPT.LANGUAGE = USERENV('LANG')
AND
FCPT.USER_CONCURRENT_PROGRAM_NAME =
'PO Changes'
ORDER BY 1, 2, 3, 4
No comments:
Post a Comment