[Home] [Help]
View: ZX_MCO_LV_RATES_V
View Text
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_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
,
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 FND_PROFILE.VALUE('ZX_GCO_WRITE_ACCESS') = 'Y'
) OR (ZSD.FIRST_PTY_ORG_ID <> -99))
ORDER BY ZSD.VIEW_OPTIONS_CODE