VIEW: APPS.ZX_DETAIL_TAX_LINES_QUOTE_V

Source

View Text - Preformatted

(
 SELECT "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_ID","TAX","TAX_STATUS_ID","TAX_STATUS_CODE","TAX_RATE_ID","TAX_RATE_CODE","TAX_RATE","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","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","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_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_NUMBER","RELATED_DOC_DATE","APPLIED_FROM_APPLICATION_ID","APPLIED_FROM_EVENT_CLASS_CODE","APPLIED_FROM_ENTITY_CODE","APPLIED_FROM_TRX_ID","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_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_LINE_ID","SUMMARY_TAX_LINE_ID","OFFSET_LINK_TO_TAX_LINE_ID","OFFSET_FLAG","PROCESS_FOR_RECOVERY_FLAG","TAX_JURISDICTION_ID","TAX_JURISDICTION_CODE","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","LAST_MANUAL_ENTRY","TAX_PROVIDER_ID","RECORD_TYPE_CODE","REPORTING_PERIOD_ID","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","INTERNAL_ORG_LOCATION_ID","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","CREATED_BY","CREATION_DATE","LAST_UPDATED_BY","LAST_UPDATE_DATE","LAST_UPDATE_LOGIN","LEGAL_JUSTIFICATION_TEXT1","LEGAL_JUSTIFICATION_TEXT2","LEGAL_JUSTIFICATION_TEXT3","REPORTING_CURRENCY_CODE","LINE_ASSESSABLE_VALUE","TRX_LINE_INDEX","OFFSET_TAX_RATE_CODE","PRORATION_CODE","OTHER_DOC_SOURCE","CTRL_TOTAL_LINE_TX_AMT","TAX_RATE_TYPE","COMPOUNDING_TAX_MISS_FLAG","MRC_LINK_TO_TAX_LINE_ID","REF_DOC_TRX_LEVEL_TYPE","RELATED_DOC_TRX_LEVEL_TYPE","APPLIED_FROM_TRX_LEVEL_TYPE","ADJUSTED_DOC_TRX_LEVEL_TYPE","APPLIED_TO_TRX_LEVEL_TYPE","SYNC_WITH_PRVDR_FLAG","APPLIED_TO_TRX_NUMBER","INTERFACE_ENTITY_CODE","INTERFACE_TAX_LINE_ID","TAXING_JURIS_GEOGRAPHY_ID","ADJUSTED_DOC_TAX_LINE_ID","OBJECT_VERSION_NUMBER" FROM ZX_DETAIL_TAX_LINES_GT ZxLinesGt
 UNION
 SELECT "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_ID","TAX","TAX_STATUS_ID","TAX_STATUS_CODE","TAX_RATE_ID","TAX_RATE_CODE","TAX_RATE","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","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","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_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_NUMBER","RELATED_DOC_DATE","APPLIED_FROM_APPLICATION_ID","APPLIED_FROM_EVENT_CLASS_CODE","APPLIED_FROM_ENTITY_CODE","APPLIED_FROM_TRX_ID","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_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_LINE_ID","SUMMARY_TAX_LINE_ID","OFFSET_LINK_TO_TAX_LINE_ID","OFFSET_FLAG","PROCESS_FOR_RECOVERY_FLAG","TAX_JURISDICTION_ID","TAX_JURISDICTION_CODE","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","LAST_MANUAL_ENTRY","TAX_PROVIDER_ID","RECORD_TYPE_CODE","REPORTING_PERIOD_ID","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","INTERNAL_ORG_LOCATION_ID","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","CREATED_BY","CREATION_DATE","LAST_UPDATED_BY","LAST_UPDATE_DATE","LAST_UPDATE_LOGIN","LEGAL_JUSTIFICATION_TEXT1","LEGAL_JUSTIFICATION_TEXT2","LEGAL_JUSTIFICATION_TEXT3","REPORTING_CURRENCY_CODE","LINE_ASSESSABLE_VALUE","TRX_LINE_INDEX","OFFSET_TAX_RATE_CODE","PRORATION_CODE","OTHER_DOC_SOURCE","CTRL_TOTAL_LINE_TX_AMT","TAX_RATE_TYPE","COMPOUNDING_TAX_MISS_FLAG","MRC_LINK_TO_TAX_LINE_ID","REF_DOC_TRX_LEVEL_TYPE","RELATED_DOC_TRX_LEVEL_TYPE","APPLIED_FROM_TRX_LEVEL_TYPE","ADJUSTED_DOC_TRX_LEVEL_TYPE","APPLIED_TO_TRX_LEVEL_TYPE","SYNC_WITH_PRVDR_FLAG","APPLIED_TO_TRX_NUMBER","INTERFACE_ENTITY_CODE","INTERFACE_TAX_LINE_ID","TAXING_JURIS_GEOGRAPHY_ID","ADJUSTED_DOC_TAX_LINE_ID","OBJECT_VERSION_NUMBER" FROM ZX_LINES ZxLines
 WHERE
 (TRX_LINE_ID,TRX_LEVEL_TYPE) NOT IN
  (SELECT ZxLinesDetFactors.TRX_LINE_ID,ZxLinesDetFactors.TRX_LEVEL_TYPE
   FROM
 ZX_LINES_DET_FACTORS ZxLinesDetFactors
   WHERE
 ZxLinesDetFactors.APPLICATION_ID = ZxLines.APPLICATION_ID and
 ZxLinesDetFactors.ENTITY_CODE = ZxLines.ENTITY_CODE and
 ZxLinesDetFactors.EVENT_CLASS_CODE = ZxLines.EVENT_CLASS_CODE and
 ZxLinesDetFactors.TRX_ID = ZxLines.TRX_ID
 )
    )

   

