VIEW: APPS.ZX_SYNC_TAX_LINES_INPUT_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'