ZX_SCO_TAXES_B_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 SUBSCRIPTION_LEVEL_CODE SDCO_ID SDEFF_FROM SDEFF_TO APPLICABLE_BY_DEFAULT_FLAG LEGAL_REPORTING_STATUS_DEF_VAL TAX_POINT_BASIS WHT_BUCKET_LEVEL_FLAG PROCESS_WHT_FLAG WHT_CALC_POINT_FLAG VALIDATION_TYPE VALIDATION_LEVEL UNIQUENESS_VALIDATION_LEVEL TAX_AUTH_INV_CREATION_POINT TAXABLE_AMT_MAU CHARGE_LINE_HANDLING_CODE THRSHLD_SCHEDULE_GRP_LVL_FLAG WHT_DATE_BASIS ALLOW_ZERO_AMT_WHT_INV_FLAG INVOICE_AMOUNT_WHT_FLAG PAYMENT_AMOUNT_WHT_FLAG TAXABLE_BASIS_EXEMPTION_FLAG THRSHLD_PRODUCT_CATEGORY_FLAG DEFAULT_TAX_STATUS_CODE DEFAULT_TAX_RATE_CODE TAX_EXCPT_CREATE_METHOD_CODE TAX_EXCPT_SOURCE_TAX

Query

SQL_Statement

