View: AR_TRX_TAX_L_VL

Product:	AR - Receivables
Description:	transaction tax line mls extract
Implementation/DBA Data:	APPS.AR_TRX_TAX_L_VL

View Text

SELECT /*+ INDEX(L AR_XLA_LINES_EXTRACT_N1) */ VTLF.PRINTED_TAX_NAME TAX_PRINTED_NAME
, L.EVENT_ID EVENT_ID
, L.LINE_NUMBER LINE_NUMBER
, VTLF.LANGUAGE LANGUAGE
, L.LEDGER_ID LEDGER_ID
FROM AR_VAT_TAX_ALL_TL VTLF
, AR_XLA_LINES_EXTRACT L
WHERE L.TAX_CODE_ID = VTLF.VAT_TAX_ID (+)
AND L.LEVEL_FLAG = 'L'
AND L.ORG_ID = VTLF.ORG_ID (+)

Columns