AR_ETAX_ACCOUNTS_L

Details

Schema: FUSION
Object owner: AR
Object type: VIEW

Columns

Name
ETAX_JUR_ADJ_CCID ETAX_JUR_ADJ_NR_TAX_CCID ETAX_JUR_EDISC_CCID ETAX_JUR_EDISC_NR_TAX_CCID ETAX_JUR_FCHRG_CCID ETAX_JUR_FCHRG_NR_TAX_CCID ETAX_JUR_INTERIM_TAX_CCID ETAX_JUR_TAX_ACCOUNT_CCID ETAX_JUR_UNED_CCID ETAX_JUR_UNED_NR_TAX_CCID ETAX_RATE_ADJ_CCID ETAX_RATE_ADJ_NR_TAX_CCID ETAX_RATE_EDISC_CCID ETAX_RATE_EDISC_NR_TAX_CCID ETAX_RATE_FCHRG_CCID ETAX_RATE_FCHRG_NR_TAX_CCID ETAX_RATE_INTERIM_TAX_CCID ETAX_RATE_TAX_ACCOUNT_ID ETAX_RATE_UNED_CCID ETAX_RATE_UNED_NR_TAX_CCID ETAX_RATE_DIST_VAT_ID EVENT_ID LINE_NUMBER LEDGER_ID

Name

ETAX_JUR_ADJ_CCID

ETAX_JUR_ADJ_NR_TAX_CCID

ETAX_JUR_EDISC_CCID

ETAX_JUR_EDISC_NR_TAX_CCID

ETAX_JUR_FCHRG_CCID

ETAX_JUR_FCHRG_NR_TAX_CCID

ETAX_JUR_INTERIM_TAX_CCID

ETAX_JUR_TAX_ACCOUNT_CCID

ETAX_JUR_UNED_CCID

ETAX_JUR_UNED_NR_TAX_CCID

ETAX_RATE_ADJ_CCID

ETAX_RATE_ADJ_NR_TAX_CCID

ETAX_RATE_EDISC_CCID

ETAX_RATE_EDISC_NR_TAX_CCID

ETAX_RATE_FCHRG_CCID

ETAX_RATE_FCHRG_NR_TAX_CCID

ETAX_RATE_INTERIM_TAX_CCID

ETAX_RATE_TAX_ACCOUNT_ID

ETAX_RATE_UNED_CCID

ETAX_RATE_UNED_NR_TAX_CCID

ETAX_RATE_DIST_VAT_ID

EVENT_ID

LINE_NUMBER

LEDGER_ID

Query

