POZ_SUPP_ADDR_TAX_PROF

詳細

スキーマ: FUSION
オブジェクト所有者: POZ
オブジェクト・タイプ: VIEW

列

名前
PARTY_TAX_PROFILE_ID PARTY_ID PARTY_SITE_ID

名前

PARTY_TAX_PROFILE_ID

PARTY_ID

PARTY_SITE_ID

問合せ

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