View: ZX_LINES_V

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

View Text

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