View: ZX_AP_TAX_JRNL_LINE_DESC_V

Product:	FND - Application Object Library
Description:
Implementation/DBA Data:	APPS.ZX_AP_TAX_JRNL_LINE_DESC_V

View Text

SELECT TAX_DIST.REC_NREC_TAX_DIST_ID REC_NREC_TAX_DIST_ID
, REGIMES_TL.TAX_REGIME_NAME TAX_REGIME_NAME
, TAXES_TL.TAX_FULL_NAME TAX_FULL_NAME
, STATUS_TL.TAX_STATUS_NAME TAX_STATUS_NAME
, RATES_TL.TAX_RATE_NAME TAX_RATE_NAME
, JUR.TAX_JURISDICTION_CODE TAX_JURISDICTION_CODE
, REC_RATES_TL.TAX_RATE_NAME RECOVERY_RATE_NAME
, TAX_DIST.RECOVERY_TYPE_CODE RECOVERY_TYPE_CODE FROM ZX_REC_NREC_DIST TAX_DIST
, ZX_RATES_TL REC_RATES_TL
, ZX_REGIMES_TL REGIMES_TL
, ZX_TAXES_TL TAXES_TL
, ZX_STATUS_TL STATUS_TL
, ZX_RATES_TL RATES_TL
, ZX_JURISDICTIONS_B JUR WHERE TAX_DIST.RECOVERY_RATE_ID = REC_RATES_TL.TAX_RATE_ID (+) AND TAX_DIST.TAX_REGIME_ID = REGIMES_TL.TAX_REGIME_ID AND TAX_DIST.TAX_ID = TAXES_TL.TAX_ID AND TAX_DIST.TAX_STATUS_ID = STATUS_TL.TAX_STATUS_ID AND TAX_DIST.TAX_RATE_ID = RATES_TL.TAX_RATE_ID AND REGIMES_TL.LANGUAGE = TAXES_TL.LANGUAGE AND REGIMES_TL.LANGUAGE = STATUS_TL.LANGUAGE AND REGIMES_TL.LANGUAGE = RATES_TL.LANGUAGE AND NVL(REC_RATES_TL.LANGUAGE
, USERENV('LANG')) = USERENV('LANG') AND REGIMES_TL.LANGUAGE = USERENV('LANG') AND TAX_DIST.TAX_JURISDICTION_ID = JUR.TAX_JURISDICTION_ID(+)