Need a query to calulate tax rate on the basis of geographic hierarchy
Hi Gurus,
I need a query which can calculate the tax rate on the basis of geographic hierarchy in R12.
I have a query in 11i, same fields i want in R12 also.
Can you please help me to write down the query.
11i query :-
SELECT LOC_COUNTY.COUNTY, LOC_STATE.STATE, LOC_CITY.CITY, LOC_CITY.CITY_ID,
LOC_COUNTY.COUNTY_ID, LOC_STATE.STATE_ID,
ar.start_date, ar.end_date, ar.tax_rate, ar.from_postal_code, ar.to_postal_code
FROM (SELECT location_segment_value state, location_segment_description,
location_segment_id state_id
FROM apps_fnd.ar_location_values
I need a query which can calculate the tax rate on the basis of geographic hierarchy in R12.
I have a query in 11i, same fields i want in R12 also.
Can you please help me to write down the query.
11i query :-
SELECT LOC_COUNTY.COUNTY, LOC_STATE.STATE, LOC_CITY.CITY, LOC_CITY.CITY_ID,
LOC_COUNTY.COUNTY_ID, LOC_STATE.STATE_ID,
ar.start_date, ar.end_date, ar.tax_rate, ar.from_postal_code, ar.to_postal_code
FROM (SELECT location_segment_value state, location_segment_description,
location_segment_id state_id
FROM apps_fnd.ar_location_values
0