Oracle EBS EBTAX-Tax Statuses

Oracle EBS EBTAX-Tax Statuses

Tables:-
ZX_PARTY_TAX_PROFILE
ZX_SUBSCRIPTION_DETAILS
ZX_REGIMES_USAGES
ZX_MCO_EO_STATUS_V
ZX_REGIMES_VL

SQL Example:-

SELECT
 (SELECT ter.territory_short_name
  FROM fnd_territories_vl ter
  WHERE tax_regim.country_code = ter.territory_code(+)
  ) "Country Name"
,tax_stat.tax_regime_code
,tax_stat.tax
,tax_stat.tax_status_code
,tax_stat.tax_status_name
,tax_stat.content_owner_name
,tax_stat.effective_FROM
,tax_stat.effective_to
,tax_stat.default_status_flag
,tax_stat.default_flg_effective_FROM
,tax_stat.default_flg_effective_to
,tax_stat.allow_exemptions_flag
,tax_stat.allow_rate_override_flag
FROM APPS.ZX_PARTY_TAX_PROFILE PTP,
  APPS.ZX_SUBSCRIPTION_DETAILS ZSD,
  APPS.HR_OPERATING_UNITS HOU,
   APPS.ZX_REGIMES_USAGES ZRU,
  APPS.ZX_MCO_EO_STATUS_V TAX_STAT,
  APPS.ZX_REGIMES_VL TAX_REGIM
          WHERE 1=1 AND tax_stat.tax_regime_code  =tax_regim.tax_regime_code
AND tax_regim.tax_regime_code   =zru.tax_regime_code
AND ptp.party_type_code         = 'OU'
AND ptp.party_id                = hou.organization_id
AND zru.first_pty_org_id        = ptp.party_tax_profile_id
AND zru.first_pty_org_id        = zsd.first_pty_org_id
AND zsd.tax_regime_code         = ZRU.TAX_REGIME_CODE
AND zsd.parent_first_pty_org_id = -99
AND SYSDATE BETWEEN zsd.effective_FROM AND NVL(zsd.effective_to,SYSDATE)
        AND hou.name= '&&';