AR_CM_ETAX_ACCOUNTS_L

Details

Schema: FUSION
Object owner: AR
Object type: VIEW

Columns

Name
CM_ETAX_JUR_ADJ_CCID CM_ETAX_JUR_ADJ_NR_TAX_CCID CM_ETAX_JUR_EDISC_CCID CM_ETAX_JUR_EDISC_NR_TAX_CCID CM_ETAX_JUR_FCHRG_CCID CM_ETAX_JUR_FCHRG_NR_TAX_CCID CM_ETAX_JUR_INTERIM_TAX_CCID CM_ETAX_JUR_TAX_ACCOUNT_CCID CM_ETAX_JUR_UNED_CCID CM_ETAX_JUR_UNED_NR_TAX_CCID CM_ETAX_RATE_ADJ_CCID CM_ETAX_RATE_ADJ_NR_TAX_CCID CM_ETAX_RATE_EDISC_CCID CM_ETAX_RATE_EDISC_NR_TAX_CCID CM_ETAX_RATE_FCHRG_CCID CM_ETAX_RATE_FCHRG_NR_TAX_CCID CM_ETAX_RATE_INTERIM_TAX_CCID CM_ETAX_RATE_TAX_ACCOUNT_ID CM_ETAX_RATE_UNED_CCID CM_ETAX_RATE_UNED_NR_TAX_CCID CM_ETAX_RATE_DIST_VAT_ID EVENT_ID LINE_NUMBER LEDGER_ID

Name

CM_ETAX_JUR_ADJ_CCID

CM_ETAX_JUR_ADJ_NR_TAX_CCID

CM_ETAX_JUR_EDISC_CCID

CM_ETAX_JUR_EDISC_NR_TAX_CCID

CM_ETAX_JUR_FCHRG_CCID

CM_ETAX_JUR_FCHRG_NR_TAX_CCID

CM_ETAX_JUR_INTERIM_TAX_CCID

CM_ETAX_JUR_TAX_ACCOUNT_CCID

CM_ETAX_JUR_UNED_CCID

CM_ETAX_JUR_UNED_NR_TAX_CCID

CM_ETAX_RATE_ADJ_CCID

CM_ETAX_RATE_ADJ_NR_TAX_CCID

CM_ETAX_RATE_EDISC_CCID

CM_ETAX_RATE_EDISC_NR_TAX_CCID

CM_ETAX_RATE_FCHRG_CCID

CM_ETAX_RATE_FCHRG_NR_TAX_CCID

CM_ETAX_RATE_INTERIM_TAX_CCID

CM_ETAX_RATE_TAX_ACCOUNT_ID

CM_ETAX_RATE_UNED_CCID

CM_ETAX_RATE_UNED_NR_TAX_CCID

