eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.ZX_LINES_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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