Sunday 8 July 2018

Oracle Tax Regime and Operating Unit Join Query

select
distinct a.tax_regime_code,c.name,c.* from ZX_RATES_B a,zx_accounts b, hr_operating_units c
where a.tax_rate_id=b.tax_account_entity_id
and b.internal_organization_id=c.organization_id;

No comments:

Post a Comment