[Home] [Help]
View: ZX_MCO_EO_RATES_V
View Text
(SELECT ZRB.ROWID AS ROW_ID
,
ZRB.TAX_RATE_ID
,
ZRB.TAX_RATE_CODE
,
ZRB.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.OBJECT_VERSION_NUMBER
,
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_APPLICATION_ID
,
ZRB.PROGRAM_ID
,
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
,
ZFPOMV.PARTY_NAME AS CONTENT_OWNER_NAME
,
ZMCAV.UPDATE_ACCESS
,
ZMCAV.DUPLICATE_ACCESS
FROM ZX_RATES_B ZRB
,
ZX_RATES_TL ZRT
,
ZX_FIRST_PARTY_ORGS_MOAC_V ZFPOMV
,
ZX_MCO_CHECK_ACCESS_V ZMCAV
WHERE ZRT.TAX_RATE_ID = ZRB.TAX_RATE_ID
AND ZRT.LANGUAGE = USERENV('LANG')
AND ZFPOMV.PARTY_TAX_PROFILE_ID = ZRB.CONTENT_OWNER_ID
AND ZMCAV.TAX_REGIME_CODE = ZRB.TAX_REGIME_CODE
AND ZMCAV.PARENT_FIRST_PTY_ORG_ID = ZRB.CONTENT_OWNER_ID
)
APPS.ZX_MCO_EO_RATES_V