Follow us: Connect on YouTube Connect on YouTube Connect on YouTube

Pages

Wednesday, 18 October 2017

Query to Get Concurrent Program details in Oracle Apps


--Concurrent Programs details

SELECT fcp.concurrent_program_id,
       fcp.concurrent_program_name,
       fcpt.user_concurrent_program_name,
       fcpt.description,
       fe.executable_name,
       fet.user_executable_name,
       fe.execution_file_name
  FROM apps.fnd_concurrent_programs fcp,
       apps.fnd_concurrent_programs_tl fcpt,
       apps.fnd_executables fe,
       apps.fnd_executables_tl fet
 WHERE     fe.executable_id = fet.executable_id
       AND fcp.concurrent_program_id = fcpt.concurrent_program_id
       AND fcpt.language = fet.language
       AND fcp.executable_id = fe.executable_id
       AND fcp.executable_application_id = fe.application_id
       AND fcpt.language = 'US'
       AND fcpt.user_concurrent_program_name LIKE
              'Meter Collection Main Program'



--To find Responsibilities having a particular Concurrent Program

  SELECT frt.responsibility_name, fcpt.user_concurrent_program_name
    FROM fnd_concurrent_programs fcp,
         fnd_concurrent_programs_tl fcpt,
         fnd_request_group_units frgu,
         fnd_responsibility fr,
         fnd_responsibility_tl frt
   WHERE     fcp.concurrent_program_id = fcpt.concurrent_program_id
         AND fcp.application_id = fcpt.application_id
         AND fcp.concurrent_program_id = frgu.request_unit_id(+)
         AND frgu.unit_application_id(+) = fcp.application_id
         AND frgu.request_group_id = fr.request_group_id(+)
         AND fr.responsibility_id = frt.responsibility_id(+)
         AND fr.application_id = frt.application_id(+)
         AND frgu.request_unit_type(+) = 'P'
         AND frt.language(+) = 'US'
         AND fcpt.language = 'US'
         AND fcpt.user_concurrent_program_name LIKE 'I%Materialized%'
ORDER BY frt.responsibility_name



--Concurrent Request Details

SELECT           
        fcr.request_id request_id,
         NVL (fu.description, fu.user_name) requested_by,
         DECODE (fcp.concurrent_program_name,
                 'FNDRSSUB', 'Request Set - ' || fcr.description,
                 fcpt.user_concurrent_program_name)
            concurrent_program,
         DECODE (fcr.phase_code,
                 'I', 'Inactive',
                 'P', DECODE (fcr.hold_flag, 'Y', 'Inactive', 'Pending'),
                 'R', 'Running',
                 'C', 'Complete',
                 fcr.phase_code)
            phase,
         DECODE (
            fcr.status_code,
            'U', 'Disabled',
            'W', 'Paused',
            'X', 'Terminated',
            'Z', 'Waiting',
            'M', 'No Manager',
            'Q', 'Standby',
            'R', 'Normal',
            'S', 'Suspended',
            'T', 'Terminating',
            'D', 'Cancelled',
            'E', 'Error',
            'F', 'Scheduled',
            'G', 'Warning',
            'H', 'On Hold',
            'I', CASE
                    WHEN fcr.request_date < fcr.requested_start_date
                    THEN
                       'Scheduled'
                    ELSE
                       'Normal'
                 END,
            'A', 'Waiting',
            'B', 'Resuming',
            'C', 'Normal',
            fcr.status_code)
            status,
         fcr.argument_text,
         TO_CHAR (fcr.request_date, 'DD-Mon-RRRR HH12:MI:SS AM') date_requested,
         TO_CHAR (fcr.requested_start_date, 'DD-Mon-RRRR HH12:MI:SS AM')
            requested_start_date,
         TO_CHAR (fcr.actual_start_date, 'DD-Mon-RRRR HH12:MI:SS AM')
            date_started,
         TO_CHAR (fcr.actual_completion_date, 'DD-Mon-RRRR HH12:MI:SS AM')
            date_completed,
         fcr.oracle_process_id,
         fcr.os_process_id,
         fcr.logfile_node_name || ': ' || fcr.logfile_name logfile_name,
         fcr.outfile_node_name || ': ' || fcr.outfile_name output_name
    FROM fnd_concurrent_requests fcr,
         fnd_concurrent_programs fcp,
         fnd_concurrent_programs_tl fcpt,
         fnd_user fu
   WHERE     fcr.concurrent_program_id = fcp.concurrent_program_id
         AND fcp.concurrent_program_id = fcpt.concurrent_program_id
         AND fcr.program_application_id = fcp.application_id
         AND fcp.application_id = fcpt.application_id
         AND fcr.requested_by = fu.user_id
         AND fcpt.language = 'US'
ORDER BY fcr.request_date DESC
Share this article :

