ZX_SYNC_TAX_LINES_INPUT

Details

Schema: FUSION
Object owner: FND
Object type: VIEW

Columns

Name
DOCUMENT_TYPE_ID TRANSACTION_ID TRANSACTION_LINE_ID TRX_LEVEL_TYPE COUNTRY_CODE TAX SITUS TAX_JURISDICTION TAX_CURRENCY_CODE TAX_AMOUNT TAX_CURR_TAX_AMT TAX_RATE_PERCENTAGE TAXABLE_AMOUNT EXEMPT_CERTIFICATE_NUMBER EXEMPT_RATE_MODIFIER EXEMPT_REASON TAX_ONLY_LINE_FLAG INCLUSIVE_TAX_LINE_FLAG USE_TAX_FLAG EBIZ_OVERRIDE_FLAG USER_OVERRIDE_FLAG LAST_MANUAL_ENTRY MANUALLY_ENTERED_FLAG CANCEL_FLAG DELETE_FLAG

Name

DOCUMENT_TYPE_ID

TRANSACTION_ID

TRANSACTION_LINE_ID

TRX_LEVEL_TYPE

COUNTRY_CODE

TAX

SITUS

TAX_JURISDICTION

TAX_CURRENCY_CODE

TAX_AMOUNT

TAX_CURR_TAX_AMT

TAX_RATE_PERCENTAGE

TAXABLE_AMOUNT

EXEMPT_CERTIFICATE_NUMBER

EXEMPT_RATE_MODIFIER

EXEMPT_REASON

TAX_ONLY_LINE_FLAG

INCLUSIVE_TAX_LINE_FLAG

USE_TAX_FLAG

EBIZ_OVERRIDE_FLAG

USER_OVERRIDE_FLAG

LAST_MANUAL_ENTRY

MANUALLY_ENTERED_FLAG

CANCEL_FLAG

DELETE_FLAG

Query

SQL_Statement
SELECT ztppo.EVNT_CLS_MAPPING_ID DOCUMENT_TYPE_ID, zdtl.TRX_ID TRANSACTION_ID, zdtl.TRX_LINE_ID TRANSACTION_LINE_ID, zdtl.TRX_LEVEL_TYPE TRX_LEVEL_TYPE, zdtl.TAX_REGIME_CODE COUNTRY_CODE, zdtl.TAX TAX, zdtl.PLACE_OF_SUPPLY_TYPE_CODE SITUS, zdtl.TAX_JURISDICTION_CODE TAX_JURISDICTION, zdtl.TAX_CURRENCY_CODE TAX_CURRENCY_CODE, zdtl.TAX_AMT TAX_AMOUNT, zdtl.TAX_AMT_TAX_CURR TAX_CURR_TAX_AMT, zdtl.TAX_RATE TAX_RATE_PERCENTAGE, zdtl.TAXABLE_AMT TAXABLE_AMOUNT, zdtl.EXEMPT_CERTIFICATE_NUMBER EXEMPT_CERTIFICATE_NUMBER, zdtl.EXEMPT_RATE_MODIFIER EXEMPT_RATE_MODIFIER, zdtl.EXEMPT_REASON EXEMPT_REASON, zdtl.TAX_ONLY_LINE_FLAG TAX_ONLY_LINE_FLAG, zdtl.TAX_AMT_INCLUDED_FLAG INCLUSIVE_TAX_LINE_FLAG, zdtl.SELF_ASSESSED_FLAG USE_TAX_FLAG, DECODE(zdtl.OVERRIDDEN_FLAG, 'N', 'Y', 'N') EBIZ_OVERRIDE_FLAG, zdtl.OVERRIDDEN_FLAG USER_OVERRIDE_FLAG, zdtl.LAST_MANUAL_ENTRY LAST_MANUAL_ENTRY, zdtl.MANUALLY_ENTERED_FLAG MANUALLY_ENTERED_FLAG, zdtl.CANCEL_FLAG CANCEL_FLAG, zdtl.DELETE_FLAG 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'

SQL_Statement

SELECT

ztppo.EVNT_CLS_MAPPING_ID DOCUMENT_TYPE_ID,

zdtl.TRX_ID TRANSACTION_ID,

zdtl.TRX_LINE_ID TRANSACTION_LINE_ID,

zdtl.TRX_LEVEL_TYPE TRX_LEVEL_TYPE,

zdtl.TAX_REGIME_CODE COUNTRY_CODE,

zdtl.TAX TAX,

zdtl.PLACE_OF_SUPPLY_TYPE_CODE SITUS,

zdtl.TAX_JURISDICTION_CODE TAX_JURISDICTION,

zdtl.TAX_CURRENCY_CODE TAX_CURRENCY_CODE,

zdtl.TAX_AMT TAX_AMOUNT,

zdtl.TAX_AMT_TAX_CURR TAX_CURR_TAX_AMT,

zdtl.TAX_RATE TAX_RATE_PERCENTAGE,

zdtl.TAXABLE_AMT TAXABLE_AMOUNT,

zdtl.EXEMPT_CERTIFICATE_NUMBER EXEMPT_CERTIFICATE_NUMBER,

zdtl.EXEMPT_RATE_MODIFIER EXEMPT_RATE_MODIFIER,

zdtl.EXEMPT_REASON EXEMPT_REASON,

zdtl.TAX_ONLY_LINE_FLAG TAX_ONLY_LINE_FLAG,

zdtl.TAX_AMT_INCLUDED_FLAG INCLUSIVE_TAX_LINE_FLAG,

zdtl.SELF_ASSESSED_FLAG USE_TAX_FLAG,

DECODE(zdtl.OVERRIDDEN_FLAG, 'N', 'Y', 'N') EBIZ_OVERRIDE_FLAG,

zdtl.OVERRIDDEN_FLAG USER_OVERRIDE_FLAG,

zdtl.LAST_MANUAL_ENTRY LAST_MANUAL_ENTRY,

zdtl.MANUALLY_ENTERED_FLAG MANUALLY_ENTERED_FLAG,

zdtl.CANCEL_FLAG CANCEL_FLAG,

zdtl.DELETE_FLAG 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'