SELECT ZS.ROWID ROW_ID,
ZS.SUMMARY_TAX_LINE_ID,
ZS.INTERNAL_ORGANIZATION_ID,
ZS.APPLICATION_ID,
ZS.ENTITY_CODE,
ZS.EVENT_CLASS_CODE,
ZS.TRX_ID,
ZS.SUMMARY_TAX_LINE_NUMBER,
ZS.TRX_NUMBER,
ZS.APPLIED_FROM_APPLICATION_ID,
ZS.APPLIED_FROM_EVENT_CLASS_CODE,
ZS.APPLIED_FROM_ENTITY_CODE,
ZS.APPLIED_FROM_TRX_ID,
ZS.APPLIED_FROM_TRX_LEVEL_TYPE,
ZS.APPLIED_FROM_LINE_ID,
ZS.ADJUSTED_DOC_APPLICATION_ID,
ZS.ADJUSTED_DOC_ENTITY_CODE,
ZS.ADJUSTED_DOC_EVENT_CLASS_CODE,
ZS.ADJUSTED_DOC_TRX_ID,
ZS.ADJUSTED_DOC_TRX_LEVEL_TYPE,
ZS.APPLIED_TO_APPLICATION_ID,
ZS.APPLIED_TO_EVENT_CLASS_CODE,
ZS.APPLIED_TO_ENTITY_CODE,
ZS.APPLIED_TO_TRX_ID,
ZS.APPLIED_TO_TRX_LEVEL_TYPE,
ZS.APPLIED_TO_LINE_ID,
ZS.TAX_EXEMPTION_ID,
ZS.TAX_RATE_BEFORE_EXEMPTION,
ZS.TAX_RATE_NAME_BEFORE_EXEMPTION,
ZS.EXEMPT_RATE_MODIFIER,
ZS.EXEMPT_CERTIFICATE_NUMBER,
ZS.EXEMPT_REASON,
ZS.EXEMPT_REASON_CODE,
ZS.TAX_RATE_BEFORE_EXCEPTION,
ZS.TAX_RATE_NAME_BEFORE_EXCEPTION,
ZS.TAX_EXCEPTION_ID,
ZS.EXCEPTION_RATE,
ZS.CONTENT_OWNER_ID,
ZS.TAX_REGIME_CODE,
ZS.TAX,
ZS.TAX_STATUS_CODE,
ZS.TAX_RATE_ID,
ZS.TAX_RATE_CODE,
ZS.TAX_RATE,
TRT.TAX_RATE_NAME,
ZS.TAX_AMT,
ZS.TAX_AMT_TAX_CURR,
ZS.TAX_AMT_FUNCL_CURR,
ZS.TAX_JURISDICTION_CODE,
ZS.TOTAL_REC_TAX_AMT,
ZS.TOTAL_REC_TAX_AMT_FUNCL_CURR,
ZS.TOTAL_REC_TAX_AMT_TAX_CURR,
ZS.TOTAL_NREC_TAX_AMT,
ZS.TOTAL_NREC_TAX_AMT_FUNCL_CURR,
ZS.TOTAL_NREC_TAX_AMT_TAX_CURR,
ZS.LEDGER_ID,
ZS.LEGAL_ENTITY_ID,
ZS.ESTABLISHMENT_ID,
ZS.CURRENCY_CONVERSION_DATE,
ZS.CURRENCY_CONVERSION_TYPE,
ZS.CURRENCY_CONVERSION_RATE,
ZS.SUMMARIZATION_TEMPLATE_ID,
ZS.TAXABLE_BASIS_FORMULA,
ZS.TAX_CALCULATION_FORMULA,
ZS.HISTORICAL_FLAG,
ZS.CANCEL_FLAG,
ZS.DELETE_FLAG,
ZS.TAX_AMT_INCLUDED_FLAG,
ZS.COMPOUNDING_TAX_FLAG,
ZS.SELF_ASSESSED_FLAG,
ZS.OVERRIDDEN_FLAG,
ZS.REPORTING_ONLY_FLAG,
ZS.ASSOCIATED_CHILD_FROZEN_FLAG,
ZS.COPIED_FROM_OTHER_DOC_FLAG,
ZS.MANUALLY_ENTERED_FLAG,
ZS.MRC_TAX_LINE_FLAG,
ZS.ADJUST_TAX_AMT_FLAG,
ZS.LAST_MANUAL_ENTRY,
ZS.RECORD_TYPE_CODE,
ZS.TAX_PROVIDER_ID,
ZS.TAX_ONLY_LINE_FLAG,
ZS.ATTRIBUTE_CATEGORY,
ZS.ATTRIBUTE1,
ZS.ATTRIBUTE2,
ZS.ATTRIBUTE3,
ZS.ATTRIBUTE4,
ZS.ATTRIBUTE5,
ZS.ATTRIBUTE6,
ZS.ATTRIBUTE7,
ZS.ATTRIBUTE8,
ZS.ATTRIBUTE9,
ZS.ATTRIBUTE10,
ZS.ATTRIBUTE11,
ZS.ATTRIBUTE12,
ZS.ATTRIBUTE13,
ZS.ATTRIBUTE14,
ZS.ATTRIBUTE15,
ZS.GLOBAL_ATTRIBUTE_CATEGORY,
ZS.GLOBAL_ATTRIBUTE1,
ZS.GLOBAL_ATTRIBUTE2,
ZS.GLOBAL_ATTRIBUTE3,
ZS.GLOBAL_ATTRIBUTE4,
ZS.GLOBAL_ATTRIBUTE5,
ZS.GLOBAL_ATTRIBUTE6,
ZS.GLOBAL_ATTRIBUTE7,
ZS.GLOBAL_ATTRIBUTE8,
ZS.GLOBAL_ATTRIBUTE9,
ZS.GLOBAL_ATTRIBUTE10,
ZS.GLOBAL_ATTRIBUTE11,
ZS.GLOBAL_ATTRIBUTE12,
ZS.GLOBAL_ATTRIBUTE13,
ZS.GLOBAL_ATTRIBUTE14,
ZS.GLOBAL_ATTRIBUTE15,
ZS.GLOBAL_ATTRIBUTE16,
ZS.GLOBAL_ATTRIBUTE17,
ZS.GLOBAL_ATTRIBUTE18,
ZS.GLOBAL_ATTRIBUTE19,
ZS.GLOBAL_ATTRIBUTE20,
ZS.OBJECT_VERSION_NUMBER,
ZS.CREATED_BY,
ZS.CREATION_DATE,
ZS.LAST_UPDATED_BY,
ZS.LAST_UPDATE_DATE,
ZS.LAST_UPDATE_LOGIN,
(SELECT tax_currency_code from zx_taxes_b where tax_regime_code = zs.tax_regime_code and tax = zs.tax and (content_owner_id = zs.content_owner_id OR content_owner_id = -99) AND ROWNUM=1) AS tax_currency_code
FROM ZX_LINES_SUMMARY ZS,
ZX_RATES_TL TRT
WHERE ZS.TAX_RATE_ID = TRT.TAX_RATE_ID
AND TRT.LANGUAGE = userenv('LANG')
SELECT ZS.ROWID ROW_ID
,
ZS.SUMMARY_TAX_LINE_ID
,
ZS.INTERNAL_ORGANIZATION_ID
,
ZS.APPLICATION_ID
,
ZS.ENTITY_CODE
,
ZS.EVENT_CLASS_CODE
,
ZS.TRX_ID
,
ZS.SUMMARY_TAX_LINE_NUMBER
,
ZS.TRX_NUMBER
,
ZS.APPLIED_FROM_APPLICATION_ID
,
ZS.APPLIED_FROM_EVENT_CLASS_CODE
,
ZS.APPLIED_FROM_ENTITY_CODE
,
ZS.APPLIED_FROM_TRX_ID
,
ZS.APPLIED_FROM_TRX_LEVEL_TYPE
,
ZS.APPLIED_FROM_LINE_ID
,
ZS.ADJUSTED_DOC_APPLICATION_ID
,
ZS.ADJUSTED_DOC_ENTITY_CODE
,
ZS.ADJUSTED_DOC_EVENT_CLASS_CODE
,
ZS.ADJUSTED_DOC_TRX_ID
,
ZS.ADJUSTED_DOC_TRX_LEVEL_TYPE
,
ZS.APPLIED_TO_APPLICATION_ID
,
ZS.APPLIED_TO_EVENT_CLASS_CODE
,
ZS.APPLIED_TO_ENTITY_CODE
,
ZS.APPLIED_TO_TRX_ID
,
ZS.APPLIED_TO_TRX_LEVEL_TYPE
,
ZS.APPLIED_TO_LINE_ID
,
ZS.TAX_EXEMPTION_ID
,
ZS.TAX_RATE_BEFORE_EXEMPTION
,
ZS.TAX_RATE_NAME_BEFORE_EXEMPTION
,
ZS.EXEMPT_RATE_MODIFIER
,
ZS.EXEMPT_CERTIFICATE_NUMBER
,
ZS.EXEMPT_REASON
,
ZS.EXEMPT_REASON_CODE
,
ZS.TAX_RATE_BEFORE_EXCEPTION
,
ZS.TAX_RATE_NAME_BEFORE_EXCEPTION
,
ZS.TAX_EXCEPTION_ID
,
ZS.EXCEPTION_RATE
,
ZS.CONTENT_OWNER_ID
,
ZS.TAX_REGIME_CODE
,
ZS.TAX
,
ZS.TAX_STATUS_CODE
,
ZS.TAX_RATE_ID
,
ZS.TAX_RATE_CODE
,
ZS.TAX_RATE
,
TRT.TAX_RATE_NAME
,
ZS.TAX_AMT
,
ZS.TAX_AMT_TAX_CURR
,
ZS.TAX_AMT_FUNCL_CURR
,
ZS.TAX_JURISDICTION_CODE
,
ZS.TOTAL_REC_TAX_AMT
,
ZS.TOTAL_REC_TAX_AMT_FUNCL_CURR
,
ZS.TOTAL_REC_TAX_AMT_TAX_CURR
,
ZS.TOTAL_NREC_TAX_AMT
,
ZS.TOTAL_NREC_TAX_AMT_FUNCL_CURR
,
ZS.TOTAL_NREC_TAX_AMT_TAX_CURR
,
ZS.LEDGER_ID
,
ZS.LEGAL_ENTITY_ID
,
ZS.ESTABLISHMENT_ID
,
ZS.CURRENCY_CONVERSION_DATE
,
ZS.CURRENCY_CONVERSION_TYPE
,
ZS.CURRENCY_CONVERSION_RATE
,
ZS.SUMMARIZATION_TEMPLATE_ID
,
ZS.TAXABLE_BASIS_FORMULA
,
ZS.TAX_CALCULATION_FORMULA
,
ZS.HISTORICAL_FLAG
,
ZS.CANCEL_FLAG
,
ZS.DELETE_FLAG
,
ZS.TAX_AMT_INCLUDED_FLAG
,
ZS.COMPOUNDING_TAX_FLAG
,
ZS.SELF_ASSESSED_FLAG
,
ZS.OVERRIDDEN_FLAG
,
ZS.REPORTING_ONLY_FLAG
,
ZS.ASSOCIATED_CHILD_FROZEN_FLAG
,
ZS.COPIED_FROM_OTHER_DOC_FLAG
,
ZS.MANUALLY_ENTERED_FLAG
,
ZS.MRC_TAX_LINE_FLAG
,
ZS.ADJUST_TAX_AMT_FLAG
,
ZS.LAST_MANUAL_ENTRY
,
ZS.RECORD_TYPE_CODE
,
ZS.TAX_PROVIDER_ID
,
ZS.TAX_ONLY_LINE_FLAG
,
ZS.ATTRIBUTE_CATEGORY
,
ZS.ATTRIBUTE1
,
ZS.ATTRIBUTE2
,
ZS.ATTRIBUTE3
,
ZS.ATTRIBUTE4
,
ZS.ATTRIBUTE5
,
ZS.ATTRIBUTE6
,
ZS.ATTRIBUTE7
,
ZS.ATTRIBUTE8
,
ZS.ATTRIBUTE9
,
ZS.ATTRIBUTE10
,
ZS.ATTRIBUTE11
,
ZS.ATTRIBUTE12
,
ZS.ATTRIBUTE13
,
ZS.ATTRIBUTE14
,
ZS.ATTRIBUTE15
,
ZS.GLOBAL_ATTRIBUTE_CATEGORY
,
ZS.GLOBAL_ATTRIBUTE1
,
ZS.GLOBAL_ATTRIBUTE2
,
ZS.GLOBAL_ATTRIBUTE3
,
ZS.GLOBAL_ATTRIBUTE4
,
ZS.GLOBAL_ATTRIBUTE5
,
ZS.GLOBAL_ATTRIBUTE6
,
ZS.GLOBAL_ATTRIBUTE7
,
ZS.GLOBAL_ATTRIBUTE8
,
ZS.GLOBAL_ATTRIBUTE9
,
ZS.GLOBAL_ATTRIBUTE10
,
ZS.GLOBAL_ATTRIBUTE11
,
ZS.GLOBAL_ATTRIBUTE12
,
ZS.GLOBAL_ATTRIBUTE13
,
ZS.GLOBAL_ATTRIBUTE14
,
ZS.GLOBAL_ATTRIBUTE15
,
ZS.GLOBAL_ATTRIBUTE16
,
ZS.GLOBAL_ATTRIBUTE17
,
ZS.GLOBAL_ATTRIBUTE18
,
ZS.GLOBAL_ATTRIBUTE19
,
ZS.GLOBAL_ATTRIBUTE20
,
ZS.OBJECT_VERSION_NUMBER
,
ZS.CREATED_BY
,
ZS.CREATION_DATE
,
ZS.LAST_UPDATED_BY
,
ZS.LAST_UPDATE_DATE
,
ZS.LAST_UPDATE_LOGIN
,
(SELECT TAX_CURRENCY_CODE
FROM ZX_TAXES_B
WHERE TAX_REGIME_CODE = ZS.TAX_REGIME_CODE
AND TAX = ZS.TAX
AND (CONTENT_OWNER_ID = ZS.CONTENT_OWNER_ID OR CONTENT_OWNER_ID = -99)
AND ROWNUM=1) AS TAX_CURRENCY_CODE
FROM ZX_LINES_SUMMARY ZS
,
ZX_RATES_TL TRT
WHERE ZS.TAX_RATE_ID = TRT.TAX_RATE_ID
AND TRT.LANGUAGE = USERENV('LANG')
|
|
|