Supplier's Tax Classification Code SQL Query

Supplier Level - Tax Classification Code

SQL

SELECT HP.PARTY_NAME            SUPPLIER_NAME,
       SUP.SEGMENT1             SUPPLIER_NUMBER,
       ZTAX.TAX_CLASSIFICATION_CODE,
       ZREG.TAX_REGIME_CODE,
       ZREG.REGISTRATION_NUMBER TAX_REGISTRATION_NUMBER,
       ZREG.EFFECTIVE_FROM
FROM   ZX_PARTY_TAX_PROFILE ZTAX,
       ZX_REGISTRATIONS ZREG,
       HZ_PARTIES HP,
       POZ_SUPPLIERS SUP
WHERE  1=1
       AND ZTAX.PARTY_ID = HP.PARTY_ID
       AND ZTAX.PARTY_TYPE_CODE = 'THIRD_PARTY'
       AND ZREG.PARTY_TAX_PROFILE_ID (+) = ZTAX.PARTY_TAX_PROFILE_ID
       AND HP.PARTY_ID = SUP.PARTY_ID
       AND SUP.SEGMENT1 = '1068' -- SUPPLIER NUMBER

Supplier Address Level - Tax Classification Code

SQL

SELECT HP.PARTY_NAME            SUPPLIER_NAME,
       SUP.SEGMENT1             SUPPLIER_NUMBER,
       HPS.PARTY_SITE_NAME,
       ZTAX.TAX_CLASSIFICATION_CODE,
       ZREG.TAX_REGIME_CODE,
       ZREG.REGISTRATION_NUMBER TAX_REGISTRATION_NUMBER,
       ZREG.EFFECTIVE_FROM
FROM   ZX_PARTY_TAX_PROFILE ZTAX,
       ZX_REGISTRATIONS ZREG,
       HZ_PARTIES HP,
       HZ_PARTY_SITES HPS,
       POZ_SUPPLIERS SUP
WHERE  1=1
       AND ZTAX.PARTY_ID = HPS.PARTY_SITE_ID
       AND ZTAX.SITE_FLAG = 'Y'
       AND HP.PARTY_ID = HPS.PARTY_ID
       AND ZTAX.PARTY_TYPE_CODE = 'THIRD_PARTY_SITE'
       AND ZREG.PARTY_TAX_PROFILE_ID (+) = ZTAX.PARTY_TAX_PROFILE_ID
       AND HP.PARTY_ID = SUP.PARTY_ID
       AND SUP.SEGMENT1 = '1068' -- SUPPLIER NUMBER

SQL(s) Output

Additionally, how can the supplier tax classification code be uploaded at the supplier address level through FBDI?

As per the below Oracle KB Article:

(KB122162) PRC:POZ:Tax Classification Code Not Getting Populated Through Supplier Import Program

//

Solution

Please follow the below steps to update the 'Tax Classification Code' for the Suppliers/Party's via FBDI.
User has to log in with Implementation user to perform this setup.

1. Go to Task Manage Tax Regimes → Click Rapid Setup Spreadsheet → "Download Tax Implementation Workbook"
2. Go to → Party Classifications tab in the Excel spreadsheet and Right Click on it and unhide the 'Party Tax Profile Controls' tab and provide 'Party type' as third Party and Party number, Party name and Tax Classification Code and save the sheet.
3. Convert into CSV & load zip into Rapid Setup Spreadsheet → Load Tax Implementation Workbook .
4. Migrate the solution as appropriate to other environments.

Cause

Tax classification code will not be updated using Supplier Import Program.

//