ZX_DETAIL_TAX_LINES_GT_V

Details

• Schema: FUSION

• Object owner: FND

• Object type: VIEW

Columns

Name

ROW_ID TAX_LINE_ID INTERNAL_ORGANIZATION_ID APPLICATION_ID ENTITY_CODE EVENT_CLASS_CODE EVENT_TYPE_CODE TRX_ID TRX_LINE_ID TRX_LEVEL_TYPE TRX_LINE_NUMBER DOC_EVENT_STATUS TAX_EVENT_CLASS_CODE TAX_EVENT_TYPE_CODE TAX_LINE_NUMBER CONTENT_OWNER_ID TAX_REGIME_ID TAX_REGIME_CODE TAX_REGIME_NAME TAX_ID TAX TAX_FULL_NAME TAX_STATUS_ID TAX_STATUS_CODE TAX_STATUS_NAME TAX_RATE_ID TAX_RATE_CODE TAX_RATE_NAME TAX_RATE TAX_RATE_TYPE TAX_APPORTIONMENT_LINE_NUMBER TRX_ID_LEVEL2 TRX_ID_LEVEL3 TRX_ID_LEVEL4 TRX_ID_LEVEL5 TRX_ID_LEVEL6 TRX_USER_KEY_LEVEL1 TRX_USER_KEY_LEVEL2 TRX_USER_KEY_LEVEL3 TRX_USER_KEY_LEVEL4 TRX_USER_KEY_LEVEL5 TRX_USER_KEY_LEVEL6 MRC_TAX_LINE_FLAG MRC_LINK_TO_TAX_LINE_ID LEDGER_ID ESTABLISHMENT_ID LEGAL_ENTITY_ID LEGAL_ENTITY_TAX_REG_NUMBER HQ_ESTB_REG_NUMBER HQ_ESTB_PARTY_TAX_PROF_ID CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_RATE TAX_CURRENCY_CONVERSION_DATE TAX_CURRENCY_CONVERSION_TYPE TAX_CURRENCY_CONVERSION_RATE TRX_CURRENCY_CODE REPORTING_CURRENCY_CODE MINIMUM_ACCOUNTABLE_UNIT PRECISION TRX_NUMBER TRX_DATE UNIT_PRICE LINE_AMT TRX_LINE_QUANTITY TAX_BASE_MODIFIER_RATE REF_DOC_APPLICATION_ID REF_DOC_ENTITY_CODE REF_DOC_EVENT_CLASS_CODE REF_DOC_TRX_ID REF_DOC_TRX_LEVEL_TYPE REF_DOC_LINE_ID REF_DOC_LINE_QUANTITY OTHER_DOC_LINE_AMT OTHER_DOC_LINE_TAX_AMT OTHER_DOC_LINE_TAXABLE_AMT UNROUNDED_TAXABLE_AMT UNROUNDED_TAX_AMT RELATED_DOC_APPLICATION_ID RELATED_DOC_ENTITY_CODE RELATED_DOC_EVENT_CLASS_CODE RELATED_DOC_TRX_ID RELATED_DOC_TRX_LEVEL_TYPE RELATED_DOC_NUMBER RELATED_DOC_DATE 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 APPLIED_FROM_TRX_NUMBER ADJUSTED_DOC_APPLICATION_ID ADJUSTED_DOC_ENTITY_CODE ADJUSTED_DOC_EVENT_CLASS_CODE ADJUSTED_DOC_TRX_ID ADJUSTED_DOC_TRX_LEVEL_TYPE ADJUSTED_DOC_LINE_ID ADJUSTED_DOC_NUMBER ADJUSTED_DOC_DATE 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 SUMMARY_TAX_LINE_ID OFFSET_LINK_TO_TAX_LINE_ID OFFSET_FLAG PROCESS_FOR_RECOVERY_FLAG TAX_JURISDICTION_ID TAX_JURISDICTION_CODE TAX_JURISDICTION_NAME PLACE_OF_SUPPLY PLACE_OF_SUPPLY_TYPE_CODE PLACE_OF_SUPPLY_RESULT_ID TAX_DATE_RULE_ID TAX_DATE TAX_DETERMINE_DATE TAX_POINT_DATE TRX_LINE_DATE TAX_TYPE_CODE TAX_CODE TAX_REGISTRATION_ID TAX_REGISTRATION_NUMBER REGISTRATION_PARTY_TYPE ROUNDING_LEVEL_CODE ROUNDING_RULE_CODE ROUNDING_LVL_PARTY_TAX_PROF_ID ROUNDING_LVL_PARTY_TYPE COMPOUNDING_TAX_FLAG ORIG_TAX_STATUS_ID ORIG_TAX_STATUS_CODE ORIG_TAX_RATE_ID ORIG_TAX_RATE_CODE ORIG_TAX_RATE ORIG_TAX_JURISDICTION_ID ORIG_TAX_JURISDICTION_CODE ORIG_TAX_AMT_INCLUDED_FLAG ORIG_SELF_ASSESSED_FLAG TAX_CURRENCY_CODE TAX_AMT TAX_AMT_TAX_CURR TAX_AMT_FUNCL_CURR TAXABLE_AMT TAXABLE_AMT_TAX_CURR TAXABLE_AMT_FUNCL_CURR ORIG_TAXABLE_AMT ORIG_TAXABLE_AMT_TAX_CURR CAL_TAX_AMT CAL_TAX_AMT_TAX_CURR CAL_TAX_AMT_FUNCL_CURR ORIG_TAX_AMT ORIG_TAX_AMT_TAX_CURR REC_TAX_AMT REC_TAX_AMT_TAX_CURR REC_TAX_AMT_FUNCL_CURR NREC_TAX_AMT NREC_TAX_AMT_TAX_CURR NREC_TAX_AMT_FUNCL_CURR TAX_EXEMPTION_ID TAX_RATE_BEFORE_EXEMPTION TAX_RATE_NAME_BEFORE_EXEMPTION EXEMPT_RATE_MODIFIER EXEMPT_CERTIFICATE_NUMBER EXEMPT_REASON EXEMPT_REASON_CODE TAX_EXCEPTION_ID TAX_RATE_BEFORE_EXCEPTION TAX_RATE_NAME_BEFORE_EXCEPTION EXCEPTION_RATE TAX_APPORTIONMENT_FLAG HISTORICAL_FLAG TAXABLE_BASIS_FORMULA TAX_CALCULATION_FORMULA CANCEL_FLAG PURGE_FLAG DELETE_FLAG TAX_AMT_INCLUDED_FLAG SELF_ASSESSED_FLAG OVERRIDDEN_FLAG MANUALLY_ENTERED_FLAG REPORTING_ONLY_FLAG FREEZE_UNTIL_OVERRIDDEN_FLAG COPIED_FROM_OTHER_DOC_FLAG RECALC_REQUIRED_FLAG SETTLEMENT_FLAG ITEM_DIST_CHANGED_FLAG ASSOCIATED_CHILD_FROZEN_FLAG TAX_ONLY_LINE_FLAG COMPOUNDING_DEP_TAX_FLAG COMPOUNDING_TAX_MISS_FLAG SYNC_WITH_PRVDR_FLAG LAST_MANUAL_ENTRY TAX_PROVIDER_ID RECORD_TYPE_CODE REPORTING_PERIOD_ID LEGAL_JUSTIFICATION_TEXT1 LEGAL_JUSTIFICATION_TEXT2 LEGAL_JUSTIFICATION_TEXT3 LEGAL_MESSAGE_APPL_2 LEGAL_MESSAGE_STATUS LEGAL_MESSAGE_RATE LEGAL_MESSAGE_BASIS LEGAL_MESSAGE_CALC LEGAL_MESSAGE_THRESHOLD LEGAL_MESSAGE_POS LEGAL_MESSAGE_TRN LEGAL_MESSAGE_EXMPT LEGAL_MESSAGE_EXCPT TAX_REGIME_TEMPLATE_ID TAX_APPLICABILITY_RESULT_ID DIRECT_RATE_RESULT_ID STATUS_RESULT_ID RATE_RESULT_ID BASIS_RESULT_ID THRESH_RESULT_ID CALC_RESULT_ID TAX_REG_NUM_DET_RESULT_ID EVAL_EXMPT_RESULT_ID EVAL_EXCPT_RESULT_ID ENFORCE_FROM_NATURAL_ACCT_FLAG TAX_HOLD_CODE TAX_HOLD_RELEASED_CODE PRD_TOTAL_TAX_AMT PRD_TOTAL_TAX_AMT_TAX_CURR PRD_TOTAL_TAX_AMT_FUNCL_CURR TRX_LINE_INDEX OFFSET_TAX_RATE_CODE PRORATION_CODE OTHER_DOC_SOURCE INTERNAL_ORG_LOCATION_ID LINE_ASSESSABLE_VALUE CTRL_TOTAL_LINE_TX_AMT 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 NUMERIC1 NUMERIC2 NUMERIC3 NUMERIC4 NUMERIC5 NUMERIC6 NUMERIC7 NUMERIC8 NUMERIC9 NUMERIC10 CHAR1 CHAR2 CHAR3 CHAR4 CHAR5 CHAR6 CHAR7 CHAR8 CHAR9 CHAR10 DATE1 DATE2 DATE3 DATE4 DATE5 DATE6 DATE7 DATE8 DATE9 DATE10 APPLIED_TO_TRX_NUMBER INTERFACE_ENTITY_CODE INTERFACE_TAX_LINE_ID TAXING_JURIS_GEOGRAPHY_ID ADJUSTED_DOC_TAX_LINE_ID OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN TAX_POINT_BASIS ORIG_TAX_POINT_DATE REPORTABLE_FLAG PAYMENT_DATE INDIRECT_TAX_LINE_ID WHT_REGION WHT_REPORT_BOX PAYMENT_ID PAYMENT_AMT DISCOUNT_AMT CHECKRUN_ID CASH_DISCOUNT_APPLICABLE_FLAG LINE_GROUP_ID ACCUM_TAX_AMT_TAX_CURR ACCUM_TXBL_AMT_TAX_CURR ORIG_ACCUM_TAX_AMT_TAX_CURR ORIG_ACCUM_TXBL_AMT_TAX_CURR GROSS_NET_FLAG

