1. Tables and Views for Financials
  2. ZX_MCO_EO_TAXES_V

ZX_MCO_EO_TAXES_V

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

CONTENT_OWNER_NAME

UPDATE_ACCESS

DUPLICATE_ACCESS

LEGAL_REPORTING_STATUS_DEF_VAL

WHT_BUCKET_LEVEL_FLAG

PROCESS_WHT_FLAG

WHT_CALC_POINT_FLAG

VALIDATION_TYPE

VALIDATION_LEVEL

UNIQUENESS_VALIDATION_LEVEL

TAX_EXCPT_CREATE_METHOD_CODE

TAX_EXCPT_SOURCE_TAX

Query

SQL_Statement

SELECT

ZTB.ROWID AS ROW_ID,

ZTB.TAX_ID,

ZTB.TAX,

ZTB.CONTENT_OWNER_ID,

ZTB.EFFECTIVE_FROM,

ZTB.EFFECTIVE_TO,

ZTB.TAX_REGIME_CODE,

ZTB.TAX_TYPE_CODE,

ZTB.ALLOW_MANUAL_ENTRY_FLAG,

ZTB.ALLOW_TAX_OVERRIDE_FLAG,

ZTB.MIN_TXBL_BSIS_THRSHLD,

ZTB.MAX_TXBL_BSIS_THRSHLD,

ZTB.MIN_TAX_RATE_THRSHLD,

ZTB.MAX_TAX_RATE_THRSHLD,

ZTB.MIN_TAX_AMT_THRSHLD,

ZTB.MAX_TAX_AMT_THRSHLD,

ZTB.COMPOUNDING_PRECEDENCE,

ZTB.PERIOD_SET_NAME,

ZTB.EXCHANGE_RATE_TYPE,

ZTB.TAX_CURRENCY_CODE,

ZTB.REP_TAX_AUTHORITY_ID,

ZTB.COLL_TAX_AUTHORITY_ID,

ZTB.TAX_PRECISION,

ZTB.MINIMUM_ACCOUNTABLE_UNIT,

ZTB.ROUNDING_RULE_CODE,

ZTB.TAX_STATUS_RULE_FLAG,

ZTB.TAX_RATE_RULE_FLAG,

ZTB.DEF_PLACE_OF_SUPPLY_TYPE_CODE,

ZTB.PLACE_OF_SUPPLY_RULE_FLAG,

ZTB.DIRECT_RATE_RULE_FLAG,

ZTB.APPLICABILITY_RULE_FLAG,

ZTB.TAX_CALC_RULE_FLAG,

ZTB.TXBL_BSIS_THRSHLD_FLAG,

ZTB.TAX_RATE_THRSHLD_FLAG,

ZTB.TAX_AMT_THRSHLD_FLAG,

ZTB.TAXABLE_BASIS_RULE_FLAG,

ZTB.DEF_INCLUSIVE_TAX_FLAG,

ZTB.THRSHLD_GROUPING_LVL_CODE,

ZTB.THRSHLD_CHK_TMPLT_CODE,

ZTB.HAS_OTHER_JURISDICTIONS_FLAG,

ZTB.ALLOW_EXEMPTIONS_FLAG,

ZTB.ALLOW_EXCEPTIONS_FLAG,

ZTB.ALLOW_RECOVERABILITY_FLAG,

ZTB.DEF_TAX_CALC_FORMULA,

ZTB.TAX_INCLUSIVE_OVERRIDE_FLAG,

ZTB.DEF_TAXABLE_BASIS_FORMULA,

ZTB.DEF_REGISTR_PARTY_TYPE_CODE,

ZTB.REGISTRATION_TYPE_RULE_FLAG,

ZTB.REPORTING_ONLY_FLAG,

ZTB.AUTO_PRVN_FLAG,

ZTB.LIVE_FOR_PROCESSING_FLAG,

ZTB.HAS_DETAIL_TB_THRSHLD_FLAG,

ZTB.HAS_TAX_DET_DATE_RULE_FLAG,

ZTB.HAS_EXCH_RATE_DATE_RULE_FLAG,

ZTB.HAS_TAX_POINT_DATE_RULE_FLAG,

ZTB.PRINT_ON_INVOICE_FLAG,

ZTB.USE_LEGAL_MSG_FLAG,

ZTB.CALC_ONLY_FLAG,

ZTB.PRIMARY_RECOVERY_TYPE_CODE,

ZTB.PRIMARY_REC_TYPE_RULE_FLAG,

ZTB.SECONDARY_RECOVERY_TYPE_CODE,

