ZX_WHT_TRX_DETAILS_V

Details

• Schema: FUSION

• Object owner: ZX

• Object type: VIEW

Columns

Name

DIST_JOB_DEFINITION_PACKAGE DIST_JOB_DEFINITION_NAME DIST_INTENDED_USE_CLASSIF_ID DIST_CREATION_DATE DIST_RCV_CHARGE_ADDITION_FLAG DIST_DETAIL_TAX_LINE_ID DIST_GLOBAL_ATTRIBUTE_DATE5 DIST_GLOBAL_ATTRIBUTE_DATE4 DIST_GLOBAL_ATTRIBUTE_DATE3 DIST_GLOBAL_ATTRIBUTE_DATE2 DIST_GLOBAL_ATTRIBUTE_DATE1 DIST_GLOBAL_ATTRIBUTE_NUMBER5 DIST_GLOBAL_ATTRIBUTE_NUMBER4 DIST_GLOBAL_ATTRIBUTE_NUMBER3 DIST_GLOBAL_ATTRIBUTE_NUMBER2 DIST_GLOBAL_ATTRIBUTE_NUMBER1 DIST_ATTRIBUTE_DATE5 DIST_ATTRIBUTE_DATE4 DIST_ATTRIBUTE_DATE3 DIST_ATTRIBUTE_DATE2 DIST_ATTRIBUTE_DATE1 DIST_ATTRIBUTE_NUMBER5 DIST_ATTRIBUTE_NUMBER4 DIST_ATTRIBUTE_NUMBER3 DIST_ATTRIBUTE_NUMBER2 DIST_ATTRIBUTE_NUMBER1 DIST_RECOVERY_RATE_ID DIST_REC_NREC_RATE DIST_DETAIL_TAX_DIST_ID DIST_INTENDED_USE DIST_AMT_AT_PREPAY_PAY_XRATE DIST_CASH_BASIS_FINAL_APP_RDG DIST_AMOUNT_AT_PREPAY_XRATE DIST_FINAL_APPLICATION_RDG DIST_FINAL_PAYMENT_ROUNDING DIST_DISTRIBUTION_CLASS DIST_MERCHANT_NAME DIST_MERCHANT_DOCUMENT_NUMBER DIST_TAX_RECOVERABLE_FLAG DIST_PARENT_REVERSAL_ID DIST_INVOICE_DISTRIBUTION_ID DIST_GLOBAL_ATTRIBUTE17 DIST_GLOBAL_ATTRIBUTE16 DIST_GLOBAL_ATTRIBUTE15 DIST_ATTRIBUTE4 DIST_ATTRIBUTE3 DIST_ATTRIBUTE2 DIST_ATTRIBUTE15 DIST_ATTRIBUTE14 DIST_ATTRIBUTE13 DIST_ATTRIBUTE12 DIST_ATTRIBUTE11 DIST_ATTRIBUTE10 DIST_ATTRIBUTE1 DIST_STAT_AMOUNT DIST_ENCUMBERED_FLAG DIST_UNIT_PRICE DIST_TYPE_1099 DIST_REVERSAL_FLAG DIST_REQUEST_ID DIST_QUANTITY_INVOICED DIST_PROGRAM_UPDATE_DATE DIST_PROGRAM_ID DIST_PROGRAM_APPLICATION_ID DIST_PO_DISTRIBUTION_ID DIST_POSTED_FLAG DIST_MATCH_STATUS_FLAG DIST_LAST_UPDATE_LOGIN DIST_INCOME_TAX_REGION DIST_FINAL_MATCH_FLAG DIST_DESCRIPTION DIST_CREATED_BY DIST_BATCH_ID DIST_BASE_AMOUNT DIST_AMOUNT DIST_SET_OF_BOOKS_ID DIST_PERIOD_NAME DIST_LINE_TYPE_LOOKUP_CODE DIST_LAST_UPDATE_DATE DIST_PJC_USER_DEF_ATTRIBUTE10 DIST_PJC_USER_DEF_ATTRIBUTE9 DIST_PJC_USER_DEF_ATTRIBUTE8 DIST_PJC_USER_DEF_ATTRIBUTE7 DIST_PJC_USER_DEF_ATTRIBUTE6 DIST_PJC_USER_DEF_ATTRIBUTE5 DIST_PJC_USER_DEF_ATTRIBUTE4 DIST_PJC_USER_DEF_ATTRIBUTE3 DIST_ASSET_CATEGORY_ID DIST_ASSET_BOOK_TYPE_CODE DIST_GLOBAL_ATTRIBUTE9 DIST_GLOBAL_ATTRIBUTE8 DIST_GLOBAL_ATTRIBUTE7 DIST_GLOBAL_ATTRIBUTE6 DIST_GLOBAL_ATTRIBUTE5 DIST_GLOBAL_ATTRIBUTE4 DIST_GLOBAL_ATTRIBUTE3 DIST_GLOBAL_ATTRIBUTE2 DIST_GLOBAL_ATTRIBUTE1 DIST_GLOBAL_ATTRIBUTE_CATEGORY DIST_AWT_INVOICE_PAYMENT_ID DIST_ORG_ID DIST_REFERENCE_2 DIST_REFERENCE_1 DIST_AWT_ORIGIN_GROUP_ID DIST_AWT_INVOICE_ID DIST_AWT_GROSS_AMOUNT DIST_AWT_TAX_RATE_ID DIST_AWT_GROUP_ID DIST_AWT_FLAG DIST_TASK_ID DIST_PROJECT_ID DIST_PREPAY_AMOUNT_REMAINING DIST_PA_QUANTITY DIST_PA_ADDITION_FLAG DIST_PARENT_INVOICE_ID DIST_EXPENDITURE_TYPE DIST_EXPENDITURE_ORG_ID DIST_EXPENDITURE_ITEM_DATE DIST_ATTRIBUTE_CATEGORY DIST_ATTRIBUTE9 DIST_ATTRIBUTE8 DIST_ATTRIBUTE7 DIST_ATTRIBUTE6 DIST_ATTRIBUTE5 DIST_RCV_TRANSACTION_ID DIST_DIST_MATCH_TYPE DIST_CREDIT_CARD_TRX_ID DIST_AWARD_ID DIST_ADJUSTMENT_REASON DIST_WEB_PARAMETER_ID DIST_DAILY_AMOUNT DIST_RECEIPT_CURRENCY_AMOUNT DIST_RECEIPT_CONVERSION_RATE DIST_RECEIPT_CURRENCY_CODE DIST_END_EXPENSE_DATE DIST_START_EXPENSE_DATE DIST_EXPENSE_GROUP DIST_JUSTIFICATION DIST_RECEIPT_MISSING_FLAG DIST_RECEIPT_REQUIRED_FLAG DIST_RECEIPT_VERIFIED_FLAG DIST_GLOBAL_ATTRIBUTE20 DIST_PJC_USER_DEF_ATTRIBUTE2 DIST_PJC_USER_DEF_ATTRIBUTE1 DIST_PJC_RESERVED_ATTRIBUTE10 DIST_PJC_RESERVED_ATTRIBUTE9 DIST_PJC_RESERVED_ATTRIBUTE8 DIST_PJC_RESERVED_ATTRIBUTE7 DIST_PJC_RESERVED_ATTRIBUTE6 DIST_DISTRIBUTION_LINE_NUMBER DIST_ASSETS_TRACKING_FLAG DIST_ASSETS_ADDITION_FLAG DIST_ACCOUNTING_DATE DIST_RELATED_ID DIST_CORRECTED_QUANTITY DIST_CHARGE_APPL_TO_DIST_ID DIST_ROUNDING_AMT DIST_CORRECTED_INVOICE_DIST_ID DIST_INVOICE_LINE_NUMBER DIST_CANCELLATION_FLAG DIST_PA_CMT_XFACE_FLAG DIST_INV_INCLUDES_PREPAY_FLAG DIST_CC_REVERSAL_FLAG DIST_COMPANY_PREPAID_INV_ID DIST_INVENTORY_TRANSFER_STATUS DIST_UPGRADE_BASE_POSTED_AMT DIST_UPGRADE_POSTED_AMT DIST_PREPAY_DISTRIBUTION_ID DIST_ACCOUNTING_EVENT_ID DIST_GMS_BURDENABLE_RAW_COST DIST_MATCHED_UOM_LOOKUP_CODE DIST_GLOBAL_ATTRIBUTE14 DIST_PJC_RESERVED_ATTRIBUTE5 DIST_PJC_RESERVED_ATTRIBUTE4 DIST_PJC_RESERVED_ATTRIBUTE3 DIST_PJC_RESERVED_ATTRIBUTE2 DIST_PJC_RESERVED_ATTRIBUTE1 DIST_PJC_FUNDING_ALLOCATION_ID DIST_PJC_CONTRACT_LINE_ID DIST_PJC_CONTRACT_ID DIST_PJC_WORK_TYPE_ID DIST_PJC_CAPITALIZABLE_FLAG DIST_PJC_BILLABLE_FLAG DIST_PJC_ORGANIZATION_ID DIST_PJC_EXPENDITURE_ITEM_DATE DIST_PJC_EXPENDITURE_TYPE_ID DIST_PJC_TASK_ID DIST_PJC_PROJECT_ID DIST_PJC_CONTEXT_CATEGORY DIST_EXCHANGE_DATE DIST_EXCHANGE_RATE DIST_EXCHANGE_RATE_TYPE DIST_BASE_QUANTITY_VARIANCE DIST_QUANTITY_VARIANCE DIST_REL_INV_DIST_DERIVED_FROM DIST_RECURRING_PAYMENT_ID DIST_XINV_PARENT_REVERSAL_ID DIST_ROOT_DISTRIBUTION_ID DIST_FULLY_PAID_ACCTD_FLAG DIST_FINAL_RELEASE_ROUNDING DIST_RETAINED_INVOICE_DIST_ID DIST_BC_EVENT_ID DIST_RETAINED_AMOUNT_REMAINING DIST_RELATED_RETAINAGE_DIST_ID DIST_AWT_RELATED_ID DIST_HISTORICAL_FLAG DIST_BASE_AMOUNT_VARIANCE DIST_AMOUNT_VARIANCE DIST_OLD_DIST_LINE_NUMBER DIST_OLD_DISTRIBUTION_ID DIST_TOTAL_DIST_BASE_AMOUNT DIST_TOTAL_DIST_AMOUNT DIST_TAX_CODE_ID DIST_PREPAY_TAX_DIFF_AMOUNT DIST_EXTRA_PO_ERV DIST_TAXABLE_BASE_AMOUNT DIST_TAXABLE_AMOUNT DIST_SUMMARY_TAX_LINE_ID DIST_TAX_ALREADY_DIST_FLAG DIST_WITHHOLDING_TAX_CODE_ID DIST_GLOBAL_ATTRIBUTE12 DIST_GLOBAL_ATTRIBUTE11 DIST_GLOBAL_ATTRIBUTE10 DIST_GLOBAL_ATTRIBUTE19 DIST_GLOBAL_ATTRIBUTE18 DIST_COUNTRY_OF_SUPPLY DIST_MERCHANT_TAXPAYER_ID DIST_MERCHANT_TAX_REG_NUMBER DIST_MERCHANT_REFERENCE DIST_RECOVERY_RATE_CODE DIST_RECOVERY_TYPE_CODE DIST_RECOVERY_RATE_NAME DIST_INVOICE_ID DIST_DIST_CODE_COMBINATION_ID DIST_LAST_UPDATED_BY DIST_GLOBAL_ATTRIBUTE13 DIST_DATA_SET_ID DIST_CONSUMP_ADVICE_LINE_ID DIST_CONSUMP_ADVICE_HEADER_ID DIST_FUNDS_STATUS DIST_BUDGET_DATE RATE_ATTRIBUTE6 RATE_ATTRIBUTE5 RATE_ATTRIBUTE4 RATE_ATTRIBUTE3 RATE_ATTRIBUTE2 RATE_ATTRIBUTE1 RATE_LAST_UPDATE_LOGIN RATE_LAST_UPDATED_BY RATE_CREATED_BY RATE_VAT_TRANSACTION_TYPE_CODE RATE_RECOVERY_RULE_CODE RATE_DEFAULT_REC_TYPE_CODE RATE_DEFAULT_FLG_EFF_FROM RATE_DEFAULT_RATE_FLAG RATE_RECOVERY_TYPE_CODE RATE_UOM_CODE RATE_PERCENTAGE_RATE RATE_SCHEDULE_BASED_RATE_FLAG RATE_EFFECTIVE_TO RATE_REQUEST_ID RATE_LAST_UPDATE_DATE RATE_CREATION_DATE RATE_RECORD_TYPE_CODE RATE_OFFSET_TAX_RATE_CODE RATE_OFFSET_TAX RATE_DEFAULT_REC_RATE_CODE RATE_DEFAULT_FLG_EFFECTIVE_TO RATE_ACTIVE_FLAG RATE_TAX_JURISDICTION_CODE RATE_QUANTITY_RATE RATE_RATE_TYPE_CODE RATE_TAX_STATUS_CODE RATE_EFFECTIVE_FROM RATE_TAX_RATE_CODE RATE_OFFSET_STATUS_CODE RATE_ATTRIBUTE_DATE5 RATE_ATTRIBUTE_DATE4 RATE_ATTRIBUTE_DATE3 RATE_ATTRIBUTE_DATE2 RATE_ATTRIBUTE_DATE1 RATE_ATTRIBUTE_NUMBER5 RATE_ATTRIBUTE_NUMBER4 RATE_ATTRIBUTE_NUMBER3 RATE_ATTRIBUTE_NUMBER2 RATE_ATTRIBUTE_NUMBER1 RATE_PROGRAM_APP_NAME RATE_PROGRAM_NAME RATE_DESCRIPTION RATE_TAX_INCLU_OVERRIDE_FLAG RATE_INCLUSIVE_TAX_FLAG RATE_TAXABLE_BASIS_FORM_CODE RATE_SOURCE_ID RATE_TAX_CLASS RATE_ALLOW_ADHOC_TAX_RATE_FLAG RATE_ADJ_FOR_ADHOC_AMT_CODE RATE_TAX_RATE_ID RATE_PROGRAM_LOGIN_ID RATE_ATTRIBUTE_CATEGORY RATE_ATTRIBUTE15 RATE_ATTRIBUTE14 RATE_ATTRIBUTE13 RATE_ATTRIBUTE12 RATE_ATTRIBUTE11 RATE_ATTRIBUTE10 RATE_ATTRIBUTE9 RATE_ATTRIBUTE8 RATE_ATTRIBUTE7 TAX_ATTRIBUTE2 TAX_CONTENT_OWNER_ID TAX_VALIDATION_TYPE TAX_DEF_TAX_CALC_FORMULA TAX_LAST_UPDATE_LOGIN TAX_CALC_ONLY_FLAG TAX_ATTRIBUTE15 TAX_TAX_TYPE_CODE TAX_PRIMARY_REC_TYPE_RULE_FLAG TAX_ALLOW_ZERO_AMT_WHT_INV_FLG TAX_ATTRIBUTE13 TAX_ATTRIBUTE_CATEGORY TAX_HAS_TAXPOINT_DATE_RULE_FLG TAX_HAS_DETAIL_TB_THRSHLD_FLAG TAX_PLACE_OF_SUPPLY_RULE_FLAG TAX_SEC_RECOVERY_TYPE_CODE TAX_CHARGE_LINE_HANDLING_CODE TAX_LIVE_FOR_PROCESSING_FLAG TAX_REP_TAX_AUTHORITY_ID TAX_CREATED_BY TAX_ATTRIBUTE11 TAX_PERIOD_SET_NAME TAX_ATTRIBUTE9 TAX_REPORTING_ONLY_FLAG TAX_REGN_NUM_SAME_AS_LE_FLAG TAX_REGISTRATION_TYPE_RULE_FLG TAX_PARENT_GEOGRAPHY_TYPE TAX_DEF_TAXABLE_BASIS_FORMULA TAX_REQUEST_ID TAX_MAX_TAX_RATE_THRSHLD TAX_ATTRIBUTE1 TAX_HAS_TAX_DET_DATE_RULE_FLAG TAX_ROW_ID TAX_RECOVERY_RATE_OVERRIDE_FLG TAX_DEF_REC_STLMT_OPTION_CODE TAX_COLL_TAX_AUTHORITY_ID TAX_TAX_EXMPT_SOURCE_TAX TAX_APPLICABLE_BY_DEFAULT_FLAG TAX_DEF_SEC_REC_RATE_CODE TAX_ATTRIBUTE5 TAX_TAX_REGIME_CODE TAX_EXCHANGE_RATE_TYPE TAX_HAS_OTHER_JURISDICTION_FLG TAX_TAX_CURRENCY_CODE TAX_TAXABLE_BASIS_RULE_FLAG TAX_TAX_ACT_CREATE_METHOD_CODE TAX_ATTRIBUTE12 TAX_LAST_UPDATE_DATE TAX_DEF_PLACE_OF_SUP_TYPE_CODE TAX_ATTRIBUTE4 TAX_ATTRIBUTE6 TAX_TAX_RATE_THRSHLD_FLAG TAX_ATTRIBUTE10 TAX_PRI_REC_RATE_DET_RULE_FLAG TAX_EFFECTIVE_TO TAX_TAX_STATUS_RULE_FLAG TAX_SEC_REC_TYPE_RULE_FLAG TAX_MIN_TXBL_BSIS_THRSHLD TAX_TAX_ID TAX_ZONE_GEOGRAPHY_TYPE TAX_HAS_EXG_RATE_DATE_RULE_FLG TAX_ALLOW_EXEMPTIONS_FLAG TAX_WHT_BUCKET_LEVEL_FLAG TAX_ATTRIBUTE8 TAX_ATTRIBUTE14 TAX_TXBL_BSIS_THRSHLD_FLAG TAX_AUTO_PRVN_FLAG TAX_PROGRAM_NAME TAX_ALLOW_MANUAL_ENTRY_FLAG TAX_OVERRIDE_GEOGRAPHY_TYPE TAX_THRSHLD_SCDLE_GRP_LVL_FLG TAX_TAX_RATE_RULE_FLAG TAX_ALLOW_EXCEPTIONS_FLAG TAX_MINIMUM_ACCOUNTABLE_UNIT TAX_LAST_UPDATED_BY TAX_ALLOW_RDNG_OVERRIDE_FLAG TAX_PROCESS_WHT_FLAG TAX_ALLOW_MASS_CREATE_FLAG TAX_DIRECT_RATE_RULE_FLAG TAX_MAX_TAX_AMT_THRSHLD TAX_WHT_DATE_BASIS TAX_TAX_POINT_BASIS TAX_TAXABLE_AMT_MAU TAX_TAX TAX_ATTRIBUTE3 TAX_TAX_FULL_NAME TAX_USE_LEGAL_MSG_FLAG TAX_ROUNDING_RULE_CODE TAX_DEF_INCLUSIVE_TAX_FLAG TAX_ALLOW_RECOVERABILITY_FLAG TAX_SELF_ASSESS_DIFF_TAX TAX_TAX_EXMPT_CR_METHOD_CODE TAX_THRSHLD_GROUPING_LVL_CODE TAX_PROGRAM_LOGIN_ID TAX_UNIQUENESS_VALIDATION_LVL TAX_SPECIAL_INCLUSIVE_TAX_FLAG TAX_MIN_TAX_RATE_THRSHLD TAX_PARENT_GEOGRAPHY_ID TAX_EFFECTIVE_FROM TAX_ALLOW_TAX_OVERRIDE_FLAG TAX_APPLIED_AMT_HANDLING_FLAG TAX_TAX_PRECISION TAX_VALIDATION_LEVEL TAX_TAX_CALC_RULE_FLAG TAX_LIVE_FOR_APPLICABILITY_FLG TAX_CREATION_DATE TAX_APPLICABILITY_RULE_FLAG TAX_RECORD_TYPE_CODE TAX_TAX_INCLUSIVE_OVERRIDE_FLG TAX_LEGAL_REP_STATUS_DEF_VAL TAX_PRIMARY_RECOVERY_TYPE_CODE TAX_TAX_ACCOUNT_SOURCE_TAX TAX_OFFSET_TAX_FLAG TAX_PROGRAM_APP_NAME TAX_SEC_REC_RATE_DET_RULE_FLAG TAX_ATTRIBUTE7 TAX_DEF_PRIMARY_REC_RATE_CODE TAX_TAX_AUTH_INV_CREATION_PNT TAX_SOURCE_TAX_FLAG TAX_THRSHLD_CHK_TMPLT_CODE TAX_MAX_TXBL_BSIS_THRSHLD TAX_DEF_REGSTR_PARTY_TYPE_CODE TAX_TAX_AMT_THRSHLD_FLAG TAX_PRINT_ON_INVOICE_FLAG TAX_MIN_TAX_AMT_THRSHLD TAX_COMPOUNDING_PRECEDENCE TAX_WHT_CALC_POINT_FLAG TAX_ALLOW_DUP_REGN_NUM_FLAG TAX_AUTH_TAX_STLMT_AUTH_ID TAX_AUTH_CREATED_BY TAX_AUTH_CREATION_DATE TAX_AUTH_LAST_UPDATED_BY TAX_AUTH_LAST_UPDATE_LOGIN TAX_AUTH_LAST_UPDATE_DATE TAX_AUTH_INTERNAL_ORG_ID TAX_AUTH_SUPP_SITE_USG_ASMT_ID TAX_AUTH_EFFECTIVE_END_DATE TAX_AUTH_EFFECTIVE_START_DATE TAX_AUTH_SUPPLIER_ID

