Here's the query to find the request group name by passing concurrent program name as parameter
SELECT
FRG.REQUEST_GROUP_NAME,
FRG.DESCRIPTION,
CP.CONCURRENT_PROGRAM_ID,
CP.CONCURRENT_PROGRAM_NAME,
CPT.USER_CONCURRENT_PROGRAM_NAME,
FRV.RESPONSIBILITY_NAME
FROM
FND_REQUEST_GROUPS FRG,
FND_REQUEST_GROUP_UNITS FRGU,
FND_CONCURRENT_PROGRAMS CP,
FND_CONCURRENT_PROGRAMS_TL CPT,
FND_RESPONSIBILITY_VL FRV
WHERE
FRG.REQUEST_GROUP_ID = FRGU.REQUEST_GROUP_ID
AND FRGU.REQUEST_UNIT_ID = CP.CONCURRENT_PROGRAM_ID
AND CP.CONCURRENT_PROGRAM_ID = CPT.CONCURRENT_PROGRAM_ID
AND FRV.REQUEST_GROUP_ID = FRG.REQUEST_GROUP_ID(+)
AND CPT.USER_CONCURRENT_PROGRAM_NAME LIKE 'XX Conc Pgm Name';
SELECT
FRG.REQUEST_GROUP_NAME,
FRG.DESCRIPTION,
CP.CONCURRENT_PROGRAM_ID,
CP.CONCURRENT_PROGRAM_NAME,
CPT.USER_CONCURRENT_PROGRAM_NAME,
FRV.RESPONSIBILITY_NAME
FROM
FND_REQUEST_GROUPS FRG,
FND_REQUEST_GROUP_UNITS FRGU,
FND_CONCURRENT_PROGRAMS CP,
FND_CONCURRENT_PROGRAMS_TL CPT,
FND_RESPONSIBILITY_VL FRV
WHERE
FRG.REQUEST_GROUP_ID = FRGU.REQUEST_GROUP_ID
AND FRGU.REQUEST_UNIT_ID = CP.CONCURRENT_PROGRAM_ID
AND CP.CONCURRENT_PROGRAM_ID = CPT.CONCURRENT_PROGRAM_ID
AND FRV.REQUEST_GROUP_ID = FRG.REQUEST_GROUP_ID(+)
AND CPT.USER_CONCURRENT_PROGRAM_NAME LIKE 'XX Conc Pgm Name';
This comment has been removed by the author.
ReplyDeleteIts impressive to know something about your note on Oracle apps Course. Please do share your articles like this your articles for our awareness. Mostly we do also provide Online Training on Cub training oracle apps course.
ReplyDeleteI would like to appreciate your work for good accuracy and got informative knowledge from here. This is both interesting and relevant. We see this sort of thing regularly.
ReplyDeleteOracle Fusion HCM Technical Coaching
Hi,
ReplyDeleteit is very informative post.
Thanks for sharing such a post.
oracle fusion SCM online training
To find the name of the group request by passing the parallel name of the program as a parameter, employees essay
ReplyDeleteit is necessary to adhere to all the proposed parameters.
This comment has been removed by the author.
ReplyDelete