ZTB.SECONDARY_REC_TYPE_RULE_FLAG,

ZTB.PRIMARY_REC_RATE_DET_RULE_FLAG,

ZTB.SEC_REC_RATE_DET_RULE_FLAG,

ZTB.OFFSET_TAX_FLAG,

ZTB.RECOVERY_RATE_OVERRIDE_FLAG,

ZTB.ZONE_GEOGRAPHY_TYPE,

ZTB.REGN_NUM_SAME_AS_LE_FLAG,

ZTB.DEF_REC_SETTLEMENT_OPTION_CODE,

ZTB.PARENT_GEOGRAPHY_TYPE,

ZTB.PARENT_GEOGRAPHY_ID,

ZTB.ALLOW_MASS_CREATE_FLAG,

ZTB.APPLIED_AMT_HANDLING_FLAG,

ZTB.SOURCE_TAX_FLAG,

ZTB.DEF_PRIMARY_REC_RATE_CODE,

ZTB.DEF_SECONDARY_REC_RATE_CODE,

ZTB.ALLOW_DUP_REGN_NUM_FLAG,

ZTB.TAX_ACCOUNT_SOURCE_TAX,

ZTB.TAX_ACCOUNT_CREATE_METHOD_CODE,

ZTB.TAX_EXMPT_SOURCE_TAX,

ZTB.TAX_EXMPT_CR_METHOD_CODE,

ZTB.OVERRIDE_GEOGRAPHY_TYPE,

ZTB.LIVE_FOR_APPLICABILITY_FLAG,

ZTB.OBJECT_VERSION_NUMBER,

ZTB.CREATED_BY,

ZTB.CREATION_DATE,

ZTB.LAST_UPDATED_BY,

ZTB.LAST_UPDATE_DATE,

ZTB.LAST_UPDATE_LOGIN,

ZTB.REQUEST_ID,

ZTB.PROGRAM_APP_NAME,

ZTB.PROGRAM_NAME,

ZTB.PROGRAM_LOGIN_ID,

ZTB.RECORD_TYPE_CODE,

ZTB.ALLOW_ROUNDING_OVERRIDE_FLAG,

ZTB.SPECIAL_INCLUSIVE_TAX_FLAG,

ZTB.ATTRIBUTE1,

ZTB.ATTRIBUTE2,

ZTB.ATTRIBUTE3,

ZTB.ATTRIBUTE4,

ZTB.ATTRIBUTE5,

ZTB.ATTRIBUTE6,

ZTB.ATTRIBUTE7,

ZTB.ATTRIBUTE8,

ZTB.ATTRIBUTE9,

ZTB.ATTRIBUTE10,

ZTB.ATTRIBUTE11,

ZTB.ATTRIBUTE12,

ZTB.ATTRIBUTE13,

ZTB.ATTRIBUTE14,

ZTB.ATTRIBUTE15,

ZTB.ATTRIBUTE_CATEGORY,

ZTT.TAX_FULL_NAME,

ZTB.APPLICABLE_BY_DEFAULT_FLAG,

ZFPOMV.PARTY_NAME AS CONTENT_OWNER_NAME,

ZMCAV.UPDATE_ACCESS,

ZMCAV.DUPLICATE_ACCESS,

ZTB.LEGAL_REPORTING_STATUS_DEF_VAL,

ZTB.WHT_BUCKET_LEVEL_FLAG,

ZTB.PROCESS_WHT_FLAG,

ZTB.WHT_CALC_POINT_FLAG,

ZTB.VALIDATION_TYPE,

ZTB.VALIDATION_LEVEL,

ZTB.UNIQUENESS_VALIDATION_LEVEL,

ZTB.TAX_EXCPT_CREATE_METHOD_CODE,

ZTB.TAX_EXCPT_SOURCE_TAX

FROM ZX_TAXES_B ZTB,

ZX_TAXES_TL ZTT,

ZX_FIRST_PARTY_ORGS_MOAC_V ZFPOMV,

ZX_MCO_CHECK_ACCESS_V ZMCAV

WHERE ZTT.TAX_ID = ZTB.TAX_ID

AND ZTT.LANGUAGE = USERENV('LANG')

AND ZFPOMV.PARTY_TAX_PROFILE_ID = ZTB.CONTENT_OWNER_ID

AND ZMCAV.TAX_REGIME_CODE = ZTB.TAX_REGIME_CODE

AND ZMCAV.PARENT_FIRST_PTY_ORG_ID = ZTB.CONTENT_OWNER_ID