ZX_RATES_VL

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