Oracle Apps Knowledge Sharing

Query to find the programs attached to request groups in 11i

select REQUEST_GROUP_NAME,        decode(REQUEST_UNIT_TYPE,'A'
                     ,'Application','P'
                     ,'Program','S'
                     ,'Request Set','no') REQUEST_UNIT_TYPE,
         user_concurrent_program_name program_name
 from FND_REQUEST_GROUPS A,
         FND_REQUEST_GROUP_UNITS b,
         FND_CONCURRENT_PROGRAMS_VL C
where a.request_group_id=b.request_group_id
 AND B.REQUEST_UNIT_ID=C.CONCURRENT_PROGRAM_ID
 AND REQUEST_GROUP_NAME='&request_roup_name'
 AND request_unit_type='P'
UNION
select REQUEST_GROUP_NAME,
          decode(REQUEST_UNIT_TYPE,'A'
                      ,'Application','P'
                      ,'Program','S'
                      ,'Request Set','no') REQUEST_UNIT_TYPE,
          application_name program_name
 from FND_REQUEST_GROUPS A,
         FND_REQUEST_GROUP_UNITS b,
         fnd_application_TL C
where a.request_group_id=b.request_group_id
 AND B.REQUEST_UNIT_ID=C.application_id
 AND REQUEST_GROUP_NAME='&request_roup_name'
 AND request_unit_type='A'
 And language='US'
UNION
Select REQUEST_GROUP_NAME,
          decode(REQUEST_UNIT_TYPE,'A'
                      ,'Application','P'
                      ,'Program','S'
                      ,'Request Set','no') REQUEST_UNIT_TYPE,
          request_set_name program_name
 from FND_REQUEST_GROUPS A,
         FND_REQUEST_GROUP_UNITS b,
         FND_REQUEST_SETS C
where a.request_group_id=b.request_group_id
 AND B.REQUEST_UNIT_ID=C.request_set_id
 AND REQUEST_GROUP_NAME='&request_roup_name'
 AND request_unit_type='S';

Many thanks Gokula Raman Bose for contributing the above query.
Email: sarikarthi@yahoo.co.in