[Home] [Help]
View: ZX_SYNC_TAX_LINES_INPUT_V
View Text
SELECT
ZTPPO.EVNT_CLS_MAPPING_ID
,
ZDTL.TRX_ID
,
ZDTL.TRX_LINE_ID
,
ZDTL.TRX_LEVEL_TYPE
,
ZDTL.TAX_REGIME_CODE
,
ZDTL.TAX
,
ZDTL.PLACE_OF_SUPPLY_TYPE_CODE
,
ZDTL.TAX_JURISDICTION_CODE
,
ZDTL.TAX_CURRENCY_CODE
,
ZDTL.TAX_AMT
,
ZDTL.TAX_AMT_TAX_CURR
,
ZDTL.TAX_RATE
,
ZDTL.TAXABLE_AMT
,
ZDTL.EXEMPT_CERTIFICATE_NUMBER
,
ZDTL.EXEMPT_RATE_MODIFIER
,
ZDTL.EXEMPT_REASON
,
ZDTL.TAX_ONLY_LINE_FLAG
,
ZDTL.TAX_AMT_INCLUDED_FLAG
,
ZDTL.SELF_ASSESSED_FLAG
,
DECODE(ZDTL.OVERRIDDEN_FLAG
, 'N'
, 'Y'
, 'N')
,
ZDTL.OVERRIDDEN_FLAG
,
ZDTL.LAST_MANUAL_ENTRY
,
ZDTL.MANUALLY_ENTERED_FLAG
,
ZDTL.CANCEL_FLAG
,
ZDTL.DELETE_FLAG
FROM ZX_DETAIL_TAX_LINES_GT ZDTL
,
ZX_TRX_PRE_PROC_OPTIONS_GT ZTPPO
WHERE ZDTL.APPLICATION_ID = ZTPPO.APPLICATION_ID
AND ZDTL.ENTITY_CODE = ZTPPO.ENTITY_CODE
AND ZDTL.EVENT_CLASS_CODE = ZTPPO.EVENT_CLASS_CODE
AND ZDTL.TRX_ID = ZTPPO.TRX_ID
AND (ZDTL.TAX_REGIME_CODE = ZTPPO.TAX_REGIME_CODE OR
ZDTL.GLOBAL_ATTRIBUTE_CATEGORY IN ('VERTEX'
, 'AVP'))
AND ZDTL.TAX_PROVIDER_ID = ZTPPO.TAX_PROVIDER_ID
AND ZTPPO.RECORD_FOR_PARTNERS_FLAG = 'Y'
AND ZTPPO.QUOTE_FLAG = 'N'
AND ZDTL.SYNC_WITH_PRVDR_FLAG = 'Y'