Wednesday 1 March 2017

Get Request Set programs details with their exetuables

SELECT A.request_set_id,
  B.REQUEST_SET_STAGE_ID,
  A.USER_REQUEST_SET_NAME,
  C.USER_CONCURRENT_PROGRAM_NAME,
  E.EXECUTION_FILE_NAME,
  E.EXECUTION_METHOD_CODE
FROM apps.FND_REQUEST_SETS_TL A,
  apps.FND_REQUEST_SET_PROGRAMS B,
  apps.fnd_concurrent_programs_tl C,
  apps.fnd_concurrent_programs D,
  apps.fnd_executables E
WHERE a.request_set_id     =b.request_set_id
AND b.concurrent_program_id=c.concurrent_program_id
AND c.concurrent_program_id=d.concurrent_program_id
AND d.executable_id        =e.executable_id
AND (A.USER_REQUEST_SET_NAME) LIKE '%'   ||:RequestSetName   ||'%'
ORDER BY b.REQUEST_SET_STAGE_ID;

1 comment:

  1. The Best Casino Sites: Online Casino Sites in Philippines
    The best Online Casino Sites: 온카지노 Online Casino Sites in Philippines · 1. Lucky Star Casino – ₹10000 Bonus ✓ 220% up to ₹1000 · 2. Planet 7 – ₹150000 Bonus หาเงินออนไลน์ · 3. 888 카지노 Casino – ₹

    ReplyDelete