Procurement - EBS (MOSC)

MOSC Banner

How do you Query "Tax Rate Code" for PO lines as shown via Manage Tax menu path?

edited Oct 12, 2017 5:07PM in Procurement - EBS (MOSC) 2 commentsAnswered ✓

We have a situation where if you use the copy document feature in core Purchasing, the resulting document no longer defaults changes to the tax classification code.

Per Oracle this is an as designed situation.

I am trying to develop a query of the purchasing tables to view the ship-tos, deliver-tos and the tax rate code that is relevant to the PO,

The tax code can be displayed following the Manange Tax menu path in Core Purchase, as shown in the attached image.

I get this far with the sql, but cannot identify what else to query., what tables do I need

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