ZX_REGIMES_B_V

Details

• Schema: FUSION

• Object owner: FND

• Object type: VIEW

Columns

Name

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 CONV_ROUNDING_OPTION_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 REGIME_TYPE_FLAG VALIDATION_TYPE VALIDATION_LEVEL UNIQUENESS_VALIDATION_LEVEL EXEMPTION_PROCESS_FLAG USE_SYSTEM_DEFAULTS_FLAG GROSS_NET_FLAG

Query

SQL_Statement

SELECT RB.TAX_REGIME_ID, RB.TAX_REGIME_CODE, RB.PARENT_REGIME_CODE, RB.HAS_SUB_REGIME_FLAG, RB.COUNTRY_OR_GROUP_CODE, RB.COUNTRY_CODE, RB.GEOGRAPHY_TYPE, RB.GEOGRAPHY_ID, RB.EFFECTIVE_FROM, RB.EFFECTIVE_TO, RB.EXCHANGE_RATE_TYPE, RB.TAX_CURRENCY_CODE, RB.CONV_ROUNDING_OPTION_CODE, RB.THRSHLD_GROUPING_LVL_CODE, RB.THRSHLD_CHK_TMPLT_CODE, RB.PERIOD_SET_NAME, RB.REP_TAX_AUTHORITY_ID, RB.COLL_TAX_AUTHORITY_ID, RB.ROUNDING_RULE_CODE, RB.TAX_PRECISION, RB.MINIMUM_ACCOUNTABLE_UNIT, RB.TAX_STATUS_RULE_FLAG, RB.DEF_PLACE_OF_SUPPLY_TYPE_CODE, RB.APPLICABILITY_RULE_FLAG, RB.PLACE_OF_SUPPLY_RULE_FLAG, RB.TAX_CALC_RULE_FLAG, RB.TAXABLE_BASIS_THRSHLD_FLAG, RB.TAX_RATE_THRSHLD_FLAG, RB.TAX_AMT_THRSHLD_FLAG, RB.TAX_RATE_RULE_FLAG, RB.TAXABLE_BASIS_RULE_FLAG, RB.DEF_INCLUSIVE_TAX_FLAG, RB.HAS_OTHER_JURISDICTIONS_FLAG, RB.ALLOW_ROUNDING_OVERRIDE_FLAG, RB.ALLOW_EXEMPTIONS_FLAG, RB.ALLOW_EXCEPTIONS_FLAG, RB.ALLOW_RECOVERABILITY_FLAG, RB.AUTO_PRVN_FLAG, RB.HAS_TAX_DET_DATE_RULE_FLAG, RB.HAS_EXCH_RATE_DATE_RULE_FLAG, RB.HAS_TAX_POINT_DATE_RULE_FLAG, RB.USE_LEGAL_MSG_FLAG, RB.REGN_NUM_SAME_AS_LE_FLAG, RB.DEF_REC_SETTLEMENT_OPTION_CODE, RB.TAX_ACCOUNT_PRECEDENCE_CODE, RB.RECORD_TYPE_CODE, RB.CREATED_BY, RB.CREATION_DATE, RB.LAST_UPDATED_BY, RB.LAST_UPDATE_DATE, RB.LAST_UPDATE_LOGIN, RB.REQUEST_ID, RB.PROGRAM_APP_NAME, RB.PROGRAM_NAME, RB.PROGRAM_LOGIN_ID, RB.ATTRIBUTE1, RB.ATTRIBUTE2, RB.ATTRIBUTE3, RB.ATTRIBUTE4, RB.ATTRIBUTE5, RB.ATTRIBUTE6, RB.ATTRIBUTE7, RB.ATTRIBUTE8, RB.ATTRIBUTE9, RB.ATTRIBUTE10, RB.ATTRIBUTE11, RB.ATTRIBUTE12, RB.ATTRIBUTE13, RB.ATTRIBUTE14, RB.ATTRIBUTE15, RB.ATTRIBUTE_CATEGORY, RB.DEF_REGISTR_PARTY_TYPE_CODE, RB.REGISTRATION_TYPE_RULE_FLAG, RB.TAX_INCLUSIVE_OVERRIDE_FLAG, RB.REGIME_PRECEDENCE, RB.CROSS_REGIME_COMPOUNDING_FLAG, RB.REGIME_TYPE_FLAG, RB.VALIDATION_TYPE, RB.VALIDATION_LEVEL, RB.UNIQUENESS_VALIDATION_LEVEL, RB.EXEMPTION_PROCESS_FLAG, RB.USE_SYSTEM_DEFAULTS_FLAG, RB.GROSS_NET_FLAG FROM ZX_REGIMES_B RB