1. Tables and Views for Financials
  2. ZX_TAXES_VL

ZX_TAXES_VL

Details

  • Schema: FUSION

  • Object owner: FND

  • Object type: VIEW

Columns

Name

ROW_ID

TAX_ID

TAX

CONTENT_OWNER_ID

EFFECTIVE_FROM

EFFECTIVE_TO

TAX_REGIME_CODE

TAX_TYPE_CODE

ALLOW_MANUAL_ENTRY_FLAG

ALLOW_TAX_OVERRIDE_FLAG

MIN_TXBL_BSIS_THRSHLD

MAX_TXBL_BSIS_THRSHLD

MIN_TAX_RATE_THRSHLD

MAX_TAX_RATE_THRSHLD

MIN_TAX_AMT_THRSHLD

MAX_TAX_AMT_THRSHLD

COMPOUNDING_PRECEDENCE

PERIOD_SET_NAME

EXCHANGE_RATE_TYPE

TAX_CURRENCY_CODE

REP_TAX_AUTHORITY_ID

COLL_TAX_AUTHORITY_ID

TAX_PRECISION

MINIMUM_ACCOUNTABLE_UNIT

ROUNDING_RULE_CODE

TAX_STATUS_RULE_FLAG

TAX_RATE_RULE_FLAG

DEF_PLACE_OF_SUPPLY_TYPE_CODE

PLACE_OF_SUPPLY_RULE_FLAG

DIRECT_RATE_RULE_FLAG

APPLICABILITY_RULE_FLAG

TAX_CALC_RULE_FLAG

TXBL_BSIS_THRSHLD_FLAG

TAX_RATE_THRSHLD_FLAG

TAX_AMT_THRSHLD_FLAG

TAXABLE_BASIS_RULE_FLAG

DEF_INCLUSIVE_TAX_FLAG

THRSHLD_GROUPING_LVL_CODE

THRSHLD_CHK_TMPLT_CODE

HAS_OTHER_JURISDICTIONS_FLAG

ALLOW_EXEMPTIONS_FLAG

ALLOW_EXCEPTIONS_FLAG

ALLOW_RECOVERABILITY_FLAG

DEF_TAX_CALC_FORMULA

TAX_INCLUSIVE_OVERRIDE_FLAG

DEF_TAXABLE_BASIS_FORMULA

DEF_REGISTR_PARTY_TYPE_CODE

REGISTRATION_TYPE_RULE_FLAG

REPORTING_ONLY_FLAG

AUTO_PRVN_FLAG

LIVE_FOR_PROCESSING_FLAG

HAS_DETAIL_TB_THRSHLD_FLAG

HAS_TAX_DET_DATE_RULE_FLAG

HAS_EXCH_RATE_DATE_RULE_FLAG

HAS_TAX_POINT_DATE_RULE_FLAG

PRINT_ON_INVOICE_FLAG

USE_LEGAL_MSG_FLAG

CALC_ONLY_FLAG

PRIMARY_RECOVERY_TYPE_CODE

PRIMARY_REC_TYPE_RULE_FLAG

SECONDARY_RECOVERY_TYPE_CODE

SECONDARY_REC_TYPE_RULE_FLAG

PRIMARY_REC_RATE_DET_RULE_FLAG

SEC_REC_RATE_DET_RULE_FLAG

OFFSET_TAX_FLAG

RECOVERY_RATE_OVERRIDE_FLAG

ZONE_GEOGRAPHY_TYPE

REGN_NUM_SAME_AS_LE_FLAG

DEF_REC_SETTLEMENT_OPTION_CODE

PARENT_GEOGRAPHY_TYPE

PARENT_GEOGRAPHY_ID

ALLOW_MASS_CREATE_FLAG

APPLIED_AMT_HANDLING_FLAG

SOURCE_TAX_FLAG

DEF_PRIMARY_REC_RATE_CODE

DEF_SECONDARY_REC_RATE_CODE

ALLOW_DUP_REGN_NUM_FLAG

TAX_ACCOUNT_SOURCE_TAX

TAX_ACCOUNT_CREATE_METHOD_CODE

TAX_EXMPT_SOURCE_TAX

TAX_EXMPT_CR_METHOD_CODE

OVERRIDE_GEOGRAPHY_TYPE

LIVE_FOR_APPLICABILITY_FLAG

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

REQUEST_ID

PROGRAM_APP_NAME

PROGRAM_NAME

PROGRAM_LOGIN_ID

RECORD_TYPE_CODE