View Text - HTML Formatted

( SELECT "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_ID"
, "TAX"
, "TAX_STATUS_ID"
, "TAX_STATUS_CODE"
, "TAX_RATE_ID"
, "TAX_RATE_CODE"
, "TAX_RATE"
, "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"
, "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"
, "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_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_NUMBER"
, "RELATED_DOC_DATE"
, "APPLIED_FROM_APPLICATION_ID"
, "APPLIED_FROM_EVENT_CLASS_CODE"
, "APPLIED_FROM_ENTITY_CODE"
, "APPLIED_FROM_TRX_ID"
, "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_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_LINE_ID"
, "SUMMARY_TAX_LINE_ID"
, "OFFSET_LINK_TO_TAX_LINE_ID"
, "OFFSET_FLAG"
, "PROCESS_FOR_RECOVERY_FLAG"
, "TAX_JURISDICTION_ID"
, "TAX_JURISDICTION_CODE"
, "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"
, "LAST_MANUAL_ENTRY"
, "TAX_PROVIDER_ID"
, "RECORD_TYPE_CODE"
, "REPORTING_PERIOD_ID"
, "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"
, "INTERNAL_ORG_LOCATION_ID"
, "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"
, "CREATED_BY"
, "CREATION_DATE"
, "LAST_UPDATED_BY"
, "LAST_UPDATE_DATE"
, "LAST_UPDATE_LOGIN"
, "LEGAL_JUSTIFICATION_TEXT1"
, "LEGAL_JUSTIFICATION_TEXT2"
, "LEGAL_JUSTIFICATION_TEXT3"
, "REPORTING_CURRENCY_CODE"
, "LINE_ASSESSABLE_VALUE"
, "TRX_LINE_INDEX"
, "OFFSET_TAX_RATE_CODE"
, "PRORATION_CODE"
, "OTHER_DOC_SOURCE"
, "CTRL_TOTAL_LINE_TX_AMT"
, "TAX_RATE_TYPE"
, "COMPOUNDING_TAX_MISS_FLAG"
, "MRC_LINK_TO_TAX_LINE_ID"
, "REF_DOC_TRX_LEVEL_TYPE"
, "RELATED_DOC_TRX_LEVEL_TYPE"
, "APPLIED_FROM_TRX_LEVEL_TYPE"
, "ADJUSTED_DOC_TRX_LEVEL_TYPE"
, "APPLIED_TO_TRX_LEVEL_TYPE"
, "SYNC_WITH_PRVDR_FLAG"
, "APPLIED_TO_TRX_NUMBER"
, "INTERFACE_ENTITY_CODE"
, "INTERFACE_TAX_LINE_ID"
, "TAXING_JURIS_GEOGRAPHY_ID"
, "ADJUSTED_DOC_TAX_LINE_ID"
, "OBJECT_VERSION_NUMBER"
FROM ZX_DETAIL_TAX_LINES_GT ZXLINESGT UNION SELECT "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_ID"
, "TAX"
, "TAX_STATUS_ID"
, "TAX_STATUS_CODE"
, "TAX_RATE_ID"
, "TAX_RATE_CODE"
, "TAX_RATE"
, "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"
, "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"
, "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_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_NUMBER"
, "RELATED_DOC_DATE"
, "APPLIED_FROM_APPLICATION_ID"
, "APPLIED_FROM_EVENT_CLASS_CODE"
, "APPLIED_FROM_ENTITY_CODE"
, "APPLIED_FROM_TRX_ID"
, "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_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_LINE_ID"
, "SUMMARY_TAX_LINE_ID"
, "OFFSET_LINK_TO_TAX_LINE_ID"
, "OFFSET_FLAG"
, "PROCESS_FOR_RECOVERY_FLAG"
, "TAX_JURISDICTION_ID"
, "TAX_JURISDICTION_CODE"
, "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"
, "LAST_MANUAL_ENTRY"
, "TAX_PROVIDER_ID"
, "RECORD_TYPE_CODE"
, "REPORTING_PERIOD_ID"
, "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"
, "INTERNAL_ORG_LOCATION_ID"
, "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"
, "CREATED_BY"
, "CREATION_DATE"
, "LAST_UPDATED_BY"
, "LAST_UPDATE_DATE"
, "LAST_UPDATE_LOGIN"
, "LEGAL_JUSTIFICATION_TEXT1"
, "LEGAL_JUSTIFICATION_TEXT2"
, "LEGAL_JUSTIFICATION_TEXT3"
, "REPORTING_CURRENCY_CODE"
, "LINE_ASSESSABLE_VALUE"
, "TRX_LINE_INDEX"
, "OFFSET_TAX_RATE_CODE"
, "PRORATION_CODE"
, "OTHER_DOC_SOURCE"
, "CTRL_TOTAL_LINE_TX_AMT"
, "TAX_RATE_TYPE"
, "COMPOUNDING_TAX_MISS_FLAG"
, "MRC_LINK_TO_TAX_LINE_ID"
, "REF_DOC_TRX_LEVEL_TYPE"
, "RELATED_DOC_TRX_LEVEL_TYPE"
, "APPLIED_FROM_TRX_LEVEL_TYPE"
, "ADJUSTED_DOC_TRX_LEVEL_TYPE"
, "APPLIED_TO_TRX_LEVEL_TYPE"
, "SYNC_WITH_PRVDR_FLAG"
, "APPLIED_TO_TRX_NUMBER"
, "INTERFACE_ENTITY_CODE"
, "INTERFACE_TAX_LINE_ID"
, "TAXING_JURIS_GEOGRAPHY_ID"
, "ADJUSTED_DOC_TAX_LINE_ID"
, "OBJECT_VERSION_NUMBER"
FROM ZX_LINES ZXLINES WHERE (TRX_LINE_ID
, TRX_LEVEL_TYPE) NOT IN (SELECT ZXLINESDETFACTORS.TRX_LINE_ID
, ZXLINESDETFACTORS.TRX_LEVEL_TYPE FROM ZX_LINES_DET_FACTORS ZXLINESDETFACTORS WHERE ZXLINESDETFACTORS.APPLICATION_ID = ZXLINES.APPLICATION_ID AND ZXLINESDETFACTORS.ENTITY_CODE = ZXLINES.ENTITY_CODE AND ZXLINESDETFACTORS.EVENT_CLASS_CODE = ZXLINES.EVENT_CLASS_CODE AND ZXLINESDETFACTORS.TRX_ID = ZXLINES.TRX_ID ) )