1. Tables and Views for Procurement
  2. POZ_TAX_AUTHORITY_V

POZ_TAX_AUTHORITY_V

Details

  • Schema: FUSION

  • Object owner: POZ

  • Object type: VIEW

Columns

Name

PARTY_TAX_PROFILE_ID

PARTY_TYPE_CODE

PARTY_NAME

PARTY_ID

Query

SQL_Statement

SELECT ZxPartyTaxProfile.PARTY_TAX_PROFILE_ID,

ZxPartyTaxProfile.PARTY_TYPE_CODE,

PTY.PARTY_NAME,

PTY.PARTY_ID

FROM ZX_PARTY_TAX_PROFILE ZxPartyTaxProfile,

HZ_PARTIES PTY

WHERE ZxPartyTaxProfile.PARTY_TYPE_CODE ='TAX_AUTHORITY'

AND ZxPartyTaxProfile.PARTY_ID = PTY.PARTY_ID