Wednesday, March 27, 2013

Concurrent Program/Set attached to Request Groups

Your Ad Here



 SELECT
  RG.APPLICATION_ID "Request Group Application ID",
  RG.REQUEST_GROUP_ID "Request Group - Group ID",
  RG.REQUEST_GROUP_NAME,
  RG.DESCRIPTION,
  rgu.unit_application_id,
  rgu.request_group_id "Request Group Unit - Group ID",
  rgu.request_unit_id,cp.concurrent_program_id,
  cp.concurrent_program_name,
  cpt.user_concurrent_program_name,
  DECODE(rgu.request_unit_type,'P','Program','S','Set',rgu.request_unit_type) "Unit Type"
FROM
  apps.fnd_request_groups rg,
  apps.fnd_request_group_units rgu,
  apps.fnd_concurrent_programs cp,
  apps.fnd_concurrent_programs_tl cpt
WHERE rg.request_group_id = rgu.request_group_id
  AND rgu.request_unit_id = cp.concurrent_program_id
  AND cp.concurrent_program_id = cpt.concurrent_program_id
  AND cpt.user_concurrent_program_name = 'XX CM Pack Slip - US'
Your Ad Here

31 comments:

  1. There are lots of information about oracle have spread around the web, but this is a unique one according to me. The strategy you have updated here will make me to get to the next level in oracle. Thanks for sharing this.

    Oracle Training Chennai
    Oracle Training Center in Chennai

    ReplyDelete
    Replies
    1. Hi, Great.. Tutorial is just awesome..It is really helpful for a newbie like me.. I am a regular follower of your blog. Really very informative post you shared here. Kindly keep blogging. If anyone wants to become a Java developer learn from Java Training in Chennai. or learn thru Java Online Training India . Nowadays Java has tons of job opportunities on various vertical industry.

      Delete
  2. Thanks for sharing informative article on java application development. Your post helped to understand the career in Java.
    Java Training in Chennai
    Dot Net Training in Chennai
    PHP Training in Chennai

    ReplyDelete
  3. Wow! It was the best article , actually you have posted something new compared to others, because I read many articles related to this topic but I only get impressed with your post only, keep posting.
    Regards,
    SAP training center in chennai|SAP course chennai|SAP Training in Chennai|SAP Institutes in Chennai|SAP training in chennai

    ReplyDelete
  4. Updating to latest technology is one's responsibility. Article like this are truly inspiring and worth able to read. You have done a great job by posting it in here. Thanks for sharing.
    PHP Training
    PHP Training Institute in Chennai

    ReplyDelete
  5. Updating with the latest technology and implementing it is the only way to survive in our niche. Thanks for making me understand through this article. You have done a great job by sharing this content in here. Keep writing article like this.

    DOT NET Training in Chennai | Dot net training | Best DOT NET Training institute in Chennai

    ReplyDelete
  6. Dear admin, The way you have explained the concept is mezmerizing. Thank you so much for sharing tis worth able content with us. The concept taken here will be useful for my future programs and i will surely implement them in my study. Keep blogging article like this.


    JAVA Training in Chennai | Best JAVA Training in Chennai | Salesforce training in chennai

    ReplyDelete
  7. Nice article you might have carried out below. My business is truly happy to see that. This is the incredibly helpful matter. keep that you're selected it up.Customer Services & Support

    ReplyDelete
  8. Very happy to see this blog. Gives a wonderful information with coded explanaion. Thank you for this blog. very useful to me.
    Dotnet Training in Chennai

    ReplyDelete
  9. Big data is used extensively in MNC today as using big data leads to accurate decision making and there are is a huge demand for the big data analysts.
    Big data training in Chennai | Hadoop training in Chennai | Big data training institute in Chennai

    ReplyDelete
  10. Python is an object oriented high level programming language which is built in data structures combined with dynamic typing and dynamic binding making it very attractive for rapid application development.
    Python Training in Chennai | Python Course in Chennai

    ReplyDelete
  11. Pretty article! I found some useful information in your blog, it was awesome to read, thanks for sharing this great content to my vision, keep sharing.
    Regards,
    SAP Training in Chennai with placement | java training in chennai with placement

    ReplyDelete
  12. The strategy you have posted on this technology helped me to get into the next level and had lot of information in it.
    Dot net training in Chennai | dot net course in Chennai

    ReplyDelete
  13. The best thing is that your blog really informative thanks for your great information!
    erp in chennai

    ReplyDelete
  14. Wow! It was the best article , actually you have posted something new compared to others.thanks for updating..
    Best Bcom/Mcom Project Center in Chennai | No.1 Bsc/Msc Project in Chennai | Best BCA/MCA Project Center in Chennai


    ReplyDelete
  15. It is a one of the great discussion which is very essential for me as well. I must follow the handy discussion and sure that the content will be very useful to me as well. Keep it up. 
    No.1 Java Project Center in Chennai | Best Dot Net Projects in Chennai | Best Mini Project Center in Chennai


    ReplyDelete
  16. Thanks for sharing this important information Keep posting.
    Please Visit - www.chennaicrackersonline.com/crackers

    ReplyDelete
  17. Sas Training Institute in Noida-Webtrackker is the best sas training institute in noida. SAS has taken the lead role for a long time, where most companies have standard software. While you have this certification under your belt, give big rewards to the IT industry, it can also serve as an important payer on the business side of the economy. SAS can read data files created by other statistical packages. Therefore, for experienced users of these statistical packages, SAS does not threaten to create data files created by these packages in a SAS file format.
    Sap Training Institute in Noida
    PHP Training Institute in Noida
    Hadoop Training Institute in Noida
    Oracle Training Institute in Noida
    Linux Training Institute in Noida
    Dot net Training Institute in Noida
    Salesforce training institute in noida
    Java training institute in noida

    ReplyDelete
  18. I have read your Blog,its very attractive and impressive content..Thanks for sharing such an informative post..keep updating..
    Best Embedded Project Center in Chennai | Best Mat Lab Project Center in Chennai | Best Image Processing Project Center in Chennai

    ReplyDelete
  19. Hadoop Training Institute in Noida- Webtrackker is the best Hadoop training institute in noida. If you want take the training in a Hadoop than Webtrackker is the best option for you. Since then Hadoop has continued with the development of the YARN cluster manager, releasing the project from its first distribution of HadoopMap Reduce. HadoopMap Reduce is still available in Hadoop to perform static batch processes for which Map Reduce is suitable. Other data processing activities can be assigned to different processing engines (including Spark), where YARN manages the management and allocation of cluster resources.
    Projects like Apache Mesas provide a powerful and growing range of distributed cluster management capabilities. Most Spark implementations still use Apache Hadoop and its associated projects to meet these requirements.

    ReplyDelete
  20. Great content thanks for sharing this informative blog which provided me technical information keep posting.
    IEEE Project Center in Chennai | Best IEEE Project Center in Chennai |Online Training in Chennai

    ReplyDelete
  21. Thanks For Your valuable posting, it was very informative
    Schulungsangebote

    ReplyDelete
  22. It is a very nice article including a lot of viral content. I am going to share it on social media. Get the Cold Pressed Oil in online.

    ReplyDelete
  23. I believe there are many more pleasurable opportunities ahead for individuals that looked at your site.
    sas training in bangalore

    ReplyDelete