View: ZX_MCO_LV_FORMULA_V

Product:	FND - Application Object Library
Description:
Implementation/DBA Data:	APPS.ZX_MCO_LV_FORMULA_V

View Text

SELECT DISTINCT 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
, ZFT.FORMULA_NAME
, ZFT.FORMULA_DESCRIPTION FROM ZX_FORMULA_B ZFB
, ZX_FORMULA_TL ZFT
, ZX_SUBSCRIPTION_DETAILS ZSD
, ZX_FIRST_PARTY_ORGS_MOAC_V ZFPOMV WHERE ZFT.FORMULA_ID = ZFB.FORMULA_ID AND ZFT.LANGUAGE = USERENV('LANG') AND ZSD.PARENT_FIRST_PTY_ORG_ID(+) = ZFB.CONTENT_OWNER_ID AND ZSD.TAX_REGIME_CODE(+) = ZFB.TAX_REGIME_CODE AND ZFPOMV.PARTY_TAX_PROFILE_ID = ZFB.CONTENT_OWNER_ID AND (ZSD.VIEW_OPTIONS_CODE IS NULL OR ZSD.VIEW_OPTIONS_CODE IN ('VFC'
, 'VFR')) AND (ZSD.FIRST_PTY_ORG_ID IS NULL OR (ZSD.FIRST_PTY_ORG_ID = -99
AND FND_PROFILE.VALUE('ZX_GCO_WRITE_ACCESS') = 'Y' ) OR (ZSD.FIRST_PTY_ORG_ID <> -99))