View: AR_ETAX_ACCOUNTS_L_V

Product:	AR - Receivables
Description:	Ebusiness tax sources to AR XLA uptake for invoice and its applications
Implementation/DBA Data:	APPS.AR_ETAX_ACCOUNTS_L_V

View Text

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

Columns