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.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_APPLICATION_ID,
RB.PROGRAM_ID,
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
FROM ZX_REGIMES_B RB
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.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_APPLICATION_ID
,
RB.PROGRAM_ID
,
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
FROM ZX_REGIMES_B RB
|
|
|