VIEW: APPS.AR_ETAX_L_VL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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