How to retrieve Tax Profile > Classifications data (Fiscal Classification) via SQL

Hi everyone,

I’m working with Oracle ERP Cloud (Tax) and I need to retrieve, via SQL, the same information shown in the UI on custommer site, under:

Tax Profile → Classifications

Specifically, I’m looking for the following fields:

• Fiscal Classification Type Code
• Fiscal Classification Type Name
• Fiscal Classification Code
• Fiscal Classification Name
• Start Date
• End Date

• In which table(s) is the Fiscal Classification data assigned to a customer stored?

• How is this data linked to the customer or customer site (Party / Party Site / Party Tax Profile)?