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);
Do you think this Article is useful?
Subscribe to:
Post Comments (Atom)
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.
46 Responses to “E-business Tax: Query to list TAX_RATE_CODE based on Operating Unit in R12”
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);
June 9, 2017 at 11:02 AM
Good work.. thank you
October 16, 2018 at 1:37 AM
Thanks for helpful query
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
June 6, 2020 at 3:03 AM
nice bLog! its interesting. thank you for sharing.... buy 250 instagram likes
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
June 6, 2020 at 4:53 AM
I'm glad to see the great detail here!. buy instagram likes online
June 6, 2020 at 4:54 AM
Thank you for very usefull information.. buy likes on instagram cheap
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
June 6, 2020 at 5:15 AM
Great knowledge, do anyone mind merely reference back to it ig likes cheap
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
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
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
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
July 30, 2020 at 9:17 AM
Keep up the best work guys, nice posts are here to get more benefits.erp software dubai
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
June 19, 2021 at 5:22 AM
Enjoyed every single word of your blog article. Thanks to share it!
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
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
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.
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.
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.
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.
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.
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!
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.
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.
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!
May 9, 2022 at 5:00 AM
شركه تنظيف بالجبيل
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.
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