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