1. Tables and Views for Financials
  2. ZX_REGIMES_V

ZX_REGIMES_V

Details

  • Schema: FUSION

  • Object owner: FND

  • Object type: VIEW

Columns

Name

ROW_ID

TAX_REGIME_ID

TAX_REGIME_CODE

PARENT_REGIME_CODE

HAS_SUB_REGIME_FLAG

COUNTRY_OR_GROUP_CODE

COUNTRY_CODE

GEOGRAPHY_TYPE

GEOGRAPHY_ID

EFFECTIVE_FROM

EFFECTIVE_TO

EXCHANGE_RATE_TYPE

TAX_CURRENCY_CODE

THRSHLD_GROUPING_LVL_CODE

THRSHLD_CHK_TMPLT_CODE

PERIOD_SET_NAME

REP_TAX_AUTHORITY_ID

COLL_TAX_AUTHORITY_ID

ROUNDING_RULE_CODE

TAX_PRECISION

MINIMUM_ACCOUNTABLE_UNIT

TAX_STATUS_RULE_FLAG

DEF_PLACE_OF_SUPPLY_TYPE_CODE

APPLICABILITY_RULE_FLAG

PLACE_OF_SUPPLY_RULE_FLAG

TAX_CALC_RULE_FLAG

TAXABLE_BASIS_THRSHLD_FLAG

TAX_RATE_THRSHLD_FLAG

TAX_AMT_THRSHLD_FLAG

TAX_RATE_RULE_FLAG

TAXABLE_BASIS_RULE_FLAG

DEF_INCLUSIVE_TAX_FLAG

HAS_OTHER_JURISDICTIONS_FLAG

ALLOW_ROUNDING_OVERRIDE_FLAG

ALLOW_EXEMPTIONS_FLAG

ALLOW_EXCEPTIONS_FLAG

ALLOW_RECOVERABILITY_FLAG

AUTO_PRVN_FLAG

HAS_TAX_DET_DATE_RULE_FLAG

HAS_EXCH_RATE_DATE_RULE_FLAG

HAS_TAX_POINT_DATE_RULE_FLAG

USE_LEGAL_MSG_FLAG

REGN_NUM_SAME_AS_LE_FLAG

DEF_REC_SETTLEMENT_OPTION_CODE

TAX_ACCOUNT_PRECEDENCE_CODE

RECORD_TYPE_CODE

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

REQUEST_ID

PROGRAM_APP_NAME

PROGRAM_NAME

PROGRAM_LOGIN_ID

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

ATTRIBUTE_CATEGORY

DEF_REGISTR_PARTY_TYPE_CODE

REGISTRATION_TYPE_RULE_FLAG

TAX_INCLUSIVE_OVERRIDE_FLAG

REGIME_PRECEDENCE

CROSS_REGIME_COMPOUNDING_FLAG

TAX_REGIME_NAME

REGIME_TYPE_FLAG

VALIDATION_TYPE

VALIDATION_LEVEL

UNIQUENESS_VALIDATION_LEVEL

EXEMPTION_PROCESS_FLAG

GROSS_NET_FLAG

Query

SQL_Statement

SELECT

R.ROW_ID,

R.TAX_REGIME_ID,

R.TAX_REGIME_CODE,

R.PARENT_REGIME_CODE,

R.HAS_SUB_REGIME_FLAG,

R.COUNTRY_OR_GROUP_CODE,

R.COUNTRY_CODE,

R.GEOGRAPHY_TYPE,

R.GEOGRAPHY_ID,

R.EFFECTIVE_FROM,

R.EFFECTIVE_TO,

R.EXCHANGE_RATE_TYPE,

R.TAX_CURRENCY_CODE,

R.THRSHLD_GROUPING_LVL_CODE,

R.THRSHLD_CHK_TMPLT_CODE,

R.PERIOD_SET_NAME,

R.REP_TAX_AUTHORITY_ID,

R.COLL_TAX_AUTHORITY_ID,

R.ROUNDING_RULE_CODE,

