[Home] [Help]
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')