Friday, April 12, 2013

E-business Tax: Query to list TAX_RATE_CODE based on Operating Unit in R12













In R12, we have E-Business Tax module to maintain the Tax Details. Every TAX_RATE_CODE is attached to a TAX_REGIME and in-turn a TAX_REGIME is tagged to one or more Operating Units. Below query is used to list down the TAX_RATE_CODES attached to a Operating Unit.

SELECT hou.organization_id,
       hou.set_of_books_id,
       hou.default_legal_context_id,
       hou.short_code,
       hou.NAME,
       zru.first_pty_org_id party_tax_profile_id,
       zru.tax_regime_id,
       zru.tax_regime_code,
       zxr.tax,
       zxr.tax_status_code,
       zxr.tax_rate_code,
       zxr.tax_jurisdiction_code,
       zxr.rate_type_code,
       zxr.recovery_type_code,
       zxr.percentage_rate,
       zxr.tax_rate_id,
       zxr.effective_from,
       zxr.effective_to,
       zxr.active_flag,
       zxr.attribute3,
       zxr.offset_tax,
       zxr.offset_status_code,
       zxr.offset_tax_rate_code
  FROM zx_party_tax_profile      ptp,
       zx_subscription_details   zsd,
       hr_operating_units        hou,    
       zx_regimes_usages         zru,
       zx_rates_vl               zxr
 WHERE zxr.tax_regime_code         = zru.tax_regime_code  
   AND ptp.party_type_code         = 'OU'  
   AND ptp.party_id                = hou.organization_id
   AND zru.first_pty_org_id        = ptp.party_tax_profile_id
   AND zru.first_pty_org_id        = zsd.first_pty_org_id
   AND zsd.tax_regime_code         = ZRU.TAX_REGIME_CODE
   AND zsd.parent_first_pty_org_id = -99
   AND SYSDATE BETWEEN zsd.effective_from AND NVL(zsd.effective_to,SYSDATE);
Below query is to list down the tax account based on Operating Unit,
SELECT hou.organization_id,
       hou.NAME,
       tax_account_ccid,
       zxr.tax,
       zxr.tax_status_code,
       zxr.tax_regime_code,
       zxr.tax_rate_code,
       zxr.tax_jurisdiction_code,
       zxr.rate_type_code,
       zxr.percentage_rate,
       zxr.tax_rate_id,
       zxr.effective_from,
       zxr.effective_to,
       zxr.active_flag
  FROM zx_rates_vl        zxr,
       zx_accounts        b,
       hr_operating_units hou
 WHERE b.internal_organization_id = hou.organization_id
   AND b.tax_account_entity_code = 'RATES'
   AND b.tax_account_entity_id = zxr.tax_rate_id
   AND zxr.active_flag = 'Y'
   AND SYSDATE BETWEEN zxr.effective_from AND nvl(zxr.effective_to, SYSDATE);

46 Responses to “E-business Tax: Query to list TAX_RATE_CODE based on Operating Unit in R12”

Raju said...
October 5, 2016 at 5:21 AM

Change the where condition of the first query as
AND SYSDATE BETWEEN zxr.effective_from AND NVL(zxr.effective_to,SYSDATE);


Anonymous said...
June 9, 2017 at 11:02 AM

Good work.. thank you


Mr.San said...
October 16, 2018 at 1:37 AM

Thanks for helpful query


Robert said...
June 6, 2020 at 2:53 AM

Great article Lot's of information to Read...Great Man Keep Posting and update to People..Thanks buy instagram likes cheapest


Robert said...
June 6, 2020 at 3:03 AM

nice bLog! its interesting. thank you for sharing.... buy 250 instagram likes


Robert said...
June 6, 2020 at 3:05 AM

Admiring the time and effort you put into your blog and detailed information you offer!.. buy likes instagram cheap


Robert said...
June 6, 2020 at 3:05 AM

This article gives the light in which we can observe the reality. This is very nice one and gives indepth information. Thanks for this nice article. buy gradual instagram likes


Robert said...
June 6, 2020 at 3:13 AM

Interesting post. I Have Been wondering about this issue, so thanks for posting. Pretty cool post.It 's really very nice and Useful post.Thanks free instagram likes instantly trial


Robert said...
June 6, 2020 at 3:14 AM

This is just the information I am finding everywhere. Thanks for your blog, I just subscribe your blog. This is a nice blog.. buy instagram likes uk instant


Robert said...
June 6, 2020 at 3:17 AM

I really loved reading your blog. It was very well authored and easy to undertand. Unlike additional blogs I have read which are really not tht good. I also found your posts very interesting. In fact after reading, I had to go show it to my friend and he ejoyed it as well! 50 instagram likes instantly


Robert said...
June 6, 2020 at 3:18 AM

All the contents you mentioned in post is too good and can be very useful. I will keep it in mind, thanks for sharing the information keep updating, looking forward for more posts.Thanks buy gradual instagram likes paypal


Robert said...
June 6, 2020 at 3:37 AM

I am happy to find your distinguished way of writing the post. Now you make it easy for me to understand and implement the concept. Thank you for the post. buy 50 likes on ig


Robert said...
June 6, 2020 at 3:38 AM

Nice post! This is a very nice blog that I will definitively come back to more times this year! Thanks for informative post. buy real instagram likes and views


Robert said...
June 6, 2020 at 3:42 AM

Thanks for taking the time to discuss that, I feel strongly about this and so really like getting to know more on this kind of field. Do you mind updating your blog post with additional insight? It should be really useful for all of us. buy instagram picture likes


Robert said...
June 6, 2020 at 3:43 AM

Thanks for posting this info. I just want to let you know that I just check out your site and I find it very interesting and informative. I can't wait to read lots of your posts. buying 50 likes on instagram


Robert said...
June 6, 2020 at 4:11 AM

I really thank you for the valuable info on this great subject and look forward to more great posts. Thanks a lot for enjoying this beauty article with me. I am appreciating it very much! Looking forward to another great article. Good luck to the author! All the best! buy likes with paypal


Robert said...
June 6, 2020 at 4:12 AM

You’ve got some interesting points in this article. I would have never considered any of these if I didn’t come across this. Thanks!. get instagram likes free trial


Robert said...
June 6, 2020 at 4:14 AM

Thank you for helping people get the information they need. Great stuff as usual. Keep up the great work!!! free instagram likes and likes app


Robert said...
June 6, 2020 at 4:14 AM

Great article with excellent idea!Thank you for such a valuable article. I really appreciate for this great information.. instagram likes instantly free


Robert said...
June 6, 2020 at 4:51 AM

I am happy to find this post Very useful for me, as it contains lot of information. I Always prefer to read The Quality and glad I found this thing in you post. Thanks drip likes instagram


Robert said...
June 6, 2020 at 4:52 AM

This is truly a great read for me. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work!. buy 50 real instagram likes


Robert said...
June 6, 2020 at 4:53 AM

I'm glad to see the great detail here!. buy instagram likes online


Robert said...
June 6, 2020 at 4:54 AM

Thank you for very usefull information.. buy likes on instagram cheap


Robert said...
June 6, 2020 at 5:14 AM

Thanks a lot for sharing us about this update. Hope you will not get tired on making posts as informative as this. purchase 50 instagram likes


Robert said...
June 6, 2020 at 5:15 AM

Great knowledge, do anyone mind merely reference back to it ig likes cheap


Robert said...
June 6, 2020 at 5:16 AM

Fantastic blog you have here. You’ll discover me looking at your stuff often. Saved! buy ig likes fast


Robert said...
June 6, 2020 at 5:17 AM

Thanks for every other informative site. The place else may just I get that kind of information written in such an ideal means? I have a venture that I’m just now operating on, and I have been on the look out for such information. drip feed instagram


Robert said...
June 6, 2020 at 5:23 AM

Thank you for some other informative blog. Where else could I get that type of information written in such an ideal means? I have a mission that I’m just now working on, and I have been at the look out for such information. buy uk instagram likes


albina N muro said...
July 14, 2020 at 12:37 AM

This is the type of information I’ve long been trying to find. Thank you for writing this information. free instagram likes and followers app


Clara A. Harris said...
July 30, 2020 at 9:17 AM

Keep up the best work guys, nice posts are here to get more benefits.erp software dubai


ferindo said...
December 8, 2020 at 7:17 AM

Nice post. I learn some thing much harder on different blogs everyday. It will always be stimulating you just read content from other writers and employ a specific thing at their store. I’d opt to apply certain using the content on my own blog whether you don’t mind. Natually I’ll provide a link on your own web weblog. Many thanks sharing. Water Meter Amico


samsung 9 kg fully automatic top load washing machine said...
June 19, 2021 at 5:22 AM

Enjoyed every single word of your blog article. Thanks to share it!


saniyaa said...
February 1, 2022 at 7:03 AM

Hi! This is my first visit to your blog! We are a team of volunteers and new initiatives in the same niche. Blog gave us useful information to work. You have done an amazing job!  Samsung Galaxy M01 Price


Eliaz Beth said...
April 6, 2022 at 2:52 AM

This article will guide you through the small business tax maze and describe in details the various tax types your small business may be expose to. Use the article to learn which federal and state taxes you, as the owner of a sole proprietorship, general member in an LLC or officer of an S. Corporation is responsible for. webpage


used tires shop open near me said...
April 11, 2022 at 6:52 PM

The tire market has different sizes, styles, and brands, and understanding which tire can work for your vehicle may be confusing. We provide exceptional tire services from tire replacement, tire rotation, and everything your vehicle needs.


Carol Roberts said...
April 11, 2022 at 6:56 PM

He is a well-respected businessman/leader in the community motorcycle auto body shop near me and has received many awards for various competitions in his field. His son Franco continues to follow in his footsteps. In keeping up with business ethics and determination. Franco strives for excellence, perfection and quality.


lipo near me said...
April 11, 2022 at 6:59 PM

She finds great satisfaction in bringing focused medicine, health, and wellness, to her patients. Dr. has a personable and intimate rapport with her patients throughout their inner and outer health journey. She has enjoyed counseling patients and has addressed patients beyond the scope of traditional gynecology. In addition, Dr. cares for men in addressing their hormonal imbalances.


williamson's menu said...
April 11, 2022 at 7:02 PM

Williamson Caterers offers a variety of menus and packages including All-Inclusive Wedding Packages, Station Menus, Cocktail Party Selections, Brunch and Buffet Menus, and Cook-Outs. Williamson Caterers welcomes the opportunity to customize a menu specific to your event budget and needs.


top construction company in new york said...
April 11, 2022 at 7:05 PM

Buildrite has a fine and friendly approach towards its clients. Their main focus remains satisfied and pleased customers that are acquired through reliance, integrity, proficiency, and high-quality services.


cabinet & stone city said...
April 11, 2022 at 7:08 PM

Our expert designers are dedicated to producing layouts that ensure your design is distinctive to our clients' liking as well as functional. We warmly invite you to browse our website or visit our freshly remodeled showroom to witness for yourself how Cabinet & Stone City can provide luxury without the cost!


trucker company worldwide said...
April 11, 2022 at 7:23 PM

We are a full-service trucking company established worldwide to add convenience and pace in freight transportation for commercial purposes. Maintaining the safest driving records on the road.


valorant phoenix jacket said...
April 11, 2022 at 7:26 PM

Fame Jackets have so far served many of customers and thus we can claim to have customers wearing our jackets throughout the world. To make sure smooth and efficient shipping and delivery solutions Fame Jackets collaborate with the premium courier services working internationally.


email verify said...
April 11, 2022 at 7:29 PM

World's Smartest email List Cleaning Service, Quick, simple and accurate. Bulk Mail Verifier will not only save you time but tons of money too!


Anonymous said...
May 9, 2022 at 5:00 AM

شركه تنظيف بالجبيل


Node Unblocker said...
June 24, 2022 at 12:56 AM

Great article.Do you want to unblock your content restricted website, then you can check one article about Node Unblocker this website will help you access your content restricted website, by using node unblocker.


Anonymous said...
July 7, 2022 at 2:34 AM

Incredible blog. Want to know how to download the Cracked apps? If yes, then you can download any Cracked apps with the help of OGzilla. It is the simplest and fastest to download any premium app without any cost for more info. go and visit our site OGzilla.


Post a Comment

Disclaimer

The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.