R.TAX_PRECISION,

R.MINIMUM_ACCOUNTABLE_UNIT,

R.TAX_STATUS_RULE_FLAG,

R.DEF_PLACE_OF_SUPPLY_TYPE_CODE,

R.APPLICABILITY_RULE_FLAG,

R.PLACE_OF_SUPPLY_RULE_FLAG,

R.TAX_CALC_RULE_FLAG,

R.TAXABLE_BASIS_THRSHLD_FLAG,

R.TAX_RATE_THRSHLD_FLAG,

R.TAX_AMT_THRSHLD_FLAG,

R.TAX_RATE_RULE_FLAG,

R.TAXABLE_BASIS_RULE_FLAG,

R.DEF_INCLUSIVE_TAX_FLAG,

R.HAS_OTHER_JURISDICTIONS_FLAG,

R.ALLOW_ROUNDING_OVERRIDE_FLAG,

R.ALLOW_EXEMPTIONS_FLAG,

R.ALLOW_EXCEPTIONS_FLAG,

R.ALLOW_RECOVERABILITY_FLAG,

R.AUTO_PRVN_FLAG,

R.HAS_TAX_DET_DATE_RULE_FLAG,

R.HAS_EXCH_RATE_DATE_RULE_FLAG,

R.HAS_TAX_POINT_DATE_RULE_FLAG,

R.USE_LEGAL_MSG_FLAG,

R.REGN_NUM_SAME_AS_LE_FLAG,

R.DEF_REC_SETTLEMENT_OPTION_CODE,

R.TAX_ACCOUNT_PRECEDENCE_CODE,

R.RECORD_TYPE_CODE,

R.CREATED_BY,

R.CREATION_DATE,

R.LAST_UPDATED_BY,

R.LAST_UPDATE_DATE,

R.LAST_UPDATE_LOGIN,

R.REQUEST_ID,

R.PROGRAM_APP_NAME,

R.PROGRAM_NAME,

R.PROGRAM_LOGIN_ID,

R.ATTRIBUTE1,

R.ATTRIBUTE2,

R.ATTRIBUTE3,

R.ATTRIBUTE4,

R.ATTRIBUTE5,

R.ATTRIBUTE6,

R.ATTRIBUTE7,

R.ATTRIBUTE8,

R.ATTRIBUTE9,

R.ATTRIBUTE10,

R.ATTRIBUTE11,

R.ATTRIBUTE12,

R.ATTRIBUTE13,

R.ATTRIBUTE14,

R.ATTRIBUTE15,

R.ATTRIBUTE_CATEGORY,

R.DEF_REGISTR_PARTY_TYPE_CODE,

R.REGISTRATION_TYPE_RULE_FLAG,

R.TAX_INCLUSIVE_OVERRIDE_FLAG,

R.REGIME_PRECEDENCE,

R.CROSS_REGIME_COMPOUNDING_FLAG,

R.TAX_REGIME_NAME,

R.REGIME_TYPE_FLAG,

R.VALIDATION_TYPE,

R.VALIDATION_LEVEL,

R.UNIQUENESS_VALIDATION_LEVEL,

R.EXEMPTION_PROCESS_FLAG,

R.GROSS_NET_FLAG

FROM ZX_REGIMES_VL R,

ZX_REGIMES_USAGES RU,

ZX_FIRST_PARTY_ORGANIZATIONS_V FPOV

WHERE RU.TAX_REGIME_CODE = R.TAX_REGIME_CODE

AND RU.FIRST_PTY_ORG_ID = FPOV.PARTY_TAX_PROFILE_ID

AND ZX_PROFILE.VALUE('ZX_GCO_WRITE_ACCESS') = 'N'

UNION ALL

SELECT

R.ROW_ID,

R.TAX_REGIME_ID,

R.TAX_REGIME_CODE,

R.PARENT_REGIME_CODE,

R.HAS_SUB_REGIME_FLAG,

R.COUNTRY_OR_GROUP_CODE,