Query

SQL_Statement

SELECT GT.ROWID ROW_ID, GT.TAX_LINE_ID, GT.INTERNAL_ORGANIZATION_ID, GT.APPLICATION_ID, GT.ENTITY_CODE, GT.EVENT_CLASS_CODE, GT.EVENT_TYPE_CODE, GT.TRX_ID, GT.TRX_LINE_ID, GT.TRX_LEVEL_TYPE, GT.TRX_LINE_NUMBER, GT.DOC_EVENT_STATUS, GT.TAX_EVENT_CLASS_CODE, GT.TAX_EVENT_TYPE_CODE, GT.TAX_LINE_NUMBER, GT.CONTENT_OWNER_ID, GT.TAX_REGIME_ID, GT.TAX_REGIME_CODE, TR.TAX_REGIME_NAME TAX_REGIME_NAME, GT.TAX_ID, GT.TAX, TX.TAX_FULL_NAME, GT.TAX_STATUS_ID, GT.TAX_STATUS_CODE, TS.TAX_STATUS_NAME, GT.TAX_RATE_ID, GT.TAX_RATE_CODE, TRT.TAX_RATE_NAME, GT.TAX_RATE, GT.TAX_RATE_TYPE, GT.TAX_APPORTIONMENT_LINE_NUMBER, GT.TRX_ID_LEVEL2, GT.TRX_ID_LEVEL3, GT.TRX_ID_LEVEL4, GT.TRX_ID_LEVEL5, GT.TRX_ID_LEVEL6, GT.TRX_USER_KEY_LEVEL1, GT.TRX_USER_KEY_LEVEL2, GT.TRX_USER_KEY_LEVEL3, GT.TRX_USER_KEY_LEVEL4, GT.TRX_USER_KEY_LEVEL5, GT.TRX_USER_KEY_LEVEL6, GT.MRC_TAX_LINE_FLAG, GT.MRC_LINK_TO_TAX_LINE_ID, GT.LEDGER_ID, GT.ESTABLISHMENT_ID, GT.LEGAL_ENTITY_ID, GT.LEGAL_ENTITY_TAX_REG_NUMBER, GT.HQ_ESTB_REG_NUMBER, GT.HQ_ESTB_PARTY_TAX_PROF_ID, GT.CURRENCY_CONVERSION_DATE, GT.CURRENCY_CONVERSION_TYPE, GT.CURRENCY_CONVERSION_RATE, GT.TAX_CURRENCY_CONVERSION_DATE, GT.TAX_CURRENCY_CONVERSION_TYPE, GT.TAX_CURRENCY_CONVERSION_RATE, GT.TRX_CURRENCY_CODE, GT.REPORTING_CURRENCY_CODE, GT.MINIMUM_ACCOUNTABLE_UNIT, GT.PRECISION, GT.TRX_NUMBER, GT.TRX_DATE, GT.UNIT_PRICE, GT.LINE_AMT, GT.TRX_LINE_QUANTITY, GT.TAX_BASE_MODIFIER_RATE, GT.REF_DOC_APPLICATION_ID, GT.REF_DOC_ENTITY_CODE, GT.REF_DOC_EVENT_CLASS_CODE, GT.REF_DOC_TRX_ID, GT.REF_DOC_TRX_LEVEL_TYPE, GT.REF_DOC_LINE_ID, GT.REF_DOC_LINE_QUANTITY, GT.OTHER_DOC_LINE_AMT, GT.OTHER_DOC_LINE_TAX_AMT, GT.OTHER_DOC_LINE_TAXABLE_AMT, GT.UNROUNDED_TAXABLE_AMT, GT.UNROUNDED_TAX_AMT, GT.RELATED_DOC_APPLICATION_ID, GT.RELATED_DOC_ENTITY_CODE, GT.RELATED_DOC_EVENT_CLASS_CODE, GT.RELATED_DOC_TRX_ID, GT.RELATED_DOC_TRX_LEVEL_TYPE, GT.RELATED_DOC_NUMBER, GT.RELATED_DOC_DATE, GT.APPLIED_FROM_APPLICATION_ID, GT.APPLIED_FROM_EVENT_CLASS_CODE, GT.APPLIED_FROM_ENTITY_CODE, GT.APPLIED_FROM_TRX_ID, GT.APPLIED_FROM_TRX_LEVEL_TYPE, GT.APPLIED_FROM_LINE_ID, GT.APPLIED_FROM_TRX_NUMBER, GT.ADJUSTED_DOC_APPLICATION_ID, GT.ADJUSTED_DOC_ENTITY_CODE, GT.ADJUSTED_DOC_EVENT_CLASS_CODE, GT.ADJUSTED_DOC_TRX_ID, GT.ADJUSTED_DOC_TRX_LEVEL_TYPE, GT.ADJUSTED_DOC_LINE_ID, GT.ADJUSTED_DOC_NUMBER, GT.ADJUSTED_DOC_DATE, GT.APPLIED_TO_APPLICATION_ID, GT.APPLIED_TO_EVENT_CLASS_CODE, GT.APPLIED_TO_ENTITY_CODE, GT.APPLIED_TO_TRX_ID, GT.APPLIED_TO_TRX_LEVEL_TYPE, GT.APPLIED_TO_LINE_ID, GT.SUMMARY_TAX_LINE_ID, GT.OFFSET_LINK_TO_TAX_LINE_ID, GT.OFFSET_FLAG, GT.PROCESS_FOR_RECOVERY_FLAG, GT.TAX_JURISDICTION_ID, GT.TAX_JURISDICTION_CODE, TJ.TAX_JURISDICTION_NAME, GT.PLACE_OF_SUPPLY, GT.PLACE_OF_SUPPLY_TYPE_CODE, GT.PLACE_OF_SUPPLY_RESULT_ID, GT.TAX_DATE_RULE_ID, GT.TAX_DATE, GT.TAX_DETERMINE_DATE, GT.TAX_POINT_DATE, GT.TRX_LINE_DATE, GT.TAX_TYPE_CODE, GT.TAX_CODE, GT.TAX_REGISTRATION_ID, GT.TAX_REGISTRATION_NUMBER, GT.REGISTRATION_PARTY_TYPE, GT.ROUNDING_LEVEL_CODE, GT.ROUNDING_RULE_CODE, GT.ROUNDING_LVL_PARTY_TAX_PROF_ID, GT.ROUNDING_LVL_PARTY_TYPE, GT.COMPOUNDING_TAX_FLAG, GT.ORIG_TAX_STATUS_ID, GT.ORIG_TAX_STATUS_CODE, GT.ORIG_TAX_RATE_ID, GT.ORIG_TAX_RATE_CODE, GT.ORIG_TAX_RATE, GT.ORIG_TAX_JURISDICTION_ID, GT.ORIG_TAX_JURISDICTION_CODE, GT.ORIG_TAX_AMT_INCLUDED_FLAG, GT.ORIG_SELF_ASSESSED_FLAG, GT.TAX_CURRENCY_CODE, GT.TAX_AMT, GT.TAX_AMT_TAX_CURR, GT.TAX_AMT_FUNCL_CURR, GT.TAXABLE_AMT, GT.TAXABLE_AMT_TAX_CURR, GT.TAXABLE_AMT_FUNCL_CURR, GT.ORIG_TAXABLE_AMT, GT.ORIG_TAXABLE_AMT_TAX_CURR, GT.CAL_TAX_AMT, GT.CAL_TAX_AMT_TAX_CURR, GT.CAL_TAX_AMT_FUNCL_CURR, GT.ORIG_TAX_AMT, GT.ORIG_TAX_AMT_TAX_CURR, GT.REC_TAX_AMT, GT.REC_TAX_AMT_TAX_CURR, GT.REC_TAX_AMT_FUNCL_CURR, GT.NREC_TAX_AMT, GT.NREC_TAX_AMT_TAX_CURR, GT.NREC_TAX_AMT_FUNCL_CURR, GT.TAX_EXEMPTION_ID, GT.TAX_RATE_BEFORE_EXEMPTION, GT.TAX_RATE_NAME_BEFORE_EXEMPTION, GT.EXEMPT_RATE_MODIFIER, GT.EXEMPT_CERTIFICATE_NUMBER, GT.EXEMPT_REASON, GT.EXEMPT_REASON_CODE, GT.TAX_EXCEPTION_ID, GT.TAX_RATE_BEFORE_EXCEPTION, GT.TAX_RATE_NAME_BEFORE_EXCEPTION, GT.EXCEPTION_RATE, GT.TAX_APPORTIONMENT_FLAG, GT.HISTORICAL_FLAG, GT.TAXABLE_BASIS_FORMULA, GT.TAX_CALCULATION_FORMULA, GT.CANCEL_FLAG, GT.PURGE_FLAG, GT.DELETE_FLAG, GT.TAX_AMT_INCLUDED_FLAG, GT.SELF_ASSESSED_FLAG, GT.OVERRIDDEN_FLAG, GT.MANUALLY_ENTERED_FLAG, GT.REPORTING_ONLY_FLAG, GT.FREEZE_UNTIL_OVERRIDDEN_FLAG, GT.COPIED_FROM_OTHER_DOC_FLAG, GT.RECALC_REQUIRED_FLAG, GT.SETTLEMENT_FLAG, GT.ITEM_DIST_CHANGED_FLAG, GT.ASSOCIATED_CHILD_FROZEN_FLAG, GT.TAX_ONLY_LINE_FLAG, GT.COMPOUNDING_DEP_TAX_FLAG, GT.COMPOUNDING_TAX_MISS_FLAG, GT.SYNC_WITH_PRVDR_FLAG, GT.LAST_MANUAL_ENTRY, GT.TAX_PROVIDER_ID, GT.RECORD_TYPE_CODE, GT.REPORTING_PERIOD_ID, GT.LEGAL_JUSTIFICATION_TEXT1, GT.LEGAL_JUSTIFICATION_TEXT2, GT.LEGAL_JUSTIFICATION_TEXT3, GT.LEGAL_MESSAGE_APPL_2, GT.LEGAL_MESSAGE_STATUS, GT.LEGAL_MESSAGE_RATE, GT.LEGAL_MESSAGE_BASIS, GT.LEGAL_MESSAGE_CALC, GT.LEGAL_MESSAGE_THRESHOLD, GT.LEGAL_MESSAGE_POS, GT.LEGAL_MESSAGE_TRN, GT.LEGAL_MESSAGE_EXMPT, GT.LEGAL_MESSAGE_EXCPT, GT.TAX_REGIME_TEMPLATE_ID, GT.TAX_APPLICABILITY_RESULT_ID, GT.DIRECT_RATE_RESULT_ID, GT.STATUS_RESULT_ID, GT.RATE_RESULT_ID, GT.BASIS_RESULT_ID, GT.THRESH_RESULT_ID, GT.CALC_RESULT_ID, GT.TAX_REG_NUM_DET_RESULT_ID, GT.EVAL_EXMPT_RESULT_ID, GT.EVAL_EXCPT_RESULT_ID, GT.ENFORCE_FROM_NATURAL_ACCT_FLAG, GT.TAX_HOLD_CODE, GT.TAX_HOLD_RELEASED_CODE, GT.PRD_TOTAL_TAX_AMT, GT.PRD_TOTAL_TAX_AMT_TAX_CURR, GT.PRD_TOTAL_TAX_AMT_FUNCL_CURR, GT.TRX_LINE_INDEX, GT.OFFSET_TAX_RATE_CODE, GT.PRORATION_CODE, GT.OTHER_DOC_SOURCE, GT.INTERNAL_ORG_LOCATION_ID, GT.LINE_ASSESSABLE_VALUE, GT.CTRL_TOTAL_LINE_TX_AMT, GT.ATTRIBUTE_CATEGORY, GT.ATTRIBUTE1, GT.ATTRIBUTE2, GT.ATTRIBUTE3, GT.ATTRIBUTE4, GT.ATTRIBUTE5, GT.ATTRIBUTE6, GT.ATTRIBUTE7, GT.ATTRIBUTE8, GT.ATTRIBUTE9, GT.ATTRIBUTE10, GT.ATTRIBUTE11, GT.ATTRIBUTE12, GT.ATTRIBUTE13, GT.ATTRIBUTE14, GT.ATTRIBUTE15, GT.GLOBAL_ATTRIBUTE_CATEGORY, GT.GLOBAL_ATTRIBUTE1, GT.GLOBAL_ATTRIBUTE2, GT.GLOBAL_ATTRIBUTE3, GT.GLOBAL_ATTRIBUTE4, GT.GLOBAL_ATTRIBUTE5, GT.GLOBAL_ATTRIBUTE6, GT.GLOBAL_ATTRIBUTE7, GT.GLOBAL_ATTRIBUTE8, GT.GLOBAL_ATTRIBUTE9, GT.GLOBAL_ATTRIBUTE10, GT.GLOBAL_ATTRIBUTE11, GT.GLOBAL_ATTRIBUTE12, GT.GLOBAL_ATTRIBUTE13, GT.GLOBAL_ATTRIBUTE14, GT.GLOBAL_ATTRIBUTE15, GT.NUMERIC1, GT.NUMERIC2, GT.NUMERIC3, GT.NUMERIC4, GT.NUMERIC5, GT.NUMERIC6, GT.NUMERIC7, GT.NUMERIC8, GT.NUMERIC9, GT.NUMERIC10, GT.CHAR1, GT.CHAR2, GT.CHAR3, GT.CHAR4, GT.CHAR5, GT.CHAR6, GT.CHAR7, GT.CHAR8, GT.CHAR9, GT.CHAR10, GT.DATE1, GT.DATE2, GT.DATE3, GT.DATE4, GT.DATE5, GT.DATE6, GT.DATE7, GT.DATE8, GT.DATE9, GT.DATE10, GT.APPLIED_TO_TRX_NUMBER, GT.INTERFACE_ENTITY_CODE, GT.INTERFACE_TAX_LINE_ID, GT.TAXING_JURIS_GEOGRAPHY_ID, GT.ADJUSTED_DOC_TAX_LINE_ID, GT.OBJECT_VERSION_NUMBER, GT.CREATED_BY, GT.CREATION_DATE, GT.LAST_UPDATED_BY, GT.LAST_UPDATE_DATE, GT.LAST_UPDATE_LOGIN, GT.TAX_POINT_BASIS, GT.ORIG_TAX_POINT_DATE, GT.REPORTABLE_FLAG, GT.PAYMENT_DATE, GT.INDIRECT_TAX_LINE_ID, GT.WHT_REGION, GT.WHT_REPORT_BOX, GT.PAYMENT_ID, GT.PAYMENT_AMT, GT.DISCOUNT_AMT, GT.CHECKRUN_ID, GT.CASH_DISCOUNT_APPLICABLE_FLAG, GT.LINE_GROUP_ID, GT.ACCUM_TAX_AMT_TAX_CURR, GT.ACCUM_TXBL_AMT_TAX_CURR, GT.ORIG_ACCUM_TAX_AMT_TAX_CURR, GT.ORIG_ACCUM_TXBL_AMT_TAX_CURR, GT.GROSS_NET_FLAG FROM ZX_DETAIL_TAX_LINES_GT GT, ZX_REGIMES_TL TR, ZX_JURISDICTIONS_TL TJ, ZX_TAXES_TL TX, ZX_RATES_TL TRT, ZX_STATUS_TL TS WHERE GT.TAX_REGIME_ID = TR.TAX_REGIME_ID(+) AND GT.TAX_JURISDICTION_ID = TJ.TAX_JURISDICTION_ID(+) AND GT.TAX_ID = TX.TAX_ID(+) AND GT.TAX_STATUS_ID = TS.TAX_STATUS_ID(+) AND GT.TAX_RATE_ID = TRT.TAX_RATE_ID(+) AND TR.LANGUAGE = userenv('LANG') AND TJ.LANGUAGE = userenv('LANG') AND TX.LANGUAGE = userenv('LANG') AND TRT.LANGUAGE = userenv('LANG') AND TS.LANGUAGE = userenv('LANG')