View: ZX_DETAIL_TAX_LINES_QUOTE_V

Product:	FND - Application Object Library
Description:
Implementation/DBA Data:	APPS.ZX_DETAIL_TAX_LINES_QUOTE_V

View Text

( 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 ) )