R.COUNTRY_CODE,

R.GEOGRAPHY_TYPE,

R.GEOGRAPHY_ID,

R.EFFECTIVE_FROM,

R.EFFECTIVE_TO,

R.EXCHANGE_RATE_TYPE,

R.TAX_CURRENCY_CODE,

R.THRSHLD_GROUPING_LVL_CODE,

R.THRSHLD_CHK_TMPLT_CODE,

R.PERIOD_SET_NAME,

R.REP_TAX_AUTHORITY_ID,

R.COLL_TAX_AUTHORITY_ID,

R.ROUNDING_RULE_CODE,

R.TAX_PRECISION,

R.MINIMUM_ACCOUNTABLE_UNIT,

R.TAX_STATUS_RULE_FLAG,

R.DEF_PLACE_OF_SUPPLY_TYPE_CODE,

R.APPLICABILITY_RULE_FLAG,

R.PLACE_OF_SUPPLY_RULE_FLAG,

R.TAX_CALC_RULE_FLAG,

R.TAXABLE_BASIS_THRSHLD_FLAG,

R.TAX_RATE_THRSHLD_FLAG,

R.TAX_AMT_THRSHLD_FLAG,

R.TAX_RATE_RULE_FLAG,

R.TAXABLE_BASIS_RULE_FLAG,

R.DEF_INCLUSIVE_TAX_FLAG,

R.HAS_OTHER_JURISDICTIONS_FLAG,

R.ALLOW_ROUNDING_OVERRIDE_FLAG,

R.ALLOW_EXEMPTIONS_FLAG,

R.ALLOW_EXCEPTIONS_FLAG,

R.ALLOW_RECOVERABILITY_FLAG,

R.AUTO_PRVN_FLAG,

R.HAS_TAX_DET_DATE_RULE_FLAG,

R.HAS_EXCH_RATE_DATE_RULE_FLAG,

R.HAS_TAX_POINT_DATE_RULE_FLAG,

R.USE_LEGAL_MSG_FLAG,

R.REGN_NUM_SAME_AS_LE_FLAG,

R.DEF_REC_SETTLEMENT_OPTION_CODE,

R.TAX_ACCOUNT_PRECEDENCE_CODE,

R.RECORD_TYPE_CODE,

R.CREATED_BY,

R.CREATION_DATE,

R.LAST_UPDATED_BY,

R.LAST_UPDATE_DATE,

R.LAST_UPDATE_LOGIN,

R.REQUEST_ID,

R.PROGRAM_APP_NAME,

R.PROGRAM_NAME,

R.PROGRAM_LOGIN_ID,

R.ATTRIBUTE1,

R.ATTRIBUTE2,

R.ATTRIBUTE3,

R.ATTRIBUTE4,

R.ATTRIBUTE5,

R.ATTRIBUTE6,

R.ATTRIBUTE7,

R.ATTRIBUTE8,

R.ATTRIBUTE9,

R.ATTRIBUTE10,

R.ATTRIBUTE11,

R.ATTRIBUTE12,

R.ATTRIBUTE13,

R.ATTRIBUTE14,

R.ATTRIBUTE15,

R.ATTRIBUTE_CATEGORY,

R.DEF_REGISTR_PARTY_TYPE_CODE,

R.REGISTRATION_TYPE_RULE_FLAG,

R.TAX_INCLUSIVE_OVERRIDE_FLAG,

R.REGIME_PRECEDENCE,

R.CROSS_REGIME_COMPOUNDING_FLAG,

R.TAX_REGIME_NAME,

R.REGIME_TYPE_FLAG,

R.VALIDATION_TYPE,

R.VALIDATION_LEVEL,

R.UNIQUENESS_VALIDATION_LEVEL,

R.EXEMPTION_PROCESS_FLAG,

R.GROSS_NET_FLAG

FROM ZX_REGIMES_VL R

WHERE ZX_PROFILE.VALUE('ZX_GCO_WRITE_ACCESS') = 'Y'