ZX_SCO_RATES_B_V

Details

• Schema: FUSION

• Object owner: FND

• Object type: VIEW

Columns

Name

ROW_ID TAX_RATE_ID TAX_RATE_CODE CONTENT_OWNER_ID EFFECTIVE_FROM EFFECTIVE_TO TAX_REGIME_CODE TAX TAX_STATUS_CODE SCHEDULE_BASED_RATE_FLAG RATE_TYPE_CODE PERCENTAGE_RATE QUANTITY_RATE UOM_CODE TAX_JURISDICTION_CODE RECOVERY_TYPE_CODE ACTIVE_FLAG DEFAULT_RATE_FLAG DEFAULT_FLG_EFFECTIVE_FROM DEFAULT_FLG_EFFECTIVE_TO DEFAULT_REC_TYPE_CODE DEFAULT_REC_RATE_CODE OFFSET_TAX OFFSET_STATUS_CODE OFFSET_TAX_RATE_CODE RECOVERY_RULE_CODE DEF_REC_SETTLEMENT_OPTION_CODE VAT_TRANSACTION_TYPE_CODE ADJ_FOR_ADHOC_AMT_CODE ALLOW_ADHOC_TAX_RATE_FLAG TAX_CLASS SOURCE_ID TAXABLE_BASIS_FORMULA_CODE INCLUSIVE_TAX_FLAG TAX_INCLUSIVE_OVERRIDE_FLAG ALLOW_EXEMPTIONS_FLAG ALLOW_EXCEPTIONS_FLAG DESCRIPTION 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 SUBSCRIPTION_LEVEL_CODE SDCO_ID SDEFF_FROM SDEFF_TO ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 INPUT_IC_AP_TAX_RATE_CODE

Query

SQL_Statement

SELECT a.ROWID ROW_ID, a.TAX_RATE_ID, a.TAX_RATE_CODE, a.CONTENT_OWNER_ID, a.EFFECTIVE_FROM, a.EFFECTIVE_TO, a.TAX_REGIME_CODE, a.TAX, a.TAX_STATUS_CODE, a.SCHEDULE_BASED_RATE_FLAG, a.RATE_TYPE_CODE, a.PERCENTAGE_RATE, a.QUANTITY_RATE, a.UOM_CODE, a.TAX_JURISDICTION_CODE, a.RECOVERY_TYPE_CODE, a.ACTIVE_FLAG, a.DEFAULT_RATE_FLAG, a.DEFAULT_FLG_EFFECTIVE_FROM, a.DEFAULT_FLG_EFFECTIVE_TO, a.DEFAULT_REC_TYPE_CODE, a.DEFAULT_REC_RATE_CODE, a.OFFSET_TAX, a.OFFSET_STATUS_CODE, a.OFFSET_TAX_RATE_CODE, a.RECOVERY_RULE_CODE, a.DEF_REC_SETTLEMENT_OPTION_CODE, a.VAT_TRANSACTION_TYPE_CODE, a.ADJ_FOR_ADHOC_AMT_CODE, a.ALLOW_ADHOC_TAX_RATE_FLAG, a.TAX_CLASS, a.SOURCE_ID, a.TAXABLE_BASIS_FORMULA_CODE, a.INCLUSIVE_TAX_FLAG, a.TAX_INCLUSIVE_OVERRIDE_FLAG, a.ALLOW_EXEMPTIONS_FLAG, a.ALLOW_EXCEPTIONS_FLAG, tl.DESCRIPTION, a.OBJECT_VERSION_NUMBER, a.RECORD_TYPE_CODE, 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.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.ATTRIBUTE_NUMBER1, a.ATTRIBUTE_NUMBER2, a.ATTRIBUTE_NUMBER3, a.ATTRIBUTE_NUMBER4, a.ATTRIBUTE_NUMBER5, a.ATTRIBUTE_DATE1, a.ATTRIBUTE_DATE2, a.ATTRIBUTE_DATE3, a.ATTRIBUTE_DATE4, a.ATTRIBUTE_DATE5, a.INPUT_IC_AP_TAX_RATE_CODE FROM ZX_RATES_B a, ZX_SUBSCRIPTION_DETAILS sd ,ZX_SUBSCRIPTION_OPTIONS so ,ZX_RATES_TL tl 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' AND a.TAX_RATE_ID = tl.TAX_RATE_ID AND tl.LANGUAGE = USERENV('LANG') ORDER BY sd.VIEW_OPTIONS_CODE