[Home] [Help]
View: ZX_MCO_EO_FORMULA_V
View Text
SELECT
ZFB.ROWID AS ROW_ID
,
ZFB.LAST_UPDATE_DATE
,
ZFB.LAST_UPDATE_LOGIN
,
ZFB.REQUEST_ID
,
ZFB.PROGRAM_APPLICATION_ID
,
ZFB.PROGRAM_ID
,
ZFB.PROGRAM_LOGIN_ID
,
ZFB.CONTENT_OWNER_ID
,
ZFB.FORMULA_TYPE_CODE
,
ZFB.FORMULA_CODE
,
ZFB.TAX_REGIME_CODE
,
ZFB.TAX
,
ZFB.EFFECTIVE_FROM
,
ZFB.EFFECTIVE_TO
,
ZFB.ENABLED_FLAG
,
ZFB.TAXABLE_BASIS_TYPE_CODE
,
ZFB.RECORD_TYPE_CODE
,
ZFB.BASE_RATE_MODIFIER
,
ZFB.CASH_DISCOUNT_APPL_FLAG
,
ZFB.CREATION_DATE
,
ZFB.LAST_UPDATED_BY
,
ZFB.FORMULA_ID
,
ZFB.CREATED_BY
,
ZFB.VOLUME_DISCOUNT_APPL_FLAG
,
ZFB.TRADING_DISCOUNT_APPL_FLAG
,
ZFB.TRANSFER_CHARGE_APPL_FLAG
,
ZFB.TRANSPORT_CHARGE_APPL_FLAG
,
ZFB.INSURANCE_CHARGE_APPL_FLAG
,
ZFB.OTHER_CHARGE_APPL_FLAG
,
ZFB.ATTRIBUTE_CATEGORY
,
ZFB.ATTRIBUTE1
,
ZFB.ATTRIBUTE2
,
ZFB.ATTRIBUTE3
,
ZFB.ATTRIBUTE4
,
ZFB.ATTRIBUTE5
,
ZFB.ATTRIBUTE6
,
ZFB.ATTRIBUTE7
,
ZFB.ATTRIBUTE8
,
ZFB.ATTRIBUTE9
,
ZFB.ATTRIBUTE10
,
ZFB.ATTRIBUTE11
,
ZFB.ATTRIBUTE12
,
ZFB.ATTRIBUTE13
,
ZFB.ATTRIBUTE14
,
ZFB.ATTRIBUTE15
,
ZFB.ATTRIBUTE16
,
ZFB.ATTRIBUTE17
,
ZFB.ATTRIBUTE18
,
ZFB.ATTRIBUTE19
,
ZFB.ATTRIBUTE20
,
ZFB.OBJECT_VERSION_NUMBER
,
ZFT.FORMULA_NAME
,
ZFT.FORMULA_DESCRIPTION
,
ZFPOMV.PARTY_NAME AS CONTENT_OWNER_NAME
,
NVL(ZMCAV.UPDATE_ACCESS
, 'Y') AS UPDATE_ACCESS
,
NVL(ZMCAV.DUPLICATE_ACCESS
, 'Y') AS DUPLICATE_ACCESS
FROM ZX_FORMULA_B ZFB
,
ZX_FORMULA_TL ZFT
,
ZX_FIRST_PARTY_ORGS_MOAC_V ZFPOMV
,
ZX_MCO_CHECK_ACCESS_V ZMCAV
WHERE ZFT.FORMULA_ID = ZFB.FORMULA_ID
AND ZFT.LANGUAGE = USERENV('LANG')
AND ZFPOMV.PARTY_TAX_PROFILE_ID = ZFB.CONTENT_OWNER_ID
AND ZMCAV.TAX_REGIME_CODE(+) = ZFB.TAX_REGIME_CODE
AND ZMCAV.PARENT_FIRST_PTY_ORG_ID(+) = ZFB.CONTENT_OWNER_ID