Query para obtener los Grupos de Solicitudes por Programa Concurrente

El siguiente query que les comparto obtiene datos principales del grupo de solicitudes que se ubica un programa concurrente. Es posible tener mas de un programa concurrente en varios Grupos de Solicitudes.

SELECT

FVL.APPLICATION_ID,

FVL.APPLICATION_NAME APLICACION,

RG.REQUEST_GROUP_ID ,

RG.REQUEST_GROUP_NAME "Grupo de Solicitudes" ,

RG.DESCRIPTION,

DECODE(RGU.REQUEST_UNIT_TYPE,'P',

'Program','S','Set',RGU.REQUEST_UNIT_TYPE) "Tipo",

CP.CONCURRENT_PROGRAM_ID,

CP.CONCURRENT_PROGRAM_NAME "Abreviatura",

CPT.USER_CONCURRENT_PROGRAM_NAME "Programa Concurrente"

FROM

  FND_REQUEST_GROUPS RG,

  FND_REQUEST_GROUP_UNITS RGU,

  FND_CONCURRENT_PROGRAMS CP,

  FND_CONCURRENT_PROGRAMS_TL CPT,

  FND_APPLICATION_VL fVL

WHERE RG.REQUEST_GROUP_ID = RGU.REQUEST_GROUP_ID

AND FVL.APPLICATION_ID = RG.APPLICATION_ID

AND RGU.REQUEST_UNIT_ID = CP.CONCURRENT_PROGRAM_ID

AND CP.CONCURRENT_PROGRAM_ID = CPT.CONCURRENT_PROGRAM_ID

AND CPT.USER_CONCURRENT_PROGRAM_NAME =&P_CONC_PROG_NAME;