🔹 Join the OracleApps88 Telegram Group - Stay up to date with the latest on Oracle EBS R12 and Oracle Cloud/Fusion Applications. 📌 Telegram Group : https://t.me/OracleApps88

💡 Facing issues copying code/scripts or viewing posts? We're here to help!
📬 Contact on Telegram : https://t.me/apps88
📱 Telegram/WhatsApp: +91 905 957 4321
📧 Email Support: OracleApp88@Yahoo.com

Monday, December 12, 2011

List Concurrent Requests Responsibility Wise....

SELECT
  fa.application_short_name,
  fcpv.user_concurrent_program_name,
  description,
  DECODE (fcpv.execution_method_code, 'B', 'Request Set Stage Function', 'Q',
  'SQL*Plus', 'H', 'Host', 'L', 'SQL*Loader', 'A', 'Spawned', 'I',
  'PL/SQL Stored Procedure', 'P', 'Oracle Reports', 'S', 'Immediate',
  fcpv.execution_method_code ) exe_method,
  output_file_type,
  program_type,
  printer_name,
  minimum_width,
  minimum_length,
  concurrent_program_name,
  concurrent_program_id
FROM
  fnd_concurrent_programs_vl fcpv,
  fnd_application fa
WHERE
  fcpv.application_id = fa.application_id
ORDER BY
  description

No comments:

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect