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

About these ads

5 responses to “SQL to determine what request groups and concurrent program

  1. Pingback: Top Referred Articles on KnowOracle | Shivmohan Purohit's Oracle Applications Blog

  2. —-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 =’’));

  3. This query throughs an error ORA-01427

  4. This query doesn’t work.

  5. Thank you for this thorough and useful explanation

Leave a Reply

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