POZ_SUPP_ADDR_TAX_PROF

Details

Schema: FUSION
Object owner: POZ
Object type: VIEW

Columns

Name
PARTY_TAX_PROFILE_ID PARTY_ID PARTY_SITE_ID

Name

PARTY_TAX_PROFILE_ID

PARTY_ID

PARTY_SITE_ID

Query

SQL_Statement
SELECT zptp.PARTY_TAX_PROFILE_ID, decode(zptp.party_type_code, 'THIRD_PARTY', zptp.party_id, 'THIRD_PARTY_SITE', (select hps.party_id from hz_party_sites hps where hps.party_site_id = zptp.party_id)) party_id, decode(zptp.party_type_code, 'THIRD_PARTY_SITE', zptp.party_id, null) party_site_id FROM zx_party_tax_profile zptp

SQL_Statement

SELECT

zptp.PARTY_TAX_PROFILE_ID,

decode(zptp.party_type_code, 'THIRD_PARTY', zptp.party_id, 'THIRD_PARTY_SITE', (select hps.party_id from hz_party_sites hps where hps.party_site_id = zptp.party_id)) party_id,

decode(zptp.party_type_code, 'THIRD_PARTY_SITE', zptp.party_id, null) party_site_id

FROM

zx_party_tax_profile zptp