How do you Query "Tax Rate Code" for PO lines as shown via Manage Tax menu path?
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