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 |