Saturday, January 29, 2022

Query to find all jurisdiction's for which Tax Rates Has been defined in Oracle APPS


SELECT tax      
,tax_jurisdiction_code
	  ,geography_element2_code state_code
	  ,geography_element3_code county_code
	  ,geography_element4_code city_code  
FROM zx_jurisdictions_b tax_juridiction      
,hz_geographies geography 
WHERE tax_juridiction.tax_regime_code = '<<tax_regime_code>>'   
AND SYSDATE BETWEEN tax_juridiction.effective_from AND NVL(tax_juridiction.effective_to,'31-dec-4999')   
AND tax_juridiction.zone_geography_id=geography.geography_id   
AND tax_juridiction.tax = geography.geography_type   
AND SYSDATE BETWEEN geography.start_date AND geography.end_date   
AND NOT EXISTS (SELECT 1                     
FROM zx_rates_b zr                    
WHERE zr.tax_regime_code='<<tax_regime_code>>'                      
AND zr.tax_jurisdiction_code = tax_juridiction.tax_jurisdiction_code
				  )
ORDER BY tax        
,tax_jurisdiction_code
		,geography_element2_code
		,geography_element3_code 

  ,geography_element4_code 

No comments:

Post a Comment

How to improve blog performance

Improving the performance of a blog can involve a variety of strategies, including optimizing the website's technical infrastructure, im...