ZX_LINES_SUMMARY_V

Details

• Schema: FUSION

• Object owner: FND

• Object type: VIEW

Columns

Name

ROW_ID SUMMARY_TAX_LINE_ID INTERNAL_ORGANIZATION_ID APPLICATION_ID ENTITY_CODE EVENT_CLASS_CODE TRX_ID SUMMARY_TAX_LINE_NUMBER TRX_NUMBER APPLIED_FROM_APPLICATION_ID APPLIED_FROM_EVENT_CLASS_CODE APPLIED_FROM_ENTITY_CODE APPLIED_FROM_TRX_ID APPLIED_FROM_TRX_LEVEL_TYPE APPLIED_FROM_LINE_ID ADJUSTED_DOC_APPLICATION_ID ADJUSTED_DOC_ENTITY_CODE ADJUSTED_DOC_EVENT_CLASS_CODE ADJUSTED_DOC_TRX_ID ADJUSTED_DOC_TRX_LEVEL_TYPE APPLIED_TO_APPLICATION_ID APPLIED_TO_EVENT_CLASS_CODE APPLIED_TO_ENTITY_CODE APPLIED_TO_TRX_ID APPLIED_TO_TRX_LEVEL_TYPE APPLIED_TO_LINE_ID TAX_EXEMPTION_ID TAX_RATE_BEFORE_EXEMPTION TAX_RATE_NAME_BEFORE_EXEMPTION EXEMPT_RATE_MODIFIER EXEMPT_CERTIFICATE_NUMBER EXEMPT_REASON EXEMPT_REASON_CODE TAX_RATE_BEFORE_EXCEPTION TAX_RATE_NAME_BEFORE_EXCEPTION TAX_EXCEPTION_ID EXCEPTION_RATE CONTENT_OWNER_ID TAX_REGIME_CODE TAX TAX_STATUS_CODE TAX_RATE_ID TAX_RATE_CODE TAX_RATE TAX_RATE_NAME TAX_AMT TAX_AMT_TAX_CURR TAX_AMT_FUNCL_CURR TAX_JURISDICTION_CODE TOTAL_REC_TAX_AMT TOTAL_REC_TAX_AMT_FUNCL_CURR TOTAL_REC_TAX_AMT_TAX_CURR TOTAL_NREC_TAX_AMT TOTAL_NREC_TAX_AMT_FUNCL_CURR TOTAL_NREC_TAX_AMT_TAX_CURR LEDGER_ID LEGAL_ENTITY_ID ESTABLISHMENT_ID CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_RATE SUMMARIZATION_TEMPLATE_ID TAXABLE_BASIS_FORMULA TAX_CALCULATION_FORMULA HISTORICAL_FLAG CANCEL_FLAG DELETE_FLAG TAX_AMT_INCLUDED_FLAG COMPOUNDING_TAX_FLAG SELF_ASSESSED_FLAG OVERRIDDEN_FLAG REPORTING_ONLY_FLAG ASSOCIATED_CHILD_FROZEN_FLAG COPIED_FROM_OTHER_DOC_FLAG MANUALLY_ENTERED_FLAG MRC_TAX_LINE_FLAG ADJUST_TAX_AMT_FLAG LAST_MANUAL_ENTRY RECORD_TYPE_CODE TAX_PROVIDER_ID TAX_ONLY_LINE_FLAG ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20 OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

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 FROM ZX_LINES_SUMMARY ZS, ZX_RATES_TL TRT WHERE ZS.TAX_RATE_ID = TRT.TAX_RATE_ID AND TRT.LANGUAGE = userenv('LANG')