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 :

60 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. The laptops made by Dell are stylish, have good internal hardware, and look amazing (and they have some of the best ruggedized options on the market).
      They include high-quality construction, a long battery life, and are small and portable.

      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. I love Orcale app thanks for sharing this I am preparing this app called Gbwhatsapp let me know how is it?

    ReplyDelete
  11. 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
    Replies
    1. With the advancements, SEPCO online bill payment is an effortless task. There are many ways through which a person can pay the SEPCO bill online. First of all, let’s talk about the apps that provide SEPCO online bill payment services.

      SEPCO Bill Payment Customers who have a jazz cash account can also pay the bill. To do so, follow the given steps

      Delete
  12. 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
  13. Wow great skills, also take a look at my website Thoptv For PC

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

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

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

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

    ReplyDelete
  18. Ö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
  19. 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
  20. This comment has been removed by the author.

    ReplyDelete
  21. 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
  22. 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
  23. 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
  24. Thanks For Sharing such a great information antivirus crackeado 2019

    ReplyDelete
  25. 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
  26. thanks for sharing this info.I also want to share it via yo whatsapp apk

    ReplyDelete
  27. 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
  28. Good and quality content. Have a great day bro. And thanks for a nice article.
    Momix Apk Mod

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

    ReplyDelete
  30. 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
  31. 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
  32. 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
  33. 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
  34. That is the One place for Latest News and Technology Tips & Tricks.
    Whatsapp Group Names
    AeroWhatsapp APK

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

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

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

    ReplyDelete
  37. 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
  38. 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
  39. Glo MTN Airtel https://networkwayout.com.ng/ Night Sub, Cheat, Code, Tariff Plans, Migrate

    ReplyDelete
  40. this codes will be useful for me to get the  tariff and data plans   
    for MTN,Glo Airtel and 9mobile and there is no need to buy any codes further   

    ReplyDelete
  41. It is generally preferred to use abwhatsapp over the traditional WhatsApp. Due to its unique features and functionalities.

    ReplyDelete
  42. e will see how to download Gacha Club to your PC or Mac. The procedure will allow you to play your favourite application as well as all your other Android games legally. To do this, we will need an Android emulator. Thanks to its performance, its simplicity of installation and use, but also the fact that it is free and the most secure emulator, we will use BlueStacks. Moreover, it is compatible with Windows and Mac versions.

    ReplyDelete
  43. The large size of JPEG files can make it challenging to upload or share them over the internet or via email. To compress jpeg to 500kb or a smaller file size, there are several online tools available that can help you achieve this

    ReplyDelete
  44. if you are looking for some unique username check this Username ideas

    ReplyDelete
  45. Tired of using old traditional themes for your blog? try some of these Best wix themes at presentybox

    ReplyDelete
  46. Upgrade to AnWhatsApp+10 and discover a whole new world of possibilities for your WhatsApp messaging.

    ReplyDelete