Receivables - EBS (MOSC)

MOSC Banner

Need a query to calulate tax rate on the basis of geographic hierarchy

edited Jan 7, 2013 6:54AM in Receivables - EBS (MOSC) 5 commentsAnswered
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     

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center