View: AR_CM_ETAX_L_VL

Product:	AR - Receivables
Description:	Ebusiness tax sources to AR XLA uptake for Credit Memo languages sensitive sources
Implementation/DBA Data:	APPS.AR_CM_ETAX_L_VL

View Text

SELECT /*+INDEX(L AR_XLA_LINES_EXTRACT_N1) */ VTLD.TAX_REGIME_NAME CM_ETAX_REGIME_NAME
, VTLD.TAX_FULL_NAME CM_ETAX_FULL_NAME
, VTLD.TAX_STATUS_NAME CM_ETAX_STATUS_NAME
, VTLD.TAX_RATE_NAME CM_ETAX_RATE_NAME
, VTLD.TAX_JURISDICTION_CODE CM_ETAX_JURISDICTION_CODE
, L.EVENT_ID EVENT_ID
, L.LINE_NUMBER LINE_NUMBER
, VTLD.LANGUAGE LANGUAGE
, L.LEDGER_ID LEDGER_ID
FROM ZX_JRNL_LINE_DESC_V VTLD
, AR_XLA_LINES_EXTRACT L
WHERE L.TAX_LINE_ID = VTLD.TAX_LINE_ID
AND L.LEVEL_FLAG = 'L'
AND L.EVENT_TYPE_CODE IN ('CM_CREATE'
, 'CM_UPDATE') GROUP BY VTLD.TAX_REGIME_NAME
, VTLD.TAX_FULL_NAME
, VTLD.TAX_STATUS_NAME
, VTLD.TAX_RATE_NAME
, VTLD.TAX_JURISDICTION_CODE
, L.EVENT_ID
, L.LINE_NUMBER
, VTLD.LANGUAGE
, L.LEDGER_ID

Columns