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 |