[Home] [Help]
View: AR_ETAX_L_VL
Product: | AR - Receivables |
Description: | Ebusiness tax sources to AR XLA uptake for invoice and its applications languages sensitive sources |
Implementation/DBA Data: |
APPS.AR_ETAX_L_VL
|
View Text
SELECT /*+INDEX(L AR_XLA_LINES_EXTRACT_N1) */ VTLD.TAX_REGIME_NAME ETAX_REGIME_NAME
, VTLD.TAX_FULL_NAME ETAX_FULL_NAME
, VTLD.TAX_STATUS_NAME ETAX_STATUS_NAME
, VTLD.TAX_RATE_NAME ETAX_RATE_NAME
, VTLD.TAX_JURISDICTION_CODE 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' 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
Name |
ETAX_REGIME_NAME |
ETAX_FULL_NAME |
ETAX_STATUS_NAME |
ETAX_RATE_NAME |
ETAX_JURISDICTION_CODE |
EVENT_ID |
LINE_NUMBER |
LANGUAGE |
LEDGER_ID |