SQL to determine what request groups and concurrent program


hello, a very useful small piece of sql, quite useful whilte troubleshootings.

What is the SQL to determine what request groups and concurrent program is assigned to?

select request_group_name from FND_REQUEST_GROUPS where REQUEST_GROUP_ID =(SELECT request_group_id
FROM FND_REQUEST_GROUP_UNITS WHERE REQUEST_UNIT_ID=(select CONCURRENT_PROGRAM_ID from
FND_CONCURRENT_PROGRAMS where CONCURRENT_PROGRAM_NAME ='<report short name>’));

thanks – Shivmohan

5 thoughts on “SQL to determine what request groups and concurrent program

  1. —-This will work fine:
    select request_group_name from FND_REQUEST_GROUPS where
    REQUEST_GROUP_ID IN(SELECT request_group_id
    FROM FND_REQUEST_GROUP_UNITS WHERE REQUEST_UNIT_ID=(select CONCURRENT_PROGRAM_ID from
    FND_CONCURRENT_PROGRAMS where CONCURRENT_PROGRAM_NAME =’’));

    Like

Want to give some comment to author ( Shivmohan Purohit )

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s