ALLOW_ROUNDING_OVERRIDE_FLAG

SPECIAL_INCLUSIVE_TAX_FLAG

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

ATTRIBUTE_CATEGORY

TAX_FULL_NAME

APPLICABLE_BY_DEFAULT_FLAG

LEGAL_REPORTING_STATUS_DEF_VAL

TAX_POINT_BASIS

SELF_ASSESS_DIFF_TAX

WHT_BUCKET_LEVEL_FLAG

PROCESS_WHT_FLAG

WHT_CALC_POINT_FLAG

VALIDATION_TYPE

UNIQUENESS_VALIDATION_LEVEL

VALIDATION_LEVEL

TAX_AUTH_INV_CREATION_POINT

TAXABLE_AMT_MAU

CHARGE_LINE_HANDLING_CODE

THRSHLD_SCHEDULE_GRP_LVL_FLAG

WHT_DATE_BASIS

ALLOW_ZERO_AMT_WHT_INV_FLAG

INVOICE_AMOUNT_WHT_FLAG

PAYMENT_AMOUNT_WHT_FLAG

TAXABLE_BASIS_EXEMPTION_FLAG

THRSHLD_PRODUCT_CATEGORY_FLAG

DEF_RECOVERY_SPL_HANDLING_FLAG

DEFAULT_TAX_STATUS_CODE

DEFAULT_TAX_RATE_CODE

TAX_EXCPT_CREATE_METHOD_CODE

TAX_EXCPT_SOURCE_TAX

Query

SQL_Statement

SELECT

B.ROWID ROW_ID,

B.TAX_ID,

B.TAX,

B.CONTENT_OWNER_ID,

B.EFFECTIVE_FROM,

B.EFFECTIVE_TO,

B.TAX_REGIME_CODE,

B.TAX_TYPE_CODE,

B.ALLOW_MANUAL_ENTRY_FLAG,

B.ALLOW_TAX_OVERRIDE_FLAG,

B.MIN_TXBL_BSIS_THRSHLD,

B.MAX_TXBL_BSIS_THRSHLD,

B.MIN_TAX_RATE_THRSHLD,

B.MAX_TAX_RATE_THRSHLD,

B.MIN_TAX_AMT_THRSHLD,

B.MAX_TAX_AMT_THRSHLD,

B.COMPOUNDING_PRECEDENCE,

B.PERIOD_SET_NAME,

B.EXCHANGE_RATE_TYPE,

B.TAX_CURRENCY_CODE,

B.REP_TAX_AUTHORITY_ID,

B.COLL_TAX_AUTHORITY_ID,

B.TAX_PRECISION,

B.MINIMUM_ACCOUNTABLE_UNIT,

B.ROUNDING_RULE_CODE,

B.TAX_STATUS_RULE_FLAG,

B.TAX_RATE_RULE_FLAG,

B.DEF_PLACE_OF_SUPPLY_TYPE_CODE,

B.PLACE_OF_SUPPLY_RULE_FLAG,

B.DIRECT_RATE_RULE_FLAG,

B.APPLICABILITY_RULE_FLAG,

B.TAX_CALC_RULE_FLAG,

B.TXBL_BSIS_THRSHLD_FLAG,

B.TAX_RATE_THRSHLD_FLAG,

B.TAX_AMT_THRSHLD_FLAG,

B.TAXABLE_BASIS_RULE_FLAG,

B.DEF_INCLUSIVE_TAX_FLAG,

B.THRSHLD_GROUPING_LVL_CODE,

B.THRSHLD_CHK_TMPLT_CODE,

B.HAS_OTHER_JURISDICTIONS_FLAG,

B.ALLOW_EXEMPTIONS_FLAG,

B.ALLOW_EXCEPTIONS_FLAG,

B.ALLOW_RECOVERABILITY_FLAG,

B.DEF_TAX_CALC_FORMULA,

B.TAX_INCLUSIVE_OVERRIDE_FLAG,

B.DEF_TAXABLE_BASIS_FORMULA,

B.DEF_REGISTR_PARTY_TYPE_CODE,

B.REGISTRATION_TYPE_RULE_FLAG,

B.REPORTING_ONLY_FLAG,

B.AUTO_PRVN_FLAG,

B.LIVE_FOR_PROCESSING_FLAG,

B.HAS_DETAIL_TB_THRSHLD_FLAG,

B.HAS_TAX_DET_DATE_RULE_FLAG,

B.HAS_EXCH_RATE_DATE_RULE_FLAG,

