Query to get concurrent Program details with Parameter list and value set attached to parameter.

Query :

SELECT fcpt.user_concurrent_program_name,
  fcp.concurrent_program_name,
  fcp.concurrent_program_id,
  fav.application_short_name,
  fav.application_name,
  fav.application_id,
  fdfcuv.column_seq_num,
  fdfcuv.end_user_column_name,
  fdfcuv.form_left_prompt prompt,
  ffvs.flex_value_set_name,
  fdfcuv.enabled_flag,
  fdfcuv.required_flag,
  fdfcuv.display_flag
FROM apps.fnd_concurrent_programs fcp,
  apps.fnd_concurrent_programs_tl fcpt,
  apps.fnd_descr_flex_col_usage_vl fdfcuv,
  apps.fnd_application_vl fav,
  apps.fnd_flex_value_sets ffvs
WHERE fcp.concurrent_program_id       = fcpt.concurrent_program_id
AND fav.application_id                = fcp.application_id
AND fcpt.language                     = 'US'
AND ffvs.flex_value_set_id            = fdfcuv.flex_value_set_id
AND fdfcuv.descriptive_flexfield_name = '$SRS$.'  || fcp.concurrent_program_name
AND fcpt.user_concurrent_program_name = 'Trial Balance'
ORDER BY fdfcuv.column_seq_num;


Output of query :

Comments

  1. ExclusiveSeptember 17, 2018 at 3:03 AM

    digital marketing Bangladesh.google.com

    ReplyDelete
  2. ExclusiveSeptember 17, 2018 at 3:04 AM

    digital marketing of Bangladesh.digital marketing

    ReplyDelete
  3. UnknownSeptember 28, 2018 at 11:44 PM

    This is a great post. I check your blogs regularly but after reading this blog and I’m inspired. It is extremely helpful information �� I read such information a lot, for my personal knowledge.Fore more information visit my Blog

    ReplyDelete
  4. UnknownSeptember 28, 2018 at 11:47 PM

    Its really wonderful post and photos also, i have no word for your this amazing post, so thanks to sharing. icsi specialist in ncr Delhi

    ReplyDelete
  5. surnitrayOctober 10, 2018 at 5:50 AM

    This is a great post. I check your blogs regularly but after reading this blog and I’m inspired. It is extremely helpful information �� I read such information a lot, for my personal knowledge.
    Thank you for sharing this useful information, I will regularly follow your blog. Excellent post, thanks for sharing, it’s indeed very helpful for a new blogger like me. I am sharing some important topic now you can you easily get free Roblox Asset Downloader. For more information visit my blog Rassetdownloader.

    ReplyDelete
  6. UnknownOctober 15, 2018 at 12:30 PM

    thanks for sharing the list it is so much use full i apply it if you want roblox asset downloader you may check and get quick Roblox Asset

    ReplyDelete
  7. surnitrayOctober 21, 2018 at 10:45 PM

    This comment has been removed by the author.

    ReplyDelete
  8. surnitrayOctober 21, 2018 at 10:49 PM

    This is a great post. I check your blogs regularly but after reading this blog and I’m inspired. It is extremely helpful information. I read such information a lot, for my personal knowledge. I am sharing some important topic now you can you easily get free Roblox Asset Downloader. For more information visit my blog Rassetdownloader

    ReplyDelete
  9. veer singhNovember 20, 2018 at 4:33 AM

    Web Application Development company in delhi india
    http://www.shailcreations.com/web_development.html

    ReplyDelete
  10. GamerjayNovember 21, 2018 at 12:32 AM

    This is a great post. I check your blogs regularly but after reading this blog and I’m inspired. It is extremely helpful information. I read such information a lot, for my personal knowledge. I am sharing some important topic for more information visit my site Gamersupport

    ReplyDelete
  11. UnknownDecember 14, 2018 at 1:01 AM

    This is very detailed and informational post. Thanks a lot.wifi wps wpa tester apk wifi master key apk fakegps

    ReplyDelete
  12. AnonymousDecember 25, 2018 at 4:15 AM


    Merry ChristMas & Happy New Year!

    Merry Christmas Wishes SMS Messages Status

    Happy New Year Messages Wishes SMS

    Happy Christmas Sms Status Wishes Messages Greetings

    Happy New Year Wishes Quotes Messages

    ReplyDelete
  13. 123 HP Printer SetupJanuary 1, 2019 at 12:15 AM

    Excellent post. To get support or guidance regarding the setup of your printer you can visit HP Envy 5540 Troubleshooting printer support webpage

    ReplyDelete
  14. Numan SheikhJanuary 12, 2019 at 11:52 AM

    You can select the bet which is best suited for you. Sometimes betting might seem complex and confusing, but there are certain world cup cricket betting tips that is important for you to remember and understand the cricket betting markets. You have to take certain decisions in the cricket betting that will lead you to success.

    Get the best cricket betting tips online at www.PlayClues.com

    ReplyDelete
  15. UnknownFebruary 15, 2019 at 7:04 AM

    I read this article it is really great article. Thankyou so much. Altered Dichen Lachman Carbon Coat

    ReplyDelete

Post a Comment

Popular posts from this blog

PHP, MySQL, JavaScript & HTML5 All-in-One For Dummies

Image
PHP, javascript, and HTML5 are essential programming languages for creating dynamic websites that work with the MySQL database. PHP and MySQL provide a robust, easy-to-learn, open-source solution for creating superb e-commerce sites and content management. javascript and HTML5 add support for the most current multimedia effects. This one-stop guide gives you what you need to know about all four! Seven self-contained mini books cover web technologies, HTML5 and CSS3, PHP programming, MySQL databases, javascript, PHP with templates, and web applications.
Read more

3 Best Applications that Organize your Chat and Messaging Accounts

Image
Vast of Instant Messaging (IM) platforms are made available in the internet nowadays. It helps every users to easily exchange messages, multimedia or even real-time virtual interaction with each other through computers and other portable devices. These mode of communication are somewhat important for everyone in this modern society and this applications plays a very essential and effective role in our daily living. Some of us are just busy interacting with people in such a way of bringing everyone closer, business matters, family, friends and others. Facebook Messenger, WeChat, Skype, Google Hangouts and Slack are just a few to mention of this platforms, it offers similar services but with quite different features. One has to sign up with these IM applications to start communicating and most of this services are being offered free. As of these days, people do have multiple accounts in different platforms, interacting people from different sides for different matters. As for me, I ...
Read more

Japan Style: Architecture Interiors Design

Image
Enter the world of the stylish Japanese house, where every object in sight is a work of art. Japan Style introduces 20 special residences. With more than 200 color photographs, this book showcases the stunning beauty of old homes, and reveals how they are cared for by their owners. Traditional Japanese homes, with superbly crafted fine wood, great workmanship and seasonal interior arrangements, have an aesthetic of infinite simplicity. Unlike Japanese inns and historical buildings, the houses featured in this book are private property and are not open to public viewing. Japan Style offers a rare glimpse into the intimate world of the everyday Japanese and fascinating insight into the traditional architecture of Japan download link http://libgen.io/_ads/E7F3D5D3E376CB1E116D00AFC8E89AC4 .
Read more