CM_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 ) cm_etax_jur_adj_ccid ,NVL2(l.location_segment_id,loca.LOC_ADJ_NON_REC_TAX_CCID,jra.JUR_ADJ_NON_REC_TAX_CCID) cm_etax_jur_adj_nr_tax_ccid ,NVL2(l.location_segment_id,loca.LOC_EDISC_CCID,jra.JUR_EDISC_CCID) cm_etax_jur_edisc_ccid ,NVL2(l.location_segment_id,loca.loc_edisc_non_rec_tax_ccid,jra.JUR_EDISC_NON_REC_TAX_CCID) cm_etax_jur_edisc_nr_tax_ccid ,NVL2(l.location_segment_id,loca.loc_finchrg_ccid,jra.JUR_FINCHRG_CCID) cm_etax_jur_fchrg_ccid ,NVL2(l.location_segment_id,loca.loc_finchrg_non_rec_tax_ccid,jra.JUR_FINCHRG_NON_REC_TAX_CCID) cm_etax_jur_fchrg_nr_tax_ccid ,NVL2(l.location_segment_id,loca.loc_interim_tax_ccid,jra.JUR_INTERIM_TAX_CCID) cm_etax_jur_interim_tax_ccid ,NVL2(l.location_segment_id,loca.loc_tax_account_ccid,jra.JUR_TAX_ACCOUNT_CCID) cm_etax_jur_tax_account_ccid ,NVL2(l.location_segment_id,loca.loc_unedisc_ccid,jra.JUR_unedisc_ccid) cm_etax_jur_uned_ccid ,NVL2(l.location_segment_id,loca.loc_unedisc_non_rec_tax_ccid,jra.JUR_unedisc_non_rec_tax_ccid) cm_etax_jur_uned_nr_tax_ccid ,jra.rate_adj_ccid cm_etax_rate_adj_ccid ,jra.rate_adj_non_rec_tax_ccid cm_etax_rate_adj_nr_tax_ccid ,jra.rate_edisc_ccid cm_etax_rate_edisc_ccid ,jra.rate_edisc_non_rec_tax_ccid cm_etax_rate_edisc_nr_tax_ccid ,jra.rate_finchrg_ccid cm_etax_rate_fchrg_ccid ,jra.rate_finchrg_non_rec_tax_ccid cm_etax_rate_fchrg_nr_tax_ccid ,jra.rate_interim_tax_ccid cm_etax_rate_interim_tax_ccid ,jra.rate_tax_account_ccid cm_etax_rate_tax_account_id ,jra.rate_unedisc_ccid cm_etax_rate_uned_ccid ,jra.rate_unedisc_non_rec_tax_ccid cm_etax_rate_uned_nr_tax_ccid ,jra.tax_line_id cm_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' AND l.event_type_code IN ('CM_CREATE','CM_UPDATE') 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 ) cm_etax_jur_adj_ccid ,NVL2(l.location_segment_id,loca.LOC_ADJ_NON_REC_TAX_CCID,jra.JUR_ADJ_NON_REC_TAX_CCID) cm_etax_jur_adj_nr_tax_ccid ,NVL2(l.location_segment_id,loca.LOC_EDISC_CCID,jra.JUR_EDISC_CCID) cm_etax_jur_edisc_ccid ,NVL2(l.location_segment_id,loca.loc_edisc_non_rec_tax_ccid,jra.JUR_EDISC_NON_REC_TAX_CCID) cm_etax_jur_edisc_nr_tax_ccid ,NVL2(l.location_segment_id,loca.loc_finchrg_ccid,jra.JUR_FINCHRG_CCID) cm_etax_jur_fchrg_ccid ,NVL2(l.location_segment_id,loca.loc_finchrg_non_rec_tax_ccid,jra.JUR_FINCHRG_NON_REC_TAX_CCID) cm_etax_jur_fchrg_nr_tax_ccid ,NVL2(l.location_segment_id,loca.loc_interim_tax_ccid,jra.JUR_INTERIM_TAX_CCID) cm_etax_jur_interim_tax_ccid ,NVL2(l.location_segment_id,loca.loc_tax_account_ccid,jra.JUR_TAX_ACCOUNT_CCID) cm_etax_jur_tax_account_ccid ,NVL2(l.location_segment_id,loca.loc_unedisc_ccid,jra.JUR_unedisc_ccid) cm_etax_jur_uned_ccid ,NVL2(l.location_segment_id,loca.loc_unedisc_non_rec_tax_ccid,jra.JUR_unedisc_non_rec_tax_ccid) cm_etax_jur_uned_nr_tax_ccid ,jra.rate_adj_ccid cm_etax_rate_adj_ccid ,jra.rate_adj_non_rec_tax_ccid cm_etax_rate_adj_nr_tax_ccid ,jra.rate_edisc_ccid cm_etax_rate_edisc_ccid ,jra.rate_edisc_non_rec_tax_ccid cm_etax_rate_edisc_nr_tax_ccid ,jra.rate_finchrg_ccid cm_etax_rate_fchrg_ccid ,jra.rate_finchrg_non_rec_tax_ccid cm_etax_rate_fchrg_nr_tax_ccid ,jra.rate_interim_tax_ccid cm_etax_rate_interim_tax_ccid ,jra.rate_tax_account_ccid cm_etax_rate_tax_account_id ,jra.rate_unedisc_ccid cm_etax_rate_uned_ccid ,jra.rate_unedisc_non_rec_tax_ccid cm_etax_rate_uned_nr_tax_ccid ,jra.tax_line_id cm_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' AND l.event_type_code IN ('CM_CREATE','CM_UPDATE') 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