B.HAS_TAX_POINT_DATE_RULE_FLAG,

B.PRINT_ON_INVOICE_FLAG,

B.USE_LEGAL_MSG_FLAG,

B.CALC_ONLY_FLAG,

B.PRIMARY_RECOVERY_TYPE_CODE,

B.PRIMARY_REC_TYPE_RULE_FLAG,

B.SECONDARY_RECOVERY_TYPE_CODE,

B.SECONDARY_REC_TYPE_RULE_FLAG,

B.PRIMARY_REC_RATE_DET_RULE_FLAG,

B.SEC_REC_RATE_DET_RULE_FLAG,

B.OFFSET_TAX_FLAG,

B.RECOVERY_RATE_OVERRIDE_FLAG,

B.ZONE_GEOGRAPHY_TYPE,

B.REGN_NUM_SAME_AS_LE_FLAG,

B.DEF_REC_SETTLEMENT_OPTION_CODE,

B.PARENT_GEOGRAPHY_TYPE,

B.PARENT_GEOGRAPHY_ID,

B.ALLOW_MASS_CREATE_FLAG,

B.APPLIED_AMT_HANDLING_FLAG,

B.SOURCE_TAX_FLAG,

B.DEF_PRIMARY_REC_RATE_CODE,

B.DEF_SECONDARY_REC_RATE_CODE,

B.ALLOW_DUP_REGN_NUM_FLAG,

B.TAX_ACCOUNT_SOURCE_TAX,

B.TAX_ACCOUNT_CREATE_METHOD_CODE,

B.TAX_EXMPT_SOURCE_TAX,

B.TAX_EXMPT_CR_METHOD_CODE,

B.OVERRIDE_GEOGRAPHY_TYPE,

B.LIVE_FOR_APPLICABILITY_FLAG,

B.OBJECT_VERSION_NUMBER,

B.CREATED_BY,

B.CREATION_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN,

B.REQUEST_ID,

B.PROGRAM_APP_NAME,

B.PROGRAM_NAME,

B.PROGRAM_LOGIN_ID,

B.RECORD_TYPE_CODE,

B.ALLOW_ROUNDING_OVERRIDE_FLAG,

B.SPECIAL_INCLUSIVE_TAX_FLAG,

B.ATTRIBUTE1,

B.ATTRIBUTE2,

B.ATTRIBUTE3,

B.ATTRIBUTE4,

B.ATTRIBUTE5,

B.ATTRIBUTE6,

B.ATTRIBUTE7,

B.ATTRIBUTE8,

B.ATTRIBUTE9,

B.ATTRIBUTE10,

B.ATTRIBUTE11,

B.ATTRIBUTE12,

B.ATTRIBUTE13,

B.ATTRIBUTE14,

B.ATTRIBUTE15,

B.ATTRIBUTE_CATEGORY,

T.TAX_FULL_NAME,

B.APPLICABLE_BY_DEFAULT_FLAG,

B.LEGAL_REPORTING_STATUS_DEF_VAL,

B.TAX_POINT_BASIS,

B.SELF_ASSESS_DIFF_TAX,

B.WHT_BUCKET_LEVEL_FLAG,

B.PROCESS_WHT_FLAG,

B.WHT_CALC_POINT_FLAG,

B.VALIDATION_TYPE,

B.UNIQUENESS_VALIDATION_LEVEL,

B.VALIDATION_LEVEL,

B.TAX_AUTH_INV_CREATION_POINT,

B.TAXABLE_AMT_MAU,

B.CHARGE_LINE_HANDLING_CODE,

B.THRSHLD_SCHEDULE_GRP_LVL_FLAG,

B.WHT_DATE_BASIS,

B.ALLOW_ZERO_AMT_WHT_INV_FLAG,

B.INVOICE_AMOUNT_WHT_FLAG,

B.PAYMENT_AMOUNT_WHT_FLAG,

B.TAXABLE_BASIS_EXEMPTION_FLAG,

B.THRSHLD_PRODUCT_CATEGORY_FLAG,

B.DEF_RECOVERY_SPL_HANDLING_FLAG,

B.DEFAULT_TAX_STATUS_CODE,

B.DEFAULT_TAX_RATE_CODE,

B.TAX_EXCPT_CREATE_METHOD_CODE,

B.TAX_EXCPT_SOURCE_TAX

FROM

ZX_TAXES_TL T,

ZX_TAXES_B B

WHERE

B.TAX_ID = T.TAX_ID AND T.LANGUAGE = USERENV('LANG')