ZX_MCO_LV_RATES

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 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 VIEW_OPTIONS_CODE

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

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

VIEW_OPTIONS_CODE

Query

SQL_Statement
SELECT DISTINCT ZRB.ROWID AS ROW_ID, ZRB.TAX_RATE_ID, ZRB.TAX_RATE_CODE, ZSD.FIRST_PTY_ORG_ID CONTENT_OWNER_ID, ZRB.EFFECTIVE_FROM, ZRB.EFFECTIVE_TO, ZRB.TAX_REGIME_CODE, ZRB.TAX, ZRB.TAX_STATUS_CODE, ZRB.SCHEDULE_BASED_RATE_FLAG, ZRB.RATE_TYPE_CODE, ZRB.PERCENTAGE_RATE, ZRB.QUANTITY_RATE, ZRB.UOM_CODE, ZRB.TAX_JURISDICTION_CODE, ZRB.RECOVERY_TYPE_CODE, ZRB.ACTIVE_FLAG, ZRB.DEFAULT_RATE_FLAG, ZRB.DEFAULT_FLG_EFFECTIVE_FROM, ZRB.DEFAULT_FLG_EFFECTIVE_TO, ZRB.DEFAULT_REC_TYPE_CODE, ZRB.DEFAULT_REC_RATE_CODE, ZRB.OFFSET_TAX, ZRB.OFFSET_STATUS_CODE, ZRB.OFFSET_TAX_RATE_CODE, ZRB.RECOVERY_RULE_CODE, ZRB.DEF_REC_SETTLEMENT_OPTION_CODE, ZRB.VAT_TRANSACTION_TYPE_CODE, ZRB.ADJ_FOR_ADHOC_AMT_CODE, ZRB.ALLOW_ADHOC_TAX_RATE_FLAG, ZRB.TAX_CLASS, ZRB.SOURCE_ID, ZRB.TAXABLE_BASIS_FORMULA_CODE, ZRB.INCLUSIVE_TAX_FLAG, ZRB.TAX_INCLUSIVE_OVERRIDE_FLAG, ZRB.ALLOW_EXEMPTIONS_FLAG, ZRB.ALLOW_EXCEPTIONS_FLAG, ZRT.DESCRIPTION, ZRB.RECORD_TYPE_CODE, ZRB.CREATED_BY, ZRB.CREATION_DATE, ZRB.LAST_UPDATED_BY, ZRB.LAST_UPDATE_DATE, ZRB.LAST_UPDATE_LOGIN, ZRB.REQUEST_ID, ZRB.PROGRAM_APP_NAME, ZRB.PROGRAM_NAME, ZRB.PROGRAM_LOGIN_ID, ZRB.ATTRIBUTE1, ZRB.ATTRIBUTE2, ZRB.ATTRIBUTE3, ZRB.ATTRIBUTE4, ZRB.ATTRIBUTE5, ZRB.ATTRIBUTE6, ZRB.ATTRIBUTE7, ZRB.ATTRIBUTE8, ZRB.ATTRIBUTE9, ZRB.ATTRIBUTE10, ZRB.ATTRIBUTE11, ZRB.ATTRIBUTE12, ZRB.ATTRIBUTE13, ZRB.ATTRIBUTE14, ZRB.ATTRIBUTE15, ZRB.ATTRIBUTE_CATEGORY, ZRT.TAX_RATE_NAME, ZSD.VIEW_OPTIONS_CODE FROM ZX_RATES_B ZRB, ZX_RATES_TL ZRT, ZX_SUBSCRIPTION_DETAILS ZSD, ZX_FIRST_PARTY_ORGS_MOAC_V ZFPOMV WHERE ZRT.TAX_RATE_ID = ZRB.TAX_RATE_ID AND ZRT.LANGUAGE = USERENV('LANG') AND ZSD.PARENT_FIRST_PTY_ORG_ID = ZRB.CONTENT_OWNER_ID AND ZSD.TAX_REGIME_CODE = ZRB.TAX_REGIME_CODE AND ZFPOMV.PARTY_TAX_PROFILE_ID = ZRB.CONTENT_OWNER_ID AND ZSD.VIEW_OPTIONS_CODE IN ('VFC','VFR') AND ((ZSD.FIRST_PTY_ORG_ID = -99 AND ZX_PROFILE.VALUE('ZX_GCO_WRITE_ACCESS') = 'Y' ) OR (ZSD.FIRST_PTY_ORG_ID <> -99)) ORDER BY ZSD.VIEW_OPTIONS_CODE

SQL_Statement

