Search 800 + Posts

Jun 8, 2014

Query to Extract Concurrent Program Request Set name


SELECT t.*
  FROM apps.FND_REQUEST_SETS_TL t
 WHERE request_set_id IN
          (SELECT request_set_id
             FROM apps.FND_REQUEST_SET_PROGRAMS
            WHERE concurrent_program_id =
                     (SELECT CONCURRENT_PROGRAM_ID
                        FROM apps.fnd_concurrent_programs_tl
                       WHERE language = 'US'
                         AND upper(USER_CONCURRENT_PROGRAM_NAME) =  UPPER('ENTER_YOUR_CP_NAME') ) )




No comments:

Post a Comment