SELECT FRT.RESPONSIBILITY_NAME, FRG.REQUEST_GROUP_NAME, FRG.DESCRIPTION, FCPT.USER_CONCURRENT_PROGRAM_NAME
FROM apps.FND_REQUEST_GROUPS FRG
,apps.FND_REQUEST_GROUP_UNITS FRGU
,apps.FND_CONCURRENT_PROGRAMS FCP
,apps.FND_CONCURRENT_PROGRAMS_TL FCPT
,apps.FND_RESPONSIBILITY_TL FRT
,apps.FND_RESPONSIBILITY FR
WHERE FRGU.UNIT_APPLICATION_ID = FCP.APPLICATION_ID
AND FRGU.REQUEST_UNIT_ID = FCP.CONCURRENT_PROGRAM_ID
AND FRG.REQUEST_GROUP_ID = FRGU.REQUEST_GROUP_ID
AND FRG.APPLICATION_ID = FRGU.APPLICATION_ID
AND FCPT.SOURCE_LANG = USERENV('LANG')
AND FCP.APPLICATION_ID = FCPT.APPLICATION_ID
AND FCP.CONCURRENT_PROGRAM_ID = FCPT.CONCURRENT_PROGRAM_ID
AND FR.APPLICATION_ID = FRT.APPLICATION_ID
AND FR.RESPONSIBILITY_ID = FRT.RESPONSIBILITY_ID
AND FRT.SOURCE_LANG = USERENV('LANG')
AND FR.REQUEST_GROUP_ID = FRG.REQUEST_GROUP_ID
AND FR.APPLICATION_ID = FRG.APPLICATION_ID
-- AND FCP.CONCURRENT_PROGRAM_NAME = '' -- YOU CAN PUT THE SHORTNAME HERE
AND FCPT.USER_CONCURRENT_PROGRAM_NAME LIKE '' --OR THE USER CONC PROGRAM NAME HERE;
FROM apps.FND_REQUEST_GROUPS FRG
,apps.FND_REQUEST_GROUP_UNITS FRGU
,apps.FND_CONCURRENT_PROGRAMS FCP
,apps.FND_CONCURRENT_PROGRAMS_TL FCPT
,apps.FND_RESPONSIBILITY_TL FRT
,apps.FND_RESPONSIBILITY FR
WHERE FRGU.UNIT_APPLICATION_ID = FCP.APPLICATION_ID
AND FRGU.REQUEST_UNIT_ID = FCP.CONCURRENT_PROGRAM_ID
AND FRG.REQUEST_GROUP_ID = FRGU.REQUEST_GROUP_ID
AND FRG.APPLICATION_ID = FRGU.APPLICATION_ID
AND FCPT.SOURCE_LANG = USERENV('LANG')
AND FCP.APPLICATION_ID = FCPT.APPLICATION_ID
AND FCP.CONCURRENT_PROGRAM_ID = FCPT.CONCURRENT_PROGRAM_ID
AND FR.APPLICATION_ID = FRT.APPLICATION_ID
AND FR.RESPONSIBILITY_ID = FRT.RESPONSIBILITY_ID
AND FRT.SOURCE_LANG = USERENV('LANG')
AND FR.REQUEST_GROUP_ID = FRG.REQUEST_GROUP_ID
AND FR.APPLICATION_ID = FRG.APPLICATION_ID
-- AND FCP.CONCURRENT_PROGRAM_NAME = '' -- YOU CAN PUT THE SHORTNAME HERE
AND FCPT.USER_CONCURRENT_PROGRAM_NAME LIKE '' --OR THE USER CONC PROGRAM NAME HERE;
No comments:
Post a Comment