53 comments:

  1. Oracle apps and Fusion Self Paced Training Videos by Industry Experts. Please Check oracleappstechnical.com

    ReplyDelete
    Replies
    1. Your post is helping me a lot. Its really nice and epic. Thanks a lot for the useful info on this topic. You did it so much well. I love to see more about GB WhatsApp. Keep sharing and updating. Also share more posts with us. Thank you.

      Delete
  2. As per a report by Statista, as of January 2018, there were over 3.7 billion individual portable clients on the planet. Additionally, because of the serious cell phone innovation being used today, versatile cell phones represented almost half of the complete worldwide web utilization volume. whats mod apks

    ReplyDelete
    Replies
    1. I think Gbwhatsapp is the most popular now. The information you have shared here is very helpful. I really like and appreciate your work. Thanks again for it, keep us updated in future!

      Delete
  3. FMWhatsApp APK is usually favored over the traditional variant of WhatsApp. All Thanks to the unique set of features and functionalities that it offers.

    ReplyDelete
  4. Holy moly thank you, I have been searching for a query like this for days now!

    ReplyDelete
  5. Nice & Informative Blog !
    Finding adequate technical services for QuickBooks in this competitive world is quite challenging. Our team at QuickBooks Phone Number 1-855-652-7978 is always available to offer you the best technical help for QuickBooks.

    ReplyDelete
  6. When i started using Oracle, I used to think that Status code "A" means active but letter I got to know on Yo WhatsApp from a group that "A" a for waiting status code,

    ReplyDelete
  7. Thanks for the post. I have found this codes much similar as in universal remote code apps source code.
    Thanks a lot
    Ishan Shezan
    Universalremotebest.com

    ReplyDelete
  8. Great article Lot's of information to Read...Great Man Keep Posting and update to People..Thanks spy phone app

    ReplyDelete
  9. Excellent blog, keep sharing such things. It was helpful. Also try Nulls Clash.

    ReplyDelete
  10. Nulls Brawl Apk
    Nulls Brawl Alpha APK 36.270 Buzz ve Griff Android Oyun İndir Son Sürüm Hileli Sınırsız Elmas Sınırsız Para

    ReplyDelete
  11. I love Orcale app thanks for sharing this I am preparing this app called Gbwhatsapp let me know how is it?

    ReplyDelete
  12. Offshore Hosting with 100% DMCA ignored Hosting, Offshore Dedicated Server, Offshore VPS Hosting. https://offshorededi.com/ is the Most Secure Offshore Host. Providing Offshore Streaming Servers as well.

    ReplyDelete
  13. Thanks for the wonderful blog, I suggest you add videos in the blog. Inshot App Para PC is a great software for downloading the videos and making the blog more attractive. Use the software to edit the videos.

    ReplyDelete
  14. Wow great skills, also take a look at my website Thoptv For PC

    ReplyDelete
  15. fortnite sistem gereksinimleri? nedir diye soruyorsanız fortnite sistem gereksinimleri haberimize göz atmayı unutmayın.

    ReplyDelete
  16. Thanks for shear its very critical program actually I working on it last two months. Also check Download GBWhatsApp APK

    ReplyDelete
  17. Thanks for sharing this valuable piece of information. Keep sharing more such awesome articles in the future. Goodbye! Download FMWhatsApp APK

    ReplyDelete
  18. Your site is the best source of information, it was very helpful. Thanks for sharing. Also checkout COC MOD Apk.

    ReplyDelete
  19. Thanks for the detailed article on this topic. I would like to see more such awesome articles from you. Download GBWhatsApp APK

    ReplyDelete
  20. This was much needed especially for oracle app. Thank you so much! Download COC Mod APK

    ReplyDelete
  21. Öncelikle, telefonunuzun veya hedef cihazınızın ayarlarına girmelisiniz.
    Ardından güvenlik seçeneğindeki bilinmeyen kaynaklar seçeneğine gidin.
    Bu seçeneği etkinleştirebilirsiniz, ancak bu oyunu indirmek ücretsiz olduğu için uyarı mesajı konusunda endişelenmeyin.
    Web sitemizden indirmek için APK dosyasını seçin.
    Nulls Brawl Stars Mod'u indirmek için gidin ve arama çubuğunda arayın.
    Arama sonuçlarını kullanarak ilgili bağlantıya tıklayın ve uygulamayı indirin.
    İlk olarak, eski oyununuzun kapalı olduğundan emin olun. İndirdiğiniz APK'yi kurun.
    Kurulum tamamlandıktan sonra oyun simgesine tıkladığınızda oyun başlatılabilir.
    Nulls Brawl Stars Modunu akıllı telefonunuzda oynayın.

    ReplyDelete
    Replies
    1. Top Eleven 2021 Gerçek menajerlik deneyimi ve taktikler. Çok harika bir oyun.

      Delete
  22. PUBG NEW STATE PUBG: New State’de dronlardan fazlasını, çeşitli araç ve özelliklerin keyfini çıkarın. Çeşitli araçlarla geniş dünyaların keyfine varın. Savaşı lehinize çevirmek için dinamikleşmiş silahlar kullanın.

    ReplyDelete
  23. This comment has been removed by the author.

    ReplyDelete
  24. YouTube Premium MOD APK YouTube Premium APK İndirin. Kilitsiz REKLAM İZLEMEDEN İZLE veya DİNLE! Üye olmadan sınırsız müzik keyfi kaliteli içerikler ve ayrıca arka planda ücretsiz müzik dinle.

    ReplyDelete
  25. The information you have shared here is very helpful. I really like and appreciate your work. Thanks again for it, keep us updated in future! Also try GBWhatsapp Apk.

    ReplyDelete
  26. Thanks for the detailed article on this topic. I would like to see more such awesome articles from you. Also you can get the new and best features of FMWhatsapp which are coming in 2022-


    FMWhatsapp APK

    ReplyDelete
  27. WhatsApp apk is most popular application for android smart phone. If you want to use all hideen features of WhatsApp Apk GBWhatsApp APK Download , Mod Apk Download

    ReplyDelete
  28. KineMaster pro apk is one of the best smartphone video editing tools. If you want to download this application click and download this application. kinemaster lite , KineMaster Pro

    ReplyDelete
  29. Video editing is a good profession now this time. If you want to edting video with android or ios phone then Kinemaster Pro Mod Apk Download and start editing today for making professional video.

    ReplyDelete
  30. Thanks For Sharing such a great information antivirus crackeado 2019

    ReplyDelete
  31. Download KineMaster Prime Apk with no watermark. Kinemaster prime download and get benefits from its new advanced features. It's 100% working, unlocked, and premium mod apk of Kinemaster Official Version. Kinemaster Prime is a most popular and downloadable app for video editors with android phone. If you wish to use it in iPhone, Then you can also use it from our Kinemaster iOS Download Source.

    ReplyDelete
  32. thanks for sharing this info.I also want to share it via yo whatsapp apk

    ReplyDelete
  33. APK İNDİR Tüm oyun ve uygulamaları MOD APK İndirin. Para Hileli veya Elmas Hileli! Reklamsız veya Kilitsiz tüm oyun ve uygulamalar için hile...

    ReplyDelete
  34. Good and quality content. Have a great day bro. And thanks for a nice article.
    Momix Apk Mod

    ReplyDelete
  35. Hello There. I discovered your blog the usage of msn. That is a very well written article. PCVAST

    ReplyDelete
  36. Mynordstrom employee can access them my pay & info, payment schedule, attendance, payroll reports, login and check benefits through mynordstrom com portal. This website specially created for their employees.

    ReplyDelete
  37. Are you looking for online tools that will help you in accomplishing different tasks? Telecombit.com/tools is providing you a comprehensive package of online tools that will help you in different sections.

    ReplyDelete
  38. Couple name combiner was designed and developed after keeping in mind the needs and intents of the user. It will surely make your girlfriend or boyfriend feel special when he/she will know about the sweet name so generated.

    ReplyDelete
  39. Here we provide some best Technical guide, information, tips and tricks for all the internet, android, pc & more.
    Free SonyLiv Premium account
    KKR Whatsapp Group Link

    ReplyDelete
  40. That is the One place for Latest News and Technology Tips & Tricks.
    Whatsapp Group Names
    AeroWhatsapp APK

    ReplyDelete
  41. The Federal Road Safety Corps (FRSC) has conducted annual recruitment for many years. Here on our website, we have received many inquiries from job seekers who are curious for jobs in Frsc recruitment 2021/2022.

    ReplyDelete
  42. I am happy to be here and this wonderful blog. I have found here lots of important information for my knowledge I need. Thanks for sharing this amazing post. For if Roadrunner Email Working Slowly please contact roadrunner support team for solution.

    ReplyDelete
  43. Little Known Facts About Second Marriage Girl Mobile Number In TamilNadu.

    https://pakiwelz.online/second-marriage-girl-mobile-number-in-tamilnadu/

    ReplyDelete
  44. The Indian Premier League has already started, You can visit here to IPL 2022 Points Table update.

    ReplyDelete
  45. O thanks, admin your site and blog is very impressive and good to see. And also thanks for sharing this informative. Keep it Sir and I am waiting for your next post on your site blog. Regards GBWhatsapp APK

    ReplyDelete
  46. Thanks for sharing the information. This Forum is Very helpful, people can share there information here very easily. Eid ul Adha Mubarak Wishes for Love

    ReplyDelete