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'
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'
|
|
|