SELECT a.ROWID ROW_ID, a.TAX_ID, a.TAX, a.CONTENT_OWNER_ID, a.EFFECTIVE_FROM, a.EFFECTIVE_TO, a.TAX_REGIME_CODE, a.TAX_TYPE_CODE, a.ALLOW_MANUAL_ENTRY_FLAG, a.ALLOW_TAX_OVERRIDE_FLAG, a.MIN_TXBL_BSIS_THRSHLD, a.MAX_TXBL_BSIS_THRSHLD, a.MIN_TAX_RATE_THRSHLD, a.MAX_TAX_RATE_THRSHLD, a.MIN_TAX_AMT_THRSHLD, a.MAX_TAX_AMT_THRSHLD, a.COMPOUNDING_PRECEDENCE, a.PERIOD_SET_NAME, a.EXCHANGE_RATE_TYPE, a.TAX_CURRENCY_CODE, a.REP_TAX_AUTHORITY_ID, a.COLL_TAX_AUTHORITY_ID, a.TAX_PRECISION, a.MINIMUM_ACCOUNTABLE_UNIT, a.ROUNDING_RULE_CODE, a.TAX_STATUS_RULE_FLAG, a.TAX_RATE_RULE_FLAG, a.DEF_PLACE_OF_SUPPLY_TYPE_CODE, a.PLACE_OF_SUPPLY_RULE_FLAG, a.DIRECT_RATE_RULE_FLAG, a.APPLICABILITY_RULE_FLAG, a.TAX_CALC_RULE_FLAG, a.TXBL_BSIS_THRSHLD_FLAG, a.TAX_RATE_THRSHLD_FLAG, a.TAX_AMT_THRSHLD_FLAG, a.TAXABLE_BASIS_RULE_FLAG, a.DEF_INCLUSIVE_TAX_FLAG, a.THRSHLD_GROUPING_LVL_CODE, a.THRSHLD_CHK_TMPLT_CODE, a.HAS_OTHER_JURISDICTIONS_FLAG, a.ALLOW_EXEMPTIONS_FLAG, a.ALLOW_EXCEPTIONS_FLAG, a.ALLOW_RECOVERABILITY_FLAG, a.DEF_TAX_CALC_FORMULA, a.TAX_INCLUSIVE_OVERRIDE_FLAG, a.DEF_TAXABLE_BASIS_FORMULA, a.DEF_REGISTR_PARTY_TYPE_CODE, a.REGISTRATION_TYPE_RULE_FLAG, a.REPORTING_ONLY_FLAG, a.AUTO_PRVN_FLAG, a.LIVE_FOR_PROCESSING_FLAG, a.HAS_DETAIL_TB_THRSHLD_FLAG, a.HAS_TAX_DET_DATE_RULE_FLAG, a.HAS_EXCH_RATE_DATE_RULE_FLAG, a.HAS_TAX_POINT_DATE_RULE_FLAG, a.PRINT_ON_INVOICE_FLAG, a.USE_LEGAL_MSG_FLAG, a.CALC_ONLY_FLAG, a.PRIMARY_RECOVERY_TYPE_CODE, a.PRIMARY_REC_TYPE_RULE_FLAG, a.SECONDARY_RECOVERY_TYPE_CODE, a.SECONDARY_REC_TYPE_RULE_FLAG, a.PRIMARY_REC_RATE_DET_RULE_FLAG, a.SEC_REC_RATE_DET_RULE_FLAG, a.OFFSET_TAX_FLAG, a.RECOVERY_RATE_OVERRIDE_FLAG, a.ZONE_GEOGRAPHY_TYPE, a.REGN_NUM_SAME_AS_LE_FLAG, a.DEF_REC_SETTLEMENT_OPTION_CODE, a.PARENT_GEOGRAPHY_TYPE, a.PARENT_GEOGRAPHY_ID, a.ALLOW_MASS_CREATE_FLAG, a.APPLIED_AMT_HANDLING_FLAG, a.SOURCE_TAX_FLAG, a.DEF_PRIMARY_REC_RATE_CODE, a.DEF_SECONDARY_REC_RATE_CODE, a.ALLOW_DUP_REGN_NUM_FLAG, a.TAX_ACCOUNT_SOURCE_TAX, a.TAX_ACCOUNT_CREATE_METHOD_CODE, a.TAX_EXMPT_SOURCE_TAX, a.TAX_EXMPT_CR_METHOD_CODE, a.OVERRIDE_GEOGRAPHY_TYPE, a.LIVE_FOR_APPLICABILITY_FLAG, a.OBJECT_VERSION_NUMBER, a.CREATED_BY, a.CREATION_DATE, a.LAST_UPDATED_BY, a.LAST_UPDATE_DATE, a.LAST_UPDATE_LOGIN, a.REQUEST_ID, a.PROGRAM_APP_NAME, a.PROGRAM_NAME, a.PROGRAM_LOGIN_ID, a.RECORD_TYPE_CODE, a.ALLOW_ROUNDING_OVERRIDE_FLAG, a.SPECIAL_INCLUSIVE_TAX_FLAG, a.ATTRIBUTE1, a.ATTRIBUTE2, a.ATTRIBUTE3, a.ATTRIBUTE4, a.ATTRIBUTE5, a.ATTRIBUTE6, a.ATTRIBUTE7, a.ATTRIBUTE8, a.ATTRIBUTE9, a.ATTRIBUTE10, a.ATTRIBUTE11, a.ATTRIBUTE12, a.ATTRIBUTE13, a.ATTRIBUTE14, a.ATTRIBUTE15, a.ATTRIBUTE_CATEGORY, sd.VIEW_OPTIONS_CODE subscription_level_code, sd.FIRST_PTY_ORG_ID SDCO_ID, sd.EFFECTIVE_FROM SDEFF_FROM, sd.EFFECTIVE_TO SDEFF_TO, a.APPLICABLE_BY_DEFAULT_FLAG, a.LEGAL_REPORTING_STATUS_DEF_VAL, a.TAX_POINT_BASIS, a.WHT_BUCKET_LEVEL_FLAG, a.PROCESS_WHT_FLAG, a.WHT_CALC_POINT_FLAG, a.VALIDATION_TYPE, a.VALIDATION_LEVEL, a.UNIQUENESS_VALIDATION_LEVEL, a.TAX_AUTH_INV_CREATION_POINT, a.TAXABLE_AMT_MAU, a.CHARGE_LINE_HANDLING_CODE, a.THRSHLD_SCHEDULE_GRP_LVL_FLAG, a.WHT_DATE_BASIS, a.ALLOW_ZERO_AMT_WHT_INV_FLAG, a.INVOICE_AMOUNT_WHT_FLAG, a.PAYMENT_AMOUNT_WHT_FLAG, a.TAXABLE_BASIS_EXEMPTION_FLAG, a.THRSHLD_PRODUCT_CATEGORY_FLAG, a.DEFAULT_TAX_STATUS_CODE, a.DEFAULT_TAX_RATE_CODE, a.TAX_EXCPT_CREATE_METHOD_CODE, a.TAX_EXCPT_SOURCE_TAX FROM ZX_TAXES_B a, ZX_SUBSCRIPTION_DETAILS sd, ZX_SUBSCRIPTION_OPTIONS so WHERE a.TAX_REGIME_CODE = sd.TAX_REGIME_CODE AND a.CONTENT_OWNER_ID = sd.PARENT_FIRST_PTY_ORG_ID AND sd.VIEW_OPTIONS_CODE != 'VFD' AND sd.SUBSCRIPTION_OPTION_ID = so.SUBSCRIPTION_OPTION_ID AND so.ENABLED_FLAG = 'Y' ORDER BY sd.VIEW_OPTIONS_CODE