AR_ETAX_L_VL

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name
ETAX_REGIME_NAME ETAX_FULL_NAME ETAX_STATUS_NAME ETAX_RATE_NAME ETAX_JURISDICTION_CODE EVENT_ID LINE_NUMBER LANGUAGE LEDGER_ID

Query

SQL_Statement

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