ZX_SERVICE_OWNER_V

Details

• Schema: FUSION

• Object owner: FND

• Object type: VIEW

Columns

Name
PARTY_TAX_PROFILE_ID PARTY_NAME PARTY_TYPE_CODE

Query

SQL_Statement
SELECT PARTY_TAX_PROFILE_ID, PARTY_NAME, PARTY_TYPE_CODE FROM ZX_FIRST_PARTY_ORGS_MOAC_V UNION ALL SELECT ptp.PARTY_TAX_PROFILE_ID, hp.PARTY_NAME, ptp.PARTY_TYPE_CODE FROM hz_parties hp, zx_party_tax_profile ptp WHERE hp.party_id = ptp.party_id AND ptp.party_type_code = 'TAX_PARTNER'