SELECT DISTINCT

ZRB.ROWID AS ROW_ID,

ZRB.TAX_RATE_ID,

ZRB.TAX_RATE_CODE,

ZSD.FIRST_PTY_ORG_ID CONTENT_OWNER_ID,

ZRB.EFFECTIVE_FROM,

ZRB.EFFECTIVE_TO,

ZRB.TAX_REGIME_CODE,

ZRB.TAX,

ZRB.TAX_STATUS_CODE,

ZRB.SCHEDULE_BASED_RATE_FLAG,

ZRB.RATE_TYPE_CODE,

ZRB.PERCENTAGE_RATE,

ZRB.QUANTITY_RATE,

ZRB.UOM_CODE,

ZRB.TAX_JURISDICTION_CODE,

ZRB.RECOVERY_TYPE_CODE,

ZRB.ACTIVE_FLAG,

ZRB.DEFAULT_RATE_FLAG,

ZRB.DEFAULT_FLG_EFFECTIVE_FROM,

ZRB.DEFAULT_FLG_EFFECTIVE_TO,

ZRB.DEFAULT_REC_TYPE_CODE,

ZRB.DEFAULT_REC_RATE_CODE,

ZRB.OFFSET_TAX,

ZRB.OFFSET_STATUS_CODE,

ZRB.OFFSET_TAX_RATE_CODE,

ZRB.RECOVERY_RULE_CODE,

ZRB.DEF_REC_SETTLEMENT_OPTION_CODE,

ZRB.VAT_TRANSACTION_TYPE_CODE,

ZRB.ADJ_FOR_ADHOC_AMT_CODE,

ZRB.ALLOW_ADHOC_TAX_RATE_FLAG,

ZRB.TAX_CLASS,

ZRB.SOURCE_ID,

ZRB.TAXABLE_BASIS_FORMULA_CODE,

ZRB.INCLUSIVE_TAX_FLAG,

ZRB.TAX_INCLUSIVE_OVERRIDE_FLAG,

ZRB.ALLOW_EXEMPTIONS_FLAG,

ZRB.ALLOW_EXCEPTIONS_FLAG,

ZRT.DESCRIPTION,

ZRB.RECORD_TYPE_CODE,

ZRB.CREATED_BY,

ZRB.CREATION_DATE,

ZRB.LAST_UPDATED_BY,

ZRB.LAST_UPDATE_DATE,

ZRB.LAST_UPDATE_LOGIN,

ZRB.REQUEST_ID,

ZRB.PROGRAM_APP_NAME,

ZRB.PROGRAM_NAME,

ZRB.PROGRAM_LOGIN_ID,

ZRB.ATTRIBUTE1,

ZRB.ATTRIBUTE2,

ZRB.ATTRIBUTE3,

ZRB.ATTRIBUTE4,

ZRB.ATTRIBUTE5,

ZRB.ATTRIBUTE6,

ZRB.ATTRIBUTE7,

ZRB.ATTRIBUTE8,

ZRB.ATTRIBUTE9,

ZRB.ATTRIBUTE10,

ZRB.ATTRIBUTE11,

ZRB.ATTRIBUTE12,

ZRB.ATTRIBUTE13,

ZRB.ATTRIBUTE14,

ZRB.ATTRIBUTE15,

ZRB.ATTRIBUTE_CATEGORY,

ZRT.TAX_RATE_NAME,

ZSD.VIEW_OPTIONS_CODE

FROM ZX_RATES_B ZRB,

ZX_RATES_TL ZRT,

ZX_SUBSCRIPTION_DETAILS ZSD,

ZX_FIRST_PARTY_ORGS_MOAC_V ZFPOMV

WHERE ZRT.TAX_RATE_ID = ZRB.TAX_RATE_ID

AND ZRT.LANGUAGE = USERENV('LANG')

AND ZSD.PARENT_FIRST_PTY_ORG_ID = ZRB.CONTENT_OWNER_ID

AND ZSD.TAX_REGIME_CODE = ZRB.TAX_REGIME_CODE

AND ZFPOMV.PARTY_TAX_PROFILE_ID = ZRB.CONTENT_OWNER_ID

AND ZSD.VIEW_OPTIONS_CODE IN ('VFC','VFR')

AND ((ZSD.FIRST_PTY_ORG_ID = -99

AND ZX_PROFILE.VALUE('ZX_GCO_WRITE_ACCESS') = 'Y'

) OR (ZSD.FIRST_PTY_ORG_ID <> -99))

ORDER BY ZSD.VIEW_OPTIONS_CODE