VIEW: APPS.AR_CM_ETAX_ACCOUNTS_L_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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