SQL_Statement
SELECT /+INDEX(l ar_xla_lines_extract_n1)/ NVL2(l.location_segment_id,loca.LOC_ADJ_CCID ,jra.JUR_ADJ_CCID ) etax_jur_adj_ccid ,NVL2(l.location_segment_id,loca.LOC_ADJ_NON_REC_TAX_CCID,jra.JUR_ADJ_NON_REC_TAX_CCID) etax_jur_adj_nr_tax_ccid ,NVL2(l.location_segment_id,loca.LOC_EDISC_CCID,jra.JUR_EDISC_CCID) etax_jur_edisc_ccid ,NVL2(l.location_segment_id,loca.loc_edisc_non_rec_tax_ccid,jra.JUR_EDISC_NON_REC_TAX_CCID) etax_jur_edisc_nr_tax_ccid ,NVL2(l.location_segment_id,loca.loc_finchrg_ccid,jra.JUR_FINCHRG_CCID) etax_jur_fchrg_ccid ,NVL2(l.location_segment_id,loca.loc_finchrg_non_rec_tax_ccid,jra.JUR_FINCHRG_NON_REC_TAX_CCID) etax_jur_fchrg_nr_tax_ccid ,NVL2(l.location_segment_id,loca.loc_interim_tax_ccid,jra.JUR_INTERIM_TAX_CCID) etax_jur_interim_tax_ccid ,NVL2(l.location_segment_id,loca.loc_tax_account_ccid,jra.JUR_TAX_ACCOUNT_CCID) etax_jur_tax_account_ccid ,NVL2(l.location_segment_id,loca.loc_unedisc_ccid,jra.JUR_unedisc_ccid) etax_jur_uned_ccid ,NVL2(l.location_segment_id,loca.loc_unedisc_non_rec_tax_ccid,jra.JUR_unedisc_non_rec_tax_ccid) etax_jur_uned_nr_tax_ccid ,jra.rate_adj_ccid etax_rate_adj_ccid ,jra.rate_adj_non_rec_tax_ccid etax_rate_adj_nr_tax_ccid ,jra.rate_edisc_ccid etax_rate_edisc_ccid ,jra.rate_edisc_non_rec_tax_ccid etax_rate_edisc_nr_tax_ccid ,jra.rate_finchrg_ccid etax_rate_fchrg_ccid ,jra.rate_finchrg_non_rec_tax_ccid etax_rate_fchrg_nr_tax_ccid ,jra.rate_interim_tax_ccid etax_rate_interim_tax_ccid ,jra.rate_tax_account_ccid etax_rate_tax_account_id ,jra.rate_unedisc_ccid etax_rate_uned_ccid ,jra.rate_unedisc_non_rec_tax_ccid etax_rate_uned_nr_tax_ccid ,jra.tax_line_id etax_rate_dist_vat_id ,l.event_id event_id ,l.line_number line_number ,l.ledger_id ledger_id FROM ar_xla_lines_extract l ,zx_jrnl_accounts_extract_v jra ,zx_ar_loc_accounts_extract_v loca WHERE l.tax_line_id = jra.tax_line_id AND l.org_id = jra.organization_id AND l.location_segment_id = loca.location_segment_id(+) AND l.org_id = loca.organization_id(+) AND l.level_flag = 'L' GROUP BY NVL2(l.location_segment_id,loca.LOC_ADJ_CCID ,jra.JUR_ADJ_CCID ) ,NVL2(l.location_segment_id,loca.LOC_ADJ_NON_REC_TAX_CCID,jra.JUR_ADJ_NON_REC_TAX_CCID) ,NVL2(l.location_segment_id,loca.LOC_EDISC_CCID,jra.JUR_EDISC_CCID) ,NVL2(l.location_segment_id,loca.loc_edisc_non_rec_tax_ccid,jra.JUR_EDISC_NON_REC_TAX_CCID) ,NVL2(l.location_segment_id,loca.loc_finchrg_ccid,jra.JUR_FINCHRG_CCID) ,NVL2(l.location_segment_id,loca.loc_finchrg_non_rec_tax_ccid,jra.JUR_FINCHRG_NON_REC_TAX_CCID) ,NVL2(l.location_segment_id,loca.loc_interim_tax_ccid,jra.JUR_INTERIM_TAX_CCID) ,NVL2(l.location_segment_id,loca.loc_tax_account_ccid,jra.JUR_TAX_ACCOUNT_CCID) ,NVL2(l.location_segment_id,loca.loc_unedisc_ccid,jra.JUR_unedisc_ccid) ,NVL2(l.location_segment_id,loca.loc_unedisc_non_rec_tax_ccid,jra.JUR_unedisc_non_rec_tax_ccid) ,jra.rate_adj_ccid ,jra.rate_adj_non_rec_tax_ccid ,jra.rate_edisc_ccid ,jra.rate_edisc_non_rec_tax_ccid ,jra.rate_finchrg_ccid ,jra.rate_finchrg_non_rec_tax_ccid ,jra.rate_interim_tax_ccid ,jra.rate_tax_account_ccid ,jra.rate_unedisc_ccid ,jra.rate_unedisc_non_rec_tax_ccid ,jra.tax_line_id ,l.event_id ,l.line_number ,l.ledger_id

SQL_Statement