Query

SQL_Statement

SELECT dist.JOB_DEFINITION_PACKAGE dist_JOB_DEFINITION_PACKAGE, dist.JOB_DEFINITION_NAME dist_JOB_DEFINITION_NAME, dist.INTENDED_USE_CLASSIF_ID dist_INTENDED_USE_CLASSIF_ID, dist.CREATION_DATE dist_CREATION_DATE, dist.RCV_CHARGE_ADDITION_FLAG dist_RCV_CHARGE_ADDITION_FLAG, dist.DETAIL_TAX_LINE_ID dist_DETAIL_TAX_LINE_ID, dist.GLOBAL_ATTRIBUTE_DATE5 dist_GLOBAL_ATTRIBUTE_DATE5, dist.GLOBAL_ATTRIBUTE_DATE4 dist_GLOBAL_ATTRIBUTE_DATE4, dist.GLOBAL_ATTRIBUTE_DATE3 dist_GLOBAL_ATTRIBUTE_DATE3, dist.GLOBAL_ATTRIBUTE_DATE2 dist_GLOBAL_ATTRIBUTE_DATE2, dist.GLOBAL_ATTRIBUTE_DATE1 dist_GLOBAL_ATTRIBUTE_DATE1, dist.GLOBAL_ATTRIBUTE_NUMBER5 dist_GLOBAL_ATTRIBUTE_NUMBER5, dist.GLOBAL_ATTRIBUTE_NUMBER4 dist_GLOBAL_ATTRIBUTE_NUMBER4, dist.GLOBAL_ATTRIBUTE_NUMBER3 dist_GLOBAL_ATTRIBUTE_NUMBER3, dist.GLOBAL_ATTRIBUTE_NUMBER2 dist_GLOBAL_ATTRIBUTE_NUMBER2, dist.GLOBAL_ATTRIBUTE_NUMBER1 dist_GLOBAL_ATTRIBUTE_NUMBER1, dist.ATTRIBUTE_DATE5 dist_ATTRIBUTE_DATE5, dist.ATTRIBUTE_DATE4 dist_ATTRIBUTE_DATE4, dist.ATTRIBUTE_DATE3 dist_ATTRIBUTE_DATE3, dist.ATTRIBUTE_DATE2 dist_ATTRIBUTE_DATE2, dist.ATTRIBUTE_DATE1 dist_ATTRIBUTE_DATE1, dist.ATTRIBUTE_NUMBER5 dist_ATTRIBUTE_NUMBER5, dist.ATTRIBUTE_NUMBER4 dist_ATTRIBUTE_NUMBER4, dist.ATTRIBUTE_NUMBER3 dist_ATTRIBUTE_NUMBER3, dist.ATTRIBUTE_NUMBER2 dist_ATTRIBUTE_NUMBER2, dist.ATTRIBUTE_NUMBER1 dist_ATTRIBUTE_NUMBER1, dist.RECOVERY_RATE_ID dist_RECOVERY_RATE_ID, dist.REC_NREC_RATE dist_REC_NREC_RATE, dist.DETAIL_TAX_DIST_ID dist_DETAIL_TAX_DIST_ID, dist.INTENDED_USE dist_INTENDED_USE, dist.AMOUNT_AT_PREPAY_PAY_XRATE dist_AMT_AT_PREPAY_PAY_XRATE, dist.CASH_BASIS_FINAL_APP_ROUNDING dist_CASH_BASIS_FINAL_APP_RDG, dist.AMOUNT_AT_PREPAY_XRATE dist_AMOUNT_AT_PREPAY_XRATE, dist.FINAL_APPLICATION_ROUNDING dist_FINAL_APPLICATION_RDG, dist.FINAL_PAYMENT_ROUNDING dist_FINAL_PAYMENT_ROUNDING, dist.DISTRIBUTION_CLASS dist_DISTRIBUTION_CLASS, dist.MERCHANT_NAME dist_MERCHANT_NAME, dist.MERCHANT_DOCUMENT_NUMBER dist_MERCHANT_DOCUMENT_NUMBER, dist.TAX_RECOVERABLE_FLAG dist_TAX_RECOVERABLE_FLAG, dist.PARENT_REVERSAL_ID dist_PARENT_REVERSAL_ID, dist.INVOICE_DISTRIBUTION_ID dist_INVOICE_DISTRIBUTION_ID, dist.GLOBAL_ATTRIBUTE17 dist_GLOBAL_ATTRIBUTE17, dist.GLOBAL_ATTRIBUTE16 dist_GLOBAL_ATTRIBUTE16, dist.GLOBAL_ATTRIBUTE15 dist_GLOBAL_ATTRIBUTE15, dist.ATTRIBUTE4 dist_ATTRIBUTE4, dist.ATTRIBUTE3 dist_ATTRIBUTE3, dist.ATTRIBUTE2 dist_ATTRIBUTE2, dist.ATTRIBUTE15 dist_ATTRIBUTE15, dist.ATTRIBUTE14 dist_ATTRIBUTE14, dist.ATTRIBUTE13 dist_ATTRIBUTE13, dist.ATTRIBUTE12 dist_ATTRIBUTE12, dist.ATTRIBUTE11 dist_ATTRIBUTE11, dist.ATTRIBUTE10 dist_ATTRIBUTE10, dist.ATTRIBUTE1 dist_ATTRIBUTE1, dist.STAT_AMOUNT dist_STAT_AMOUNT, dist.ENCUMBERED_FLAG dist_ENCUMBERED_FLAG, dist.UNIT_PRICE dist_UNIT_PRICE, dist.TYPE_1099 dist_TYPE_1099, dist.REVERSAL_FLAG dist_REVERSAL_FLAG, dist.REQUEST_ID dist_REQUEST_ID, dist.QUANTITY_INVOICED dist_QUANTITY_INVOICED, dist.PROGRAM_UPDATE_DATE dist_PROGRAM_UPDATE_DATE, dist.PROGRAM_ID dist_PROGRAM_ID, dist.PROGRAM_APPLICATION_ID dist_PROGRAM_APPLICATION_ID, dist.PO_DISTRIBUTION_ID dist_PO_DISTRIBUTION_ID, dist.POSTED_FLAG dist_POSTED_FLAG, dist.MATCH_STATUS_FLAG dist_MATCH_STATUS_FLAG, dist.LAST_UPDATE_LOGIN dist_LAST_UPDATE_LOGIN, dist.INCOME_TAX_REGION dist_INCOME_TAX_REGION, dist.FINAL_MATCH_FLAG dist_FINAL_MATCH_FLAG, dist.DESCRIPTION dist_DESCRIPTION, dist.CREATED_BY dist_CREATED_BY, dist.BATCH_ID dist_BATCH_ID, dist.BASE_AMOUNT dist_BASE_AMOUNT, dist.AMOUNT dist_AMOUNT, dist.SET_OF_BOOKS_ID dist_SET_OF_BOOKS_ID, dist.PERIOD_NAME dist_PERIOD_NAME, dist.LINE_TYPE_LOOKUP_CODE dist_LINE_TYPE_LOOKUP_CODE, dist.LAST_UPDATE_DATE dist_LAST_UPDATE_DATE, dist.PJC_USER_DEF_ATTRIBUTE10 dist_PJC_USER_DEF_ATTRIBUTE10, dist.PJC_USER_DEF_ATTRIBUTE9 dist_PJC_USER_DEF_ATTRIBUTE9, dist.PJC_USER_DEF_ATTRIBUTE8 dist_PJC_USER_DEF_ATTRIBUTE8, dist.PJC_USER_DEF_ATTRIBUTE7 dist_PJC_USER_DEF_ATTRIBUTE7, dist.PJC_USER_DEF_ATTRIBUTE6 dist_PJC_USER_DEF_ATTRIBUTE6, dist.PJC_USER_DEF_ATTRIBUTE5 dist_PJC_USER_DEF_ATTRIBUTE5, dist.PJC_USER_DEF_ATTRIBUTE4 dist_PJC_USER_DEF_ATTRIBUTE4, dist.PJC_USER_DEF_ATTRIBUTE3 dist_PJC_USER_DEF_ATTRIBUTE3, dist.ASSET_CATEGORY_ID dist_ASSET_CATEGORY_ID, dist.ASSET_BOOK_TYPE_CODE dist_ASSET_BOOK_TYPE_CODE, dist.GLOBAL_ATTRIBUTE9 dist_GLOBAL_ATTRIBUTE9, dist.GLOBAL_ATTRIBUTE8 dist_GLOBAL_ATTRIBUTE8, dist.GLOBAL_ATTRIBUTE7 dist_GLOBAL_ATTRIBUTE7, dist.GLOBAL_ATTRIBUTE6 dist_GLOBAL_ATTRIBUTE6, dist.GLOBAL_ATTRIBUTE5 dist_GLOBAL_ATTRIBUTE5, dist.GLOBAL_ATTRIBUTE4 dist_GLOBAL_ATTRIBUTE4, dist.GLOBAL_ATTRIBUTE3 dist_GLOBAL_ATTRIBUTE3, dist.GLOBAL_ATTRIBUTE2 dist_GLOBAL_ATTRIBUTE2, dist.GLOBAL_ATTRIBUTE1 dist_GLOBAL_ATTRIBUTE1, dist.GLOBAL_ATTRIBUTE_CATEGORY dist_GLOBAL_ATTRIBUTE_CATEGORY, dist.AWT_INVOICE_PAYMENT_ID dist_AWT_INVOICE_PAYMENT_ID, dist.ORG_ID dist_ORG_ID, dist.REFERENCE_2 dist_REFERENCE_2, dist.REFERENCE_1 dist_REFERENCE_1, dist.AWT_ORIGIN_GROUP_ID dist_AWT_ORIGIN_GROUP_ID, dist.AWT_INVOICE_ID dist_AWT_INVOICE_ID, dist.AWT_GROSS_AMOUNT dist_AWT_GROSS_AMOUNT, dist.AWT_TAX_RATE_ID dist_AWT_TAX_RATE_ID, dist.AWT_GROUP_ID dist_AWT_GROUP_ID, dist.AWT_FLAG dist_AWT_FLAG, dist.TASK_ID dist_TASK_ID, dist.PROJECT_ID dist_PROJECT_ID, dist.PREPAY_AMOUNT_REMAINING dist_PREPAY_AMOUNT_REMAINING, dist.PA_QUANTITY dist_PA_QUANTITY, dist.PA_ADDITION_FLAG dist_PA_ADDITION_FLAG, dist.PARENT_INVOICE_ID dist_PARENT_INVOICE_ID, dist.EXPENDITURE_TYPE dist_EXPENDITURE_TYPE, dist.EXPENDITURE_ORGANIZATION_ID dist_EXPENDITURE_ORG_ID, dist.EXPENDITURE_ITEM_DATE dist_EXPENDITURE_ITEM_DATE, dist.ATTRIBUTE_CATEGORY dist_ATTRIBUTE_CATEGORY, dist.ATTRIBUTE9 dist_ATTRIBUTE9, dist.ATTRIBUTE8 dist_ATTRIBUTE8, dist.ATTRIBUTE7 dist_ATTRIBUTE7, dist.ATTRIBUTE6 dist_ATTRIBUTE6, dist.ATTRIBUTE5 dist_ATTRIBUTE5, dist.RCV_TRANSACTION_ID dist_RCV_TRANSACTION_ID, dist.DIST_MATCH_TYPE dist_DIST_MATCH_TYPE, dist.CREDIT_CARD_TRX_ID dist_CREDIT_CARD_TRX_ID, dist.AWARD_ID dist_AWARD_ID, dist.ADJUSTMENT_REASON dist_ADJUSTMENT_REASON, dist.WEB_PARAMETER_ID dist_WEB_PARAMETER_ID, dist.DAILY_AMOUNT dist_DAILY_AMOUNT, dist.RECEIPT_CURRENCY_AMOUNT dist_RECEIPT_CURRENCY_AMOUNT, dist.RECEIPT_CONVERSION_RATE dist_RECEIPT_CONVERSION_RATE, dist.RECEIPT_CURRENCY_CODE dist_RECEIPT_CURRENCY_CODE, dist.END_EXPENSE_DATE dist_END_EXPENSE_DATE, dist.START_EXPENSE_DATE dist_START_EXPENSE_DATE, dist.EXPENSE_GROUP dist_EXPENSE_GROUP, dist.JUSTIFICATION dist_JUSTIFICATION, dist.RECEIPT_MISSING_FLAG dist_RECEIPT_MISSING_FLAG, dist.RECEIPT_REQUIRED_FLAG dist_RECEIPT_REQUIRED_FLAG, dist.RECEIPT_VERIFIED_FLAG dist_RECEIPT_VERIFIED_FLAG, dist.GLOBAL_ATTRIBUTE20 dist_GLOBAL_ATTRIBUTE20, dist.PJC_USER_DEF_ATTRIBUTE2 dist_PJC_USER_DEF_ATTRIBUTE2, dist.PJC_USER_DEF_ATTRIBUTE1 dist_PJC_USER_DEF_ATTRIBUTE1, dist.PJC_RESERVED_ATTRIBUTE10 dist_PJC_RESERVED_ATTRIBUTE10, dist.PJC_RESERVED_ATTRIBUTE9 dist_PJC_RESERVED_ATTRIBUTE9, dist.PJC_RESERVED_ATTRIBUTE8 dist_PJC_RESERVED_ATTRIBUTE8, dist.PJC_RESERVED_ATTRIBUTE7 dist_PJC_RESERVED_ATTRIBUTE7, dist.PJC_RESERVED_ATTRIBUTE6 dist_PJC_RESERVED_ATTRIBUTE6, dist.DISTRIBUTION_LINE_NUMBER dist_DISTRIBUTION_LINE_NUMBER, dist.ASSETS_TRACKING_FLAG dist_ASSETS_TRACKING_FLAG, dist.ASSETS_ADDITION_FLAG dist_ASSETS_ADDITION_FLAG, dist.ACCOUNTING_DATE dist_ACCOUNTING_DATE, dist.RELATED_ID dist_RELATED_ID, dist.CORRECTED_QUANTITY dist_CORRECTED_QUANTITY, dist.CHARGE_APPLICABLE_TO_DIST_ID dist_CHARGE_APPL_TO_DIST_ID, dist.ROUNDING_AMT dist_ROUNDING_AMT, dist.CORRECTED_INVOICE_DIST_ID dist_CORRECTED_INVOICE_DIST_ID, dist.INVOICE_LINE_NUMBER dist_INVOICE_LINE_NUMBER, dist.CANCELLATION_FLAG dist_CANCELLATION_FLAG, dist.PA_CMT_XFACE_FLAG dist_PA_CMT_XFACE_FLAG, dist.INVOICE_INCLUDES_PREPAY_FLAG dist_INV_INCLUDES_PREPAY_FLAG, dist.CC_REVERSAL_FLAG dist_CC_REVERSAL_FLAG, dist.COMPANY_PREPAID_INVOICE_ID dist_COMPANY_PREPAID_INV_ID, dist.INVENTORY_TRANSFER_STATUS dist_INVENTORY_TRANSFER_STATUS, dist.UPGRADE_BASE_POSTED_AMT dist_UPGRADE_BASE_POSTED_AMT, dist.UPGRADE_POSTED_AMT dist_UPGRADE_POSTED_AMT, dist.PREPAY_DISTRIBUTION_ID dist_PREPAY_DISTRIBUTION_ID, dist.ACCOUNTING_EVENT_ID dist_ACCOUNTING_EVENT_ID, dist.GMS_BURDENABLE_RAW_COST dist_GMS_BURDENABLE_RAW_COST, dist.MATCHED_UOM_LOOKUP_CODE dist_MATCHED_UOM_LOOKUP_CODE, dist.GLOBAL_ATTRIBUTE14 dist_GLOBAL_ATTRIBUTE14, dist.PJC_RESERVED_ATTRIBUTE5 dist_PJC_RESERVED_ATTRIBUTE5, dist.PJC_RESERVED_ATTRIBUTE4 dist_PJC_RESERVED_ATTRIBUTE4, dist.PJC_RESERVED_ATTRIBUTE3 dist_PJC_RESERVED_ATTRIBUTE3, dist.PJC_RESERVED_ATTRIBUTE2 dist_PJC_RESERVED_ATTRIBUTE2, dist.PJC_RESERVED_ATTRIBUTE1 dist_PJC_RESERVED_ATTRIBUTE1, dist.PJC_FUNDING_ALLOCATION_ID dist_PJC_FUNDING_ALLOCATION_ID, dist.PJC_CONTRACT_LINE_ID dist_PJC_CONTRACT_LINE_ID, dist.PJC_CONTRACT_ID dist_PJC_CONTRACT_ID, dist.PJC_WORK_TYPE_ID dist_PJC_WORK_TYPE_ID, dist.PJC_CAPITALIZABLE_FLAG dist_PJC_CAPITALIZABLE_FLAG, dist.PJC_BILLABLE_FLAG dist_PJC_BILLABLE_FLAG, dist.PJC_ORGANIZATION_ID dist_PJC_ORGANIZATION_ID, dist.PJC_EXPENDITURE_ITEM_DATE dist_PJC_EXPENDITURE_ITEM_DATE, dist.PJC_EXPENDITURE_TYPE_ID dist_PJC_EXPENDITURE_TYPE_ID, dist.PJC_TASK_ID dist_PJC_TASK_ID, dist.PJC_PROJECT_ID dist_PJC_PROJECT_ID, dist.PJC_CONTEXT_CATEGORY dist_PJC_CONTEXT_CATEGORY, dist.EXCHANGE_DATE dist_EXCHANGE_DATE, dist.EXCHANGE_RATE dist_EXCHANGE_RATE, dist.EXCHANGE_RATE_TYPE dist_EXCHANGE_RATE_TYPE, dist.BASE_QUANTITY_VARIANCE dist_BASE_QUANTITY_VARIANCE, dist.QUANTITY_VARIANCE dist_QUANTITY_VARIANCE, dist.RELEASE_INV_DIST_DERIVED_FROM dist_REL_INV_DIST_DERIVED_FROM, dist.RECURRING_PAYMENT_ID dist_RECURRING_PAYMENT_ID, dist.XINV_PARENT_REVERSAL_ID dist_XINV_PARENT_REVERSAL_ID, dist.ROOT_DISTRIBUTION_ID dist_ROOT_DISTRIBUTION_ID, dist.FULLY_PAID_ACCTD_FLAG dist_FULLY_PAID_ACCTD_FLAG, dist.FINAL_RELEASE_ROUNDING dist_FINAL_RELEASE_ROUNDING, dist.RETAINED_INVOICE_DIST_ID dist_RETAINED_INVOICE_DIST_ID, dist.BC_EVENT_ID dist_BC_EVENT_ID, dist.RETAINED_AMOUNT_REMAINING dist_RETAINED_AMOUNT_REMAINING, dist.RELATED_RETAINAGE_DIST_ID dist_RELATED_RETAINAGE_DIST_ID, dist.AWT_RELATED_ID dist_AWT_RELATED_ID, dist.HISTORICAL_FLAG dist_HISTORICAL_FLAG, dist.BASE_AMOUNT_VARIANCE dist_BASE_AMOUNT_VARIANCE, dist.AMOUNT_VARIANCE dist_AMOUNT_VARIANCE, dist.OLD_DIST_LINE_NUMBER dist_OLD_DIST_LINE_NUMBER, dist.OLD_DISTRIBUTION_ID dist_OLD_DISTRIBUTION_ID, dist.TOTAL_DIST_BASE_AMOUNT dist_TOTAL_DIST_BASE_AMOUNT, dist.TOTAL_DIST_AMOUNT dist_TOTAL_DIST_AMOUNT, dist.TAX_CODE_ID dist_TAX_CODE_ID, dist.PREPAY_TAX_DIFF_AMOUNT dist_PREPAY_TAX_DIFF_AMOUNT, dist.EXTRA_PO_ERV dist_EXTRA_PO_ERV, dist.TAXABLE_BASE_AMOUNT dist_TAXABLE_BASE_AMOUNT, dist.TAXABLE_AMOUNT dist_TAXABLE_AMOUNT, dist.SUMMARY_TAX_LINE_ID dist_SUMMARY_TAX_LINE_ID, dist.TAX_ALREADY_DISTRIBUTED_FLAG dist_TAX_ALREADY_DIST_FLAG, dist.WITHHOLDING_TAX_CODE_ID dist_WITHHOLDING_TAX_CODE_ID, dist.GLOBAL_ATTRIBUTE12 dist_GLOBAL_ATTRIBUTE12, dist.GLOBAL_ATTRIBUTE11 dist_GLOBAL_ATTRIBUTE11, dist.GLOBAL_ATTRIBUTE10 dist_GLOBAL_ATTRIBUTE10, dist.GLOBAL_ATTRIBUTE19 dist_GLOBAL_ATTRIBUTE19, dist.GLOBAL_ATTRIBUTE18 dist_GLOBAL_ATTRIBUTE18, dist.COUNTRY_OF_SUPPLY dist_COUNTRY_OF_SUPPLY, dist.MERCHANT_TAXPAYER_ID dist_MERCHANT_TAXPAYER_ID, dist.MERCHANT_TAX_REG_NUMBER dist_MERCHANT_TAX_REG_NUMBER, dist.MERCHANT_REFERENCE dist_MERCHANT_REFERENCE, dist.RECOVERY_RATE_CODE dist_RECOVERY_RATE_CODE, dist.RECOVERY_TYPE_CODE dist_RECOVERY_TYPE_CODE, dist.RECOVERY_RATE_NAME dist_RECOVERY_RATE_NAME, dist.INVOICE_ID dist_INVOICE_ID, dist.DIST_CODE_COMBINATION_ID dist_DIST_CODE_COMBINATION_ID, dist.LAST_UPDATED_BY dist_LAST_UPDATED_BY, dist.GLOBAL_ATTRIBUTE13 dist_GLOBAL_ATTRIBUTE13, dist.DATA_SET_ID dist_DATA_SET_ID, dist.CONSUMPTION_ADVICE_LINE_ID dist_CONSUMP_ADVICE_LINE_ID, dist.CONSUMPTION_ADVICE_HEADER_ID dist_CONSUMP_ADVICE_HEADER_ID, dist.FUNDS_STATUS dist_FUNDS_STATUS, dist.BUDGET_DATE dist_BUDGET_DATE, tax_data.rate_ATTRIBUTE6, tax_data.rate_ATTRIBUTE5, tax_data.rate_ATTRIBUTE4, tax_data.rate_ATTRIBUTE3, tax_data.rate_ATTRIBUTE2, tax_data.rate_ATTRIBUTE1, tax_data.rate_LAST_UPDATE_LOGIN, tax_data.rate_LAST_UPDATED_BY, tax_data.rate_CREATED_BY, tax_data.rate_VAT_TRANSACTION_TYPE_CODE, tax_data.rate_RECOVERY_RULE_CODE, tax_data.rate_DEFAULT_REC_TYPE_CODE, tax_data.rate_DEFAULT_FLG_EFF_FROM, tax_data.rate_DEFAULT_RATE_FLAG, tax_data.rate_RECOVERY_TYPE_CODE, tax_data.rate_UOM_CODE, tax_data.rate_PERCENTAGE_RATE, tax_data.rate_SCHEDULE_BASED_RATE_FLAG, tax_data.rate_EFFECTIVE_TO, tax_data.rate_REQUEST_ID, tax_data.rate_LAST_UPDATE_DATE, tax_data.rate_CREATION_DATE, tax_data.rate_RECORD_TYPE_CODE, tax_data.rate_OFFSET_TAX_RATE_CODE, tax_data.rate_OFFSET_TAX, tax_data.rate_DEFAULT_REC_RATE_CODE, tax_data.rate_DEFAULT_FLG_EFFECTIVE_TO, tax_data.rate_ACTIVE_FLAG, tax_data.rate_TAX_JURISDICTION_CODE, tax_data.rate_QUANTITY_RATE, tax_data.rate_RATE_TYPE_CODE, tax_data.rate_TAX_STATUS_CODE, tax_data.rate_EFFECTIVE_FROM, tax_data.rate_TAX_RATE_CODE, tax_data.rate_OFFSET_STATUS_CODE, tax_data.rate_ATTRIBUTE_DATE5, tax_data.rate_ATTRIBUTE_DATE4, tax_data.rate_ATTRIBUTE_DATE3, tax_data.rate_ATTRIBUTE_DATE2, tax_data.rate_ATTRIBUTE_DATE1, tax_data.rate_ATTRIBUTE_NUMBER5, tax_data.rate_ATTRIBUTE_NUMBER4, tax_data.rate_ATTRIBUTE_NUMBER3, tax_data.rate_ATTRIBUTE_NUMBER2, tax_data.rate_ATTRIBUTE_NUMBER1, tax_data.rate_PROGRAM_APP_NAME, tax_data.rate_PROGRAM_NAME, tax_data.rate_DESCRIPTION, tax_data.rate_TAX_INCLU_OVERRIDE_FLAG, tax_data.rate_INCLUSIVE_TAX_FLAG, tax_data.rate_TAXABLE_BASIS_FORM_CODE, tax_data.rate_SOURCE_ID, tax_data.rate_TAX_CLASS, tax_data.rate_ALLOW_ADHOC_TAX_RATE_FLAG, tax_data.rate_ADJ_FOR_ADHOC_AMT_CODE, tax_data.rate_TAX_RATE_ID, tax_data.rate_PROGRAM_LOGIN_ID, tax_data.rate_ATTRIBUTE_CATEGORY, tax_data.rate_ATTRIBUTE15, tax_data.rate_ATTRIBUTE14, tax_data.rate_ATTRIBUTE13, tax_data.rate_ATTRIBUTE12, tax_data.rate_ATTRIBUTE11, tax_data.rate_ATTRIBUTE10, tax_data.rate_ATTRIBUTE9, tax_data.rate_ATTRIBUTE8, tax_data.rate_ATTRIBUTE7, tax_data.tax_ATTRIBUTE2, tax_data.tax_CONTENT_OWNER_ID, tax_data.tax_VALIDATION_TYPE, tax_data.tax_DEF_TAX_CALC_FORMULA, tax_data.tax_LAST_UPDATE_LOGIN, tax_data.tax_CALC_ONLY_FLAG, tax_data.tax_ATTRIBUTE15, tax_data.tax_TAX_TYPE_CODE, tax_data.tax_PRIMARY_REC_TYPE_RULE_FLAG, tax_data.tax_ALLOW_ZERO_AMT_WHT_INV_FLG, tax_data.tax_ATTRIBUTE13, tax_data.tax_ATTRIBUTE_CATEGORY, tax_data.tax_HAS_TAXPOINT_DATE_RULE_FLG, tax_data.tax_HAS_DETAIL_TB_THRSHLD_FLAG, tax_data.tax_PLACE_OF_SUPPLY_RULE_FLAG, tax_data.tax_SEC_RECOVERY_TYPE_CODE, tax_data.tax_CHARGE_LINE_HANDLING_CODE, tax_data.tax_LIVE_FOR_PROCESSING_FLAG, tax_data.tax_REP_TAX_AUTHORITY_ID, tax_data.tax_CREATED_BY, tax_data.tax_ATTRIBUTE11, tax_data.tax_PERIOD_SET_NAME, tax_data.tax_ATTRIBUTE9, tax_data.tax_REPORTING_ONLY_FLAG, tax_data.tax_REGN_NUM_SAME_AS_LE_FLAG, tax_data.tax_REGISTRATION_TYPE_RULE_FLG, tax_data.tax_PARENT_GEOGRAPHY_TYPE, tax_data.tax_DEF_TAXABLE_BASIS_FORMULA, tax_data.tax_REQUEST_ID, tax_data.tax_MAX_TAX_RATE_THRSHLD, tax_data.tax_ATTRIBUTE1, tax_data.tax_HAS_TAX_DET_DATE_RULE_FLAG, tax_data.tax_ROW_ID, tax_data.tax_RECOVERY_RATE_OVERRIDE_FLG, tax_data.tax_DEF_REC_STLMT_OPTION_CODE, tax_data.tax_COLL_TAX_AUTHORITY_ID, tax_data.tax_TAX_EXMPT_SOURCE_TAX, tax_data.tax_APPLICABLE_BY_DEFAULT_FLAG, tax_data.tax_DEF_SEC_REC_RATE_CODE, tax_data.tax_ATTRIBUTE5, tax_data.tax_TAX_REGIME_CODE, tax_data.tax_EXCHANGE_RATE_TYPE, tax_data.tax_HAS_OTHER_JURISDICTION_FLG, tax_data.tax_TAX_CURRENCY_CODE, tax_data.tax_TAXABLE_BASIS_RULE_FLAG, tax_data.tax_TAX_ACT_CREATE_METHOD_CODE, tax_data.tax_ATTRIBUTE12, tax_data.tax_LAST_UPDATE_DATE, tax_data.tax_DEF_PLACE_OF_SUP_TYPE_CODE, tax_data.tax_ATTRIBUTE4, tax_data.tax_ATTRIBUTE6, tax_data.tax_TAX_RATE_THRSHLD_FLAG, tax_data.tax_ATTRIBUTE10, tax_data.tax_PRI_REC_RATE_DET_RULE_FLAG, tax_data.tax_EFFECTIVE_TO, tax_data.tax_TAX_STATUS_RULE_FLAG, tax_data.tax_SEC_REC_TYPE_RULE_FLAG, tax_data.tax_MIN_TXBL_BSIS_THRSHLD, tax_data.tax_TAX_ID, tax_data.tax_ZONE_GEOGRAPHY_TYPE, tax_data.tax_HAS_EXG_RATE_DATE_RULE_FLG, tax_data.tax_ALLOW_EXEMPTIONS_FLAG, tax_data.tax_WHT_BUCKET_LEVEL_FLAG, tax_data.tax_ATTRIBUTE8, tax_data.tax_ATTRIBUTE14, tax_data.tax_TXBL_BSIS_THRSHLD_FLAG, tax_data.tax_AUTO_PRVN_FLAG, tax_data.tax_PROGRAM_NAME, tax_data.tax_ALLOW_MANUAL_ENTRY_FLAG, tax_data.tax_OVERRIDE_GEOGRAPHY_TYPE, tax_data.tax_THRSHLD_SCDLE_GRP_LVL_FLG, tax_data.tax_TAX_RATE_RULE_FLAG, tax_data.tax_ALLOW_EXCEPTIONS_FLAG, tax_data.tax_MINIMUM_ACCOUNTABLE_UNIT, tax_data.tax_LAST_UPDATED_BY, tax_data.tax_ALLOW_RDNG_OVERRIDE_FLAG, tax_data.tax_PROCESS_WHT_FLAG, tax_data.tax_ALLOW_MASS_CREATE_FLAG, tax_data.tax_DIRECT_RATE_RULE_FLAG, tax_data.tax_MAX_TAX_AMT_THRSHLD, tax_data.tax_WHT_DATE_BASIS, tax_data.tax_TAX_POINT_BASIS, tax_data.tax_TAXABLE_AMT_MAU, tax_data.tax_TAX, tax_data.tax_ATTRIBUTE3, tax_data.tax_TAX_FULL_NAME, tax_data.tax_USE_LEGAL_MSG_FLAG, tax_data.tax_ROUNDING_RULE_CODE, tax_data.tax_DEF_INCLUSIVE_TAX_FLAG, tax_data.tax_ALLOW_RECOVERABILITY_FLAG, tax_data.tax_SELF_ASSESS_DIFF_TAX, tax_data.tax_TAX_EXMPT_CR_METHOD_CODE, tax_data.tax_THRSHLD_GROUPING_LVL_CODE, tax_data.tax_PROGRAM_LOGIN_ID, tax_data.tax_UNIQUENESS_VALIDATION_LVL, tax_data.tax_SPECIAL_INCLUSIVE_TAX_FLAG, tax_data.tax_MIN_TAX_RATE_THRSHLD, tax_data.tax_PARENT_GEOGRAPHY_ID, tax_data.tax_EFFECTIVE_FROM, tax_data.tax_ALLOW_TAX_OVERRIDE_FLAG, tax_data.tax_APPLIED_AMT_HANDLING_FLAG, tax_data.tax_TAX_PRECISION, tax_data.tax_VALIDATION_LEVEL, tax_data.tax_TAX_CALC_RULE_FLAG, tax_data.tax_LIVE_FOR_APPLICABILITY_FLG, tax_data.tax_CREATION_DATE, tax_data.tax_APPLICABILITY_RULE_FLAG, tax_data.tax_RECORD_TYPE_CODE, tax_data.tax_TAX_INCLUSIVE_OVERRIDE_FLG, tax_data.tax_LEGAL_REP_STATUS_DEF_VAL, tax_data.tax_PRIMARY_RECOVERY_TYPE_CODE, tax_data.tax_TAX_ACCOUNT_SOURCE_TAX, tax_data.tax_OFFSET_TAX_FLAG, tax_data.tax_PROGRAM_APP_NAME, tax_data.tax_SEC_REC_RATE_DET_RULE_FLAG, tax_data.tax_ATTRIBUTE7, tax_data.tax_DEF_PRIMARY_REC_RATE_CODE, tax_data.tax_TAX_AUTH_INV_CREATION_PNT, tax_data.tax_SOURCE_TAX_FLAG, tax_data.tax_THRSHLD_CHK_TMPLT_CODE, tax_data.tax_MAX_TXBL_BSIS_THRSHLD, tax_data.tax_DEF_REGSTR_PARTY_TYPE_CODE, tax_data.tax_TAX_AMT_THRSHLD_FLAG, tax_data.tax_PRINT_ON_INVOICE_FLAG, tax_data.tax_MIN_TAX_AMT_THRSHLD, tax_data.tax_COMPOUNDING_PRECEDENCE, tax_data.tax_WHT_CALC_POINT_FLAG, tax_data.tax_ALLOW_DUP_REGN_NUM_FLAG, tax_data.tax_auth_TAX_STLMT_AUTH_ID, tax_data.tax_auth_CREATED_BY, tax_data.tax_auth_CREATION_DATE, tax_data.tax_auth_LAST_UPDATED_BY, tax_data.tax_auth_LAST_UPDATE_LOGIN, tax_data.tax_auth_LAST_UPDATE_DATE, tax_data.tax_auth_INTERNAL_ORG_ID, tax_data.tax_auth_SUPP_SITE_USG_ASMT_ID, tax_data.tax_auth_EFFECTIVE_END_DATE, tax_data.tax_auth_EFFECTIVE_START_DATE, tax_data.tax_auth_SUPPLIER_ID FROM ap_invoice_distributions_all dist , (select rate.ATTRIBUTE6 rate_ATTRIBUTE6, rate.ATTRIBUTE5 rate_ATTRIBUTE5, rate.ATTRIBUTE4 rate_ATTRIBUTE4, rate.ATTRIBUTE3 rate_ATTRIBUTE3, rate.ATTRIBUTE2 rate_ATTRIBUTE2, rate.ATTRIBUTE1 rate_ATTRIBUTE1, rate.LAST_UPDATE_LOGIN rate_LAST_UPDATE_LOGIN, rate.LAST_UPDATED_BY rate_LAST_UPDATED_BY, rate.CREATED_BY rate_CREATED_BY, rate.VAT_TRANSACTION_TYPE_CODE rate_VAT_TRANSACTION_TYPE_CODE, rate.RECOVERY_RULE_CODE rate_RECOVERY_RULE_CODE, rate.DEFAULT_REC_TYPE_CODE rate_DEFAULT_REC_TYPE_CODE, rate.DEFAULT_FLG_EFFECTIVE_FROM rate_DEFAULT_FLG_EFF_FROM, rate.DEFAULT_RATE_FLAG rate_DEFAULT_RATE_FLAG, rate.RECOVERY_TYPE_CODE rate_RECOVERY_TYPE_CODE, rate.UOM_CODE rate_UOM_CODE, rate.PERCENTAGE_RATE rate_PERCENTAGE_RATE, rate.SCHEDULE_BASED_RATE_FLAG rate_SCHEDULE_BASED_RATE_FLAG, rate.EFFECTIVE_TO rate_EFFECTIVE_TO, rate.REQUEST_ID rate_REQUEST_ID, rate.LAST_UPDATE_DATE rate_LAST_UPDATE_DATE, rate.CREATION_DATE rate_CREATION_DATE, rate.RECORD_TYPE_CODE rate_RECORD_TYPE_CODE, rate.OFFSET_TAX_RATE_CODE rate_OFFSET_TAX_RATE_CODE, rate.OFFSET_TAX rate_OFFSET_TAX, rate.DEFAULT_REC_RATE_CODE rate_DEFAULT_REC_RATE_CODE, rate.DEFAULT_FLG_EFFECTIVE_TO rate_DEFAULT_FLG_EFFECTIVE_TO, rate.ACTIVE_FLAG rate_ACTIVE_FLAG, rate.TAX_JURISDICTION_CODE rate_TAX_JURISDICTION_CODE, rate.QUANTITY_RATE rate_QUANTITY_RATE, rate.RATE_TYPE_CODE rate_RATE_TYPE_CODE, rate.TAX_STATUS_CODE rate_TAX_STATUS_CODE, rate.EFFECTIVE_FROM rate_EFFECTIVE_FROM, rate.TAX_RATE_CODE rate_TAX_RATE_CODE, rate.OFFSET_STATUS_CODE rate_OFFSET_STATUS_CODE, rate.ATTRIBUTE_DATE5 rate_ATTRIBUTE_DATE5, rate.ATTRIBUTE_DATE4 rate_ATTRIBUTE_DATE4, rate.ATTRIBUTE_DATE3 rate_ATTRIBUTE_DATE3, rate.ATTRIBUTE_DATE2 rate_ATTRIBUTE_DATE2, rate.ATTRIBUTE_DATE1 rate_ATTRIBUTE_DATE1, rate.ATTRIBUTE_NUMBER5 rate_ATTRIBUTE_NUMBER5, rate.ATTRIBUTE_NUMBER4 rate_ATTRIBUTE_NUMBER4, rate.ATTRIBUTE_NUMBER3 rate_ATTRIBUTE_NUMBER3, rate.ATTRIBUTE_NUMBER2 rate_ATTRIBUTE_NUMBER2, rate.ATTRIBUTE_NUMBER1 rate_ATTRIBUTE_NUMBER1, rate.PROGRAM_APP_NAME rate_PROGRAM_APP_NAME, rate.PROGRAM_NAME rate_PROGRAM_NAME, rate.DESCRIPTION rate_DESCRIPTION, rate.TAX_INCLUSIVE_OVERRIDE_FLAG rate_TAX_INCLU_OVERRIDE_FLAG, rate.INCLUSIVE_TAX_FLAG rate_INCLUSIVE_TAX_FLAG, rate.TAXABLE_BASIS_FORMULA_CODE rate_TAXABLE_BASIS_FORM_CODE, rate.SOURCE_ID rate_SOURCE_ID, rate.TAX_CLASS rate_TAX_CLASS, rate.ALLOW_ADHOC_TAX_RATE_FLAG rate_ALLOW_ADHOC_TAX_RATE_FLAG, rate.ADJ_FOR_ADHOC_AMT_CODE rate_ADJ_FOR_ADHOC_AMT_CODE, rate.TAX_RATE_ID rate_TAX_RATE_ID, rate.PROGRAM_LOGIN_ID rate_PROGRAM_LOGIN_ID, rate.ATTRIBUTE_CATEGORY rate_ATTRIBUTE_CATEGORY, rate.ATTRIBUTE15 rate_ATTRIBUTE15, rate.ATTRIBUTE14 rate_ATTRIBUTE14, rate.ATTRIBUTE13 rate_ATTRIBUTE13, rate.ATTRIBUTE12 rate_ATTRIBUTE12, rate.ATTRIBUTE11 rate_ATTRIBUTE11, rate.ATTRIBUTE10 rate_ATTRIBUTE10, rate.ATTRIBUTE9 rate_ATTRIBUTE9, rate.ATTRIBUTE8 rate_ATTRIBUTE8, rate.ATTRIBUTE7 rate_ATTRIBUTE7, tax.ATTRIBUTE2 tax_ATTRIBUTE2, tax.CONTENT_OWNER_ID tax_CONTENT_OWNER_ID, tax.VALIDATION_TYPE tax_VALIDATION_TYPE, tax.DEF_TAX_CALC_FORMULA tax_DEF_TAX_CALC_FORMULA, tax.LAST_UPDATE_LOGIN tax_LAST_UPDATE_LOGIN, tax.CALC_ONLY_FLAG tax_CALC_ONLY_FLAG, tax.ATTRIBUTE15 tax_ATTRIBUTE15, tax.TAX_TYPE_CODE tax_TAX_TYPE_CODE, tax.PRIMARY_REC_TYPE_RULE_FLAG tax_PRIMARY_REC_TYPE_RULE_FLAG, tax.ALLOW_ZERO_AMT_WHT_INV_FLAG tax_ALLOW_ZERO_AMT_WHT_INV_FLG, tax.ATTRIBUTE13 tax_ATTRIBUTE13, tax.ATTRIBUTE_CATEGORY tax_ATTRIBUTE_CATEGORY, tax.HAS_TAX_POINT_DATE_RULE_FLAG tax_HAS_TAXPOINT_DATE_RULE_FLG, tax.HAS_DETAIL_TB_THRSHLD_FLAG tax_HAS_DETAIL_TB_THRSHLD_FLAG, tax.PLACE_OF_SUPPLY_RULE_FLAG tax_PLACE_OF_SUPPLY_RULE_FLAG, tax.SECONDARY_RECOVERY_TYPE_CODE tax_SEC_RECOVERY_TYPE_CODE, tax.CHARGE_LINE_HANDLING_CODE tax_CHARGE_LINE_HANDLING_CODE, tax.LIVE_FOR_PROCESSING_FLAG tax_LIVE_FOR_PROCESSING_FLAG, tax.REP_TAX_AUTHORITY_ID tax_REP_TAX_AUTHORITY_ID, tax.CREATED_BY tax_CREATED_BY, tax.ATTRIBUTE11 tax_ATTRIBUTE11, tax.PERIOD_SET_NAME tax_PERIOD_SET_NAME, tax.ATTRIBUTE9 tax_ATTRIBUTE9, tax.REPORTING_ONLY_FLAG tax_REPORTING_ONLY_FLAG, tax.REGN_NUM_SAME_AS_LE_FLAG tax_REGN_NUM_SAME_AS_LE_FLAG, tax.REGISTRATION_TYPE_RULE_FLAG tax_REGISTRATION_TYPE_RULE_FLG, tax.PARENT_GEOGRAPHY_TYPE tax_PARENT_GEOGRAPHY_TYPE, tax.DEF_TAXABLE_BASIS_FORMULA tax_DEF_TAXABLE_BASIS_FORMULA, tax.REQUEST_ID tax_REQUEST_ID, tax.MAX_TAX_RATE_THRSHLD tax_MAX_TAX_RATE_THRSHLD, tax.ATTRIBUTE1 tax_ATTRIBUTE1, tax.HAS_TAX_DET_DATE_RULE_FLAG tax_HAS_TAX_DET_DATE_RULE_FLAG, tax.ROW_ID tax_ROW_ID, tax.RECOVERY_RATE_OVERRIDE_FLAG tax_RECOVERY_RATE_OVERRIDE_FLG, tax.DEF_REC_SETTLEMENT_OPTION_CODE tax_DEF_REC_STLMT_OPTION_CODE, tax.COLL_TAX_AUTHORITY_ID tax_COLL_TAX_AUTHORITY_ID, tax.TAX_EXMPT_SOURCE_TAX tax_TAX_EXMPT_SOURCE_TAX, tax.APPLICABLE_BY_DEFAULT_FLAG tax_APPLICABLE_BY_DEFAULT_FLAG, tax.DEF_SECONDARY_REC_RATE_CODE tax_DEF_SEC_REC_RATE_CODE, tax.ATTRIBUTE5 tax_ATTRIBUTE5, tax.TAX_REGIME_CODE tax_TAX_REGIME_CODE, tax.EXCHANGE_RATE_TYPE tax_EXCHANGE_RATE_TYPE, tax.HAS_OTHER_JURISDICTIONS_FLAG tax_HAS_OTHER_JURISDICTION_FLG, tax.TAX_CURRENCY_CODE tax_TAX_CURRENCY_CODE, tax.TAXABLE_BASIS_RULE_FLAG tax_TAXABLE_BASIS_RULE_FLAG, tax.TAX_ACCOUNT_CREATE_METHOD_CODE tax_TAX_ACT_CREATE_METHOD_CODE, tax.ATTRIBUTE12 tax_ATTRIBUTE12, tax.LAST_UPDATE_DATE tax_LAST_UPDATE_DATE, tax.DEF_PLACE_OF_SUPPLY_TYPE_CODE tax_DEF_PLACE_OF_SUP_TYPE_CODE, tax.ATTRIBUTE4 tax_ATTRIBUTE4, tax.ATTRIBUTE6 tax_ATTRIBUTE6, tax.TAX_RATE_THRSHLD_FLAG tax_TAX_RATE_THRSHLD_FLAG, tax.ATTRIBUTE10 tax_ATTRIBUTE10, tax.PRIMARY_REC_RATE_DET_RULE_FLAG tax_PRI_REC_RATE_DET_RULE_FLAG, tax.EFFECTIVE_TO tax_EFFECTIVE_TO, tax.TAX_STATUS_RULE_FLAG tax_TAX_STATUS_RULE_FLAG, tax.SECONDARY_REC_TYPE_RULE_FLAG tax_SEC_REC_TYPE_RULE_FLAG, tax.MIN_TXBL_BSIS_THRSHLD tax_MIN_TXBL_BSIS_THRSHLD, tax.TAX_ID tax_TAX_ID, tax.ZONE_GEOGRAPHY_TYPE tax_ZONE_GEOGRAPHY_TYPE, tax.HAS_EXCH_RATE_DATE_RULE_FLAG tax_HAS_EXG_RATE_DATE_RULE_FLG, tax.ALLOW_EXEMPTIONS_FLAG tax_ALLOW_EXEMPTIONS_FLAG, tax.WHT_BUCKET_LEVEL_FLAG tax_WHT_BUCKET_LEVEL_FLAG, tax.ATTRIBUTE8 tax_ATTRIBUTE8, tax.ATTRIBUTE14 tax_ATTRIBUTE14, tax.TXBL_BSIS_THRSHLD_FLAG tax_TXBL_BSIS_THRSHLD_FLAG, tax.AUTO_PRVN_FLAG tax_AUTO_PRVN_FLAG, tax.PROGRAM_NAME tax_PROGRAM_NAME, tax.ALLOW_MANUAL_ENTRY_FLAG tax_ALLOW_MANUAL_ENTRY_FLAG, tax.OVERRIDE_GEOGRAPHY_TYPE tax_OVERRIDE_GEOGRAPHY_TYPE, tax.THRSHLD_SCHEDULE_GRP_LVL_FLAG tax_THRSHLD_SCDLE_GRP_LVL_FLG, tax.TAX_RATE_RULE_FLAG tax_TAX_RATE_RULE_FLAG, tax.ALLOW_EXCEPTIONS_FLAG tax_ALLOW_EXCEPTIONS_FLAG, tax.MINIMUM_ACCOUNTABLE_UNIT tax_MINIMUM_ACCOUNTABLE_UNIT, tax.LAST_UPDATED_BY tax_LAST_UPDATED_BY, tax.ALLOW_ROUNDING_OVERRIDE_FLAG tax_ALLOW_RDNG_OVERRIDE_FLAG, tax.PROCESS_WHT_FLAG tax_PROCESS_WHT_FLAG, tax.ALLOW_MASS_CREATE_FLAG tax_ALLOW_MASS_CREATE_FLAG, tax.DIRECT_RATE_RULE_FLAG tax_DIRECT_RATE_RULE_FLAG, tax.MAX_TAX_AMT_THRSHLD tax_MAX_TAX_AMT_THRSHLD, tax.WHT_DATE_BASIS tax_WHT_DATE_BASIS, tax.TAX_POINT_BASIS tax_TAX_POINT_BASIS, tax.TAXABLE_AMT_MAU tax_TAXABLE_AMT_MAU, tax.TAX tax_TAX, tax.ATTRIBUTE3 tax_ATTRIBUTE3, tax.TAX_FULL_NAME tax_TAX_FULL_NAME, tax.USE_LEGAL_MSG_FLAG tax_USE_LEGAL_MSG_FLAG, tax.ROUNDING_RULE_CODE tax_ROUNDING_RULE_CODE, tax.DEF_INCLUSIVE_TAX_FLAG tax_DEF_INCLUSIVE_TAX_FLAG, tax.ALLOW_RECOVERABILITY_FLAG tax_ALLOW_RECOVERABILITY_FLAG, tax.SELF_ASSESS_DIFF_TAX tax_SELF_ASSESS_DIFF_TAX, tax.TAX_EXMPT_CR_METHOD_CODE tax_TAX_EXMPT_CR_METHOD_CODE, tax.THRSHLD_GROUPING_LVL_CODE tax_THRSHLD_GROUPING_LVL_CODE, tax.PROGRAM_LOGIN_ID tax_PROGRAM_LOGIN_ID, tax.UNIQUENESS_VALIDATION_LEVEL tax_UNIQUENESS_VALIDATION_LVL, tax.SPECIAL_INCLUSIVE_TAX_FLAG tax_SPECIAL_INCLUSIVE_TAX_FLAG, tax.MIN_TAX_RATE_THRSHLD tax_MIN_TAX_RATE_THRSHLD, tax.PARENT_GEOGRAPHY_ID tax_PARENT_GEOGRAPHY_ID, tax.EFFECTIVE_FROM tax_EFFECTIVE_FROM, tax.ALLOW_TAX_OVERRIDE_FLAG tax_ALLOW_TAX_OVERRIDE_FLAG, tax.APPLIED_AMT_HANDLING_FLAG tax_APPLIED_AMT_HANDLING_FLAG, tax.TAX_PRECISION tax_TAX_PRECISION, tax.VALIDATION_LEVEL tax_VALIDATION_LEVEL, tax.TAX_CALC_RULE_FLAG tax_TAX_CALC_RULE_FLAG, tax.LIVE_FOR_APPLICABILITY_FLAG tax_LIVE_FOR_APPLICABILITY_FLG, tax.CREATION_DATE tax_CREATION_DATE, tax.APPLICABILITY_RULE_FLAG tax_APPLICABILITY_RULE_FLAG, tax.RECORD_TYPE_CODE tax_RECORD_TYPE_CODE, tax.TAX_INCLUSIVE_OVERRIDE_FLAG tax_TAX_INCLUSIVE_OVERRIDE_FLG, tax.LEGAL_REPORTING_STATUS_DEF_VAL tax_LEGAL_REP_STATUS_DEF_VAL, tax.PRIMARY_RECOVERY_TYPE_CODE tax_PRIMARY_RECOVERY_TYPE_CODE, tax.TAX_ACCOUNT_SOURCE_TAX tax_TAX_ACCOUNT_SOURCE_TAX, tax.OFFSET_TAX_FLAG tax_OFFSET_TAX_FLAG, tax.PROGRAM_APP_NAME tax_PROGRAM_APP_NAME, tax.SEC_REC_RATE_DET_RULE_FLAG tax_SEC_REC_RATE_DET_RULE_FLAG, tax.ATTRIBUTE7 tax_ATTRIBUTE7, tax.DEF_PRIMARY_REC_RATE_CODE tax_DEF_PRIMARY_REC_RATE_CODE, tax.TAX_AUTH_INV_CREATION_POINT tax_TAX_AUTH_INV_CREATION_PNT, tax.SOURCE_TAX_FLAG tax_SOURCE_TAX_FLAG, tax.THRSHLD_CHK_TMPLT_CODE tax_THRSHLD_CHK_TMPLT_CODE, tax.MAX_TXBL_BSIS_THRSHLD tax_MAX_TXBL_BSIS_THRSHLD, tax.DEF_REGISTR_PARTY_TYPE_CODE tax_DEF_REGSTR_PARTY_TYPE_CODE, tax.TAX_AMT_THRSHLD_FLAG tax_TAX_AMT_THRSHLD_FLAG, tax.PRINT_ON_INVOICE_FLAG tax_PRINT_ON_INVOICE_FLAG, tax.MIN_TAX_AMT_THRSHLD tax_MIN_TAX_AMT_THRSHLD, tax.COMPOUNDING_PRECEDENCE tax_COMPOUNDING_PRECEDENCE, tax.WHT_CALC_POINT_FLAG tax_WHT_CALC_POINT_FLAG, tax.ALLOW_DUP_REGN_NUM_FLAG tax_ALLOW_DUP_REGN_NUM_FLAG, tax_auth.TAX_SETTLEMENT_AUTH_ID tax_auth_TAX_STLMT_AUTH_ID, tax_auth.CREATED_BY tax_auth_CREATED_BY, tax_auth.CREATION_DATE tax_auth_CREATION_DATE, tax_auth.LAST_UPDATED_BY tax_auth_LAST_UPDATED_BY, tax_auth.LAST_UPDATE_LOGIN tax_auth_LAST_UPDATE_LOGIN, tax_auth.LAST_UPDATE_DATE tax_auth_LAST_UPDATE_DATE, tax_auth.INTERNAL_ORGANIZATION_ID tax_auth_INTERNAL_ORG_ID, tax_auth.SUPP_SITE_USG_ASSIGNMENT_ID tax_auth_SUPP_SITE_USG_ASMT_ID, tax_auth.EFFECTIVE_END_DATE tax_auth_EFFECTIVE_END_DATE, tax_auth.EFFECTIVE_START_DATE tax_auth_EFFECTIVE_START_DATE, tax_auth.SUPPLIER_ID tax_auth_SUPPLIER_ID, tax_auth.TAX_JURISDICTION_CODE tax_auth_JURISDICTION_CODE from zx_rates_b rate , zx_taxes_vl tax , zx_tax_settlement_auths_f tax_auth where tax.tax_regime_code = rate.tax_regime_code AND tax.tax = rate.tax AND tax.content_owner_id = rate.content_owner_id AND rate.tax = tax_auth.tax AND rate.tax_regime_code = tax_auth.tax_regime_code) tax_data WHERE (nvl(dist.withholding_tax_code_id, -999) = nvl(nvl(tax_data.rate_TAX_RATE_ID(+), tax_data.rate_source_id(+)), -999) AND tax_data.rate_EFFECTIVE_FROM (+) <= dist.accounting_date AND NVL(tax_data.rate_EFFECTIVE_TO (+), dist.accounting_date) >= dist.accounting_date ) AND nvl(tax_data.rate_TAX_JURISDICTION_CODE, 'XXX') = nvl(tax_data.tax_auth_JURISDICTION_CODE, 'XXX') AND tax_data.tax_auth_EFFECTIVE_START_DATE (+) <= dist.accounting_date AND NVL(tax_data.tax_auth_EFFECTIVE_END_DATE (+), dist.accounting_date) >= dist.accounting_date AND tax_data.tax_auth_INTERNAL_ORG_ID (+) = dist.org_id