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

Drilldown from GL to Inventory Transactions, Inv to gl Link Query R12,Inventory to General ledger links, r12 ,Inv to gl drill down

Drilldown from GL to Inventory Transactions, Inv to gl Link Query R12,Inventory to General ledger links, r12 ,Inv to gl drill down Link bet...