SELECT /*+INDEX(l ar_xla_lines_extract_n1)*/ NVL2(l.location_segment_id,loca.LOC_ADJ_CCID ,jra.JUR_ADJ_CCID ) etax_jur_adj_ccid ,NVL2(l.location_segment_id,loca.LOC_ADJ_NON_REC_TAX_CCID,jra.JUR_ADJ_NON_REC_TAX_CCID) etax_jur_adj_nr_tax_ccid ,NVL2(l.location_segment_id,loca.LOC_EDISC_CCID,jra.JUR_EDISC_CCID) etax_jur_edisc_ccid ,NVL2(l.location_segment_id,loca.loc_edisc_non_rec_tax_ccid,jra.JUR_EDISC_NON_REC_TAX_CCID) etax_jur_edisc_nr_tax_ccid ,NVL2(l.location_segment_id,loca.loc_finchrg_ccid,jra.JUR_FINCHRG_CCID) etax_jur_fchrg_ccid ,NVL2(l.location_segment_id,loca.loc_finchrg_non_rec_tax_ccid,jra.JUR_FINCHRG_NON_REC_TAX_CCID) etax_jur_fchrg_nr_tax_ccid ,NVL2(l.location_segment_id,loca.loc_interim_tax_ccid,jra.JUR_INTERIM_TAX_CCID) etax_jur_interim_tax_ccid ,NVL2(l.location_segment_id,loca.loc_tax_account_ccid,jra.JUR_TAX_ACCOUNT_CCID) etax_jur_tax_account_ccid ,NVL2(l.location_segment_id,loca.loc_unedisc_ccid,jra.JUR_unedisc_ccid) etax_jur_uned_ccid ,NVL2(l.location_segment_id,loca.loc_unedisc_non_rec_tax_ccid,jra.JUR_unedisc_non_rec_tax_ccid) etax_jur_uned_nr_tax_ccid ,jra.rate_adj_ccid etax_rate_adj_ccid ,jra.rate_adj_non_rec_tax_ccid etax_rate_adj_nr_tax_ccid ,jra.rate_edisc_ccid etax_rate_edisc_ccid ,jra.rate_edisc_non_rec_tax_ccid etax_rate_edisc_nr_tax_ccid ,jra.rate_finchrg_ccid etax_rate_fchrg_ccid ,jra.rate_finchrg_non_rec_tax_ccid etax_rate_fchrg_nr_tax_ccid ,jra.rate_interim_tax_ccid etax_rate_interim_tax_ccid ,jra.rate_tax_account_ccid etax_rate_tax_account_id ,jra.rate_unedisc_ccid etax_rate_uned_ccid ,jra.rate_unedisc_non_rec_tax_ccid etax_rate_uned_nr_tax_ccid ,jra.tax_line_id etax_rate_dist_vat_id ,l.event_id event_id ,l.line_number line_number ,l.ledger_id ledger_id FROM ar_xla_lines_extract l ,zx_jrnl_accounts_extract_v jra ,zx_ar_loc_accounts_extract_v loca WHERE l.tax_line_id = jra.tax_line_id AND l.org_id = jra.organization_id AND l.location_segment_id = loca.location_segment_id(+) AND l.org_id = loca.organization_id(+) AND l.level_flag = 'L' GROUP BY NVL2(l.location_segment_id,loca.LOC_ADJ_CCID ,jra.JUR_ADJ_CCID ) ,NVL2(l.location_segment_id,loca.LOC_ADJ_NON_REC_TAX_CCID,jra.JUR_ADJ_NON_REC_TAX_CCID) ,NVL2(l.location_segment_id,loca.LOC_EDISC_CCID,jra.JUR_EDISC_CCID) ,NVL2(l.location_segment_id,loca.loc_edisc_non_rec_tax_ccid,jra.JUR_EDISC_NON_REC_TAX_CCID) ,NVL2(l.location_segment_id,loca.loc_finchrg_ccid,jra.JUR_FINCHRG_CCID) ,NVL2(l.location_segment_id,loca.loc_finchrg_non_rec_tax_ccid,jra.JUR_FINCHRG_NON_REC_TAX_CCID) ,NVL2(l.location_segment_id,loca.loc_interim_tax_ccid,jra.JUR_INTERIM_TAX_CCID) ,NVL2(l.location_segment_id,loca.loc_tax_account_ccid,jra.JUR_TAX_ACCOUNT_CCID) ,NVL2(l.location_segment_id,loca.loc_unedisc_ccid,jra.JUR_unedisc_ccid) ,NVL2(l.location_segment_id,loca.loc_unedisc_non_rec_tax_ccid,jra.JUR_unedisc_non_rec_tax_ccid) ,jra.rate_adj_ccid ,jra.rate_adj_non_rec_tax_ccid ,jra.rate_edisc_ccid ,jra.rate_edisc_non_rec_tax_ccid ,jra.rate_finchrg_ccid ,jra.rate_finchrg_non_rec_tax_ccid ,jra.rate_interim_tax_ccid ,jra.rate_tax_account_ccid ,jra.rate_unedisc_ccid ,jra.rate_unedisc_non_rec_tax_ccid ,jra.tax_line_id ,l.event_id ,l.line_number ,l.ledger_id