Concurrent Programs assigned to a request type
                                                 Last update (2008-05-05 09:18:07)
                                                                                                                   Date added (2008-05-04 18:00:44)

Summary
Gives you a list of concurrent programs that have been assigned to a request type, ordered by request type.
SELECT RC.REQUEST_CLASS_NAME, 
       CPTL.USER_CONCURRENT_PROGRAM_NAME, 
       CP.CONCURRENT_PROGRAM_NAME
  FROM APPLSYS.FND_CONCURRENT_PROGRAMS_TL CPTL, 
       APPLSYS.FND_CONCURRENT_PROGRAMS CP,
       APPLSYS.FND_CONCURRENT_REQUEST_CLASS RC
 WHERE RC.APPLICATION_ID = CP.CLASS_APPLICATION_ID
   AND RC.REQUEST_CLASS_ID = CP.CONCURRENT_CLASS_ID
   AND CP.APPLICATION_ID = CPTL.APPLICATION_ID 
   AND CP.CONCURRENT_PROGRAM_ID = CPTL.CONCURRENT_PROGRAM_ID
 ORDER BY REQUEST_CLASS_NAME, USER_CONCURRENT_PROGRAM_NAME;
Reviews
Filters
Search