Oracle customer tax profile table

Oracle customer tax profile table

In this post , We will be discuss about oracle customer tax profile table. Customer tax profile table helps to store the default customer Tax informations which we can set for the customer in oracle apps. In oracle customer tax profile table helps to store the Default Tax apply flag and the Default Tax classification code informations maintained at customer Site Level. Here below i will try to share more about oracle customer tax profile table.

Oracle customer tax profile table

Important oracle customer tax profile table

1. ZX_PARTY_TAX_PROFILE

2. ZX_REGISTRATIONS

SQL query Using Oracle customer tax profile table

Here below is the SQL query using Oracle customer tax profile table.

SELECT 

hp.PARTY_NUMBER Party_Number,

hp.PARTY_name,

hca.ACCOUNT_NUMBER,

hca.customer_type "Account Type",

hps.PARTY_SITE_NUMBER PARTY_SITE_NUMBER,

hps.PARTY_SITE_NAME PARTY_SITE_NAME,

,hl.ADDRESS1 Address_Line_1

,hl.ADDRESS2 Address_Line_2

,hl.ADDRESS3 Address_Line_3

,hl.ADDRESS4 Address_Line_4

,hl.CITY City

,hl.STATE STATE

,hl.PROVINCE Province

,hl.COUNTY County

,hl.POSTAL_CODE Postal_Code

,hl.COUNTRY Country

,hps.IDENTIFYING_ADDRESS_FLAG IDENTIFYING_ADDRESS

,hcsua.SITE_USE_CODE PURPOSE

,hcsua.primary_flag,

(select CONCATENATED_SEGMENTS from apps.gl_code_combinations_kfv

where code_combination_id=hcsua.GL_ID_REC) REC_ACCT,

(select CONCATENATED_SEGMENTS from apps.gl_code_combinations_kfv

where code_combination_id=hcsua.GL_ID_REV) REV_ACCT,

hp.JGZZ_FISCAL_CODE TAX_PAYER_ID_INFO,

hcas.attribute_category,

hcas.attribute1,

hcas.attribute2,

(select tax_classification_code from apps.ZX_PARTY_TAX_PROFILE

where tax_classification_code is not null

AND PARTY_ID=hp.party_id) customer_tax_classficiation,

hcsua.tax_code

FROM apps.hz_parties hp

    ,apps.hz_party_sites hps

    ,apps.hz_cust_accounts hca

    ,apps.hz_cust_acct_sites_all hcas

    ,apps.hr_operating_units hou

    ,apps.hz_party_usg_assignments hpua

    ,apps.hz_locations hl

    ,apps.hz_cust_site_uses_all hcsua

WHERE hp.party_id = hca.party_id

    AND hp.party_id = hps.party_id

    AND hp.STATUS = 'A'

    AND hca.STATUS = 'A'

    AND hcas.STATUS = 'A'

    AND hp.party_id = hpua.party_id

    AND hpua.PARTY_USAGE_CODE = 'CUSTOMER'

    AND HCAS.CUST_ACCT_SITE_ID=hcsua.CUST_ACCT_SITE_ID

    AND hcas.org_id = hou.organization_id

    AND hca.cust_account_id = hcas.cust_account_id

    AND HCAS.PARTY_SITE_ID=hps.PARTY_SITE_ID

    AND hou.organization_id=:P_ORG_ID

    and hps.LOCATION_ID=hl.LOCATION_ID

Oracle customer tax profile table