ZX_REGIMES_VL

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 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 OBJECT_VERSION_NUMBER 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 USE_TAX_REPORT_CONFIG_FLAG TAX_REGIME_NAME REGIME_TYPE_FLAG VALIDATION_TYPE VALIDATION_LEVEL UNIQUENESS_VALIDATION_LEVEL EXEMPTION_PROCESS_FLAG BUCKET_LEVEL_FLAG USE_SYSTEM_DEFAULTS_FLAG GROSS_NET_FLAG

Query

SQL_Statement

SELECT B.ROWID ROW_ID, B.TAX_REGIME_ID, B.TAX_REGIME_CODE, B.PARENT_REGIME_CODE, B.HAS_SUB_REGIME_FLAG, B.COUNTRY_OR_GROUP_CODE, B.COUNTRY_CODE, B.GEOGRAPHY_TYPE, B.GEOGRAPHY_ID, B.EFFECTIVE_FROM, B.EFFECTIVE_TO, B.EXCHANGE_RATE_TYPE, B.TAX_CURRENCY_CODE, B.CONV_ROUNDING_OPTION_CODE, B.THRSHLD_GROUPING_LVL_CODE, B.THRSHLD_CHK_TMPLT_CODE, B.PERIOD_SET_NAME, B.REP_TAX_AUTHORITY_ID, B.COLL_TAX_AUTHORITY_ID, B.ROUNDING_RULE_CODE, B.TAX_PRECISION, B.MINIMUM_ACCOUNTABLE_UNIT, B.TAX_STATUS_RULE_FLAG, B.DEF_PLACE_OF_SUPPLY_TYPE_CODE, B.APPLICABILITY_RULE_FLAG, B.PLACE_OF_SUPPLY_RULE_FLAG, B.TAX_CALC_RULE_FLAG, B.TAXABLE_BASIS_THRSHLD_FLAG, B.TAX_RATE_THRSHLD_FLAG, B.TAX_AMT_THRSHLD_FLAG, B.TAX_RATE_RULE_FLAG, B.TAXABLE_BASIS_RULE_FLAG, B.DEF_INCLUSIVE_TAX_FLAG, B.HAS_OTHER_JURISDICTIONS_FLAG, B.ALLOW_ROUNDING_OVERRIDE_FLAG, B.ALLOW_EXEMPTIONS_FLAG, B.ALLOW_EXCEPTIONS_FLAG, B.ALLOW_RECOVERABILITY_FLAG, B.AUTO_PRVN_FLAG, B.HAS_TAX_DET_DATE_RULE_FLAG, B.HAS_EXCH_RATE_DATE_RULE_FLAG, B.HAS_TAX_POINT_DATE_RULE_FLAG, B.USE_LEGAL_MSG_FLAG, B.REGN_NUM_SAME_AS_LE_FLAG, B.DEF_REC_SETTLEMENT_OPTION_CODE, B.TAX_ACCOUNT_PRECEDENCE_CODE, B.OBJECT_VERSION_NUMBER, B.RECORD_TYPE_CODE, 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.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, B.DEF_REGISTR_PARTY_TYPE_CODE, B.REGISTRATION_TYPE_RULE_FLAG, B.TAX_INCLUSIVE_OVERRIDE_FLAG, B.REGIME_PRECEDENCE, B.CROSS_REGIME_COMPOUNDING_FLAG, B.USE_TAX_REPORT_CONFIG_FLAG, T.TAX_REGIME_NAME, B.REGIME_TYPE_FLAG, B.VALIDATION_TYPE, B.VALIDATION_LEVEL, B.UNIQUENESS_VALIDATION_LEVEL, B.EXEMPTION_PROCESS_FLAG, B.BUCKET_LEVEL_FLAG, B.USE_SYSTEM_DEFAULTS_FLAG, B.GROSS_NET_FLAG FROM ZX_REGIMES_TL T, ZX_REGIMES_B B WHERE B.TAX_REGIME_ID = T.TAX_REGIME_ID AND T.LANGUAGE = USERENV('LANG')