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);

31 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


Unknown said...
December 29, 2018 at 8:26 PM

Thanks and Regards. Oracle Apps R12 Training Videos at affordable cost. please check oracleappstechnical.com


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


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.