AR_CM_ETAX_L_VL

Details

• Schema: FUSION

• Object owner: 'AR'

• Object type: VIEW

Columns

Name
CM_ETAX_REGIME_NAME CM_ETAX_FULL_NAME CM_ETAX_STATUS_NAME CM_ETAX_RATE_NAME CM_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 cm_etax_regime_name , vtld.tax_full_name cm_etax_full_name , vtld.tax_status_name cm_etax_status_name , vtld.tax_rate_name cm_etax_rate_name , vtld.tax_jurisdiction_code cm_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' AND l.event_type_code IN ('CM_CREATE','CM_UPDATE') 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