ZX_MCO_LV_FORMULA_V

Details

• Schema: FUSION

• Object owner: FND

• Object type: VIEW

Columns

Name

ROW_ID LAST_UPDATE_DATE LAST_UPDATE_LOGIN REQUEST_ID PROGRAM_APP_NAME PROGRAM_NAME PROGRAM_LOGIN_ID CONTENT_OWNER_ID FORMULA_TYPE_CODE FORMULA_CODE TAX_REGIME_CODE TAX EFFECTIVE_FROM EFFECTIVE_TO ENABLED_FLAG TAXABLE_BASIS_TYPE_CODE RECORD_TYPE_CODE BASE_RATE_MODIFIER CASH_DISCOUNT_APPL_FLAG CREATION_DATE LAST_UPDATED_BY FORMULA_ID CREATED_BY VOLUME_DISCOUNT_APPL_FLAG TRADING_DISCOUNT_APPL_FLAG TRANSFER_CHARGE_APPL_FLAG TRANSPORT_CHARGE_APPL_FLAG INSURANCE_CHARGE_APPL_FLAG OTHER_CHARGE_APPL_FLAG ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20 FORMULA_NAME FORMULA_DESCRIPTION

Query

SQL_Statement

SELECT DISTINCT ZFB.ROWID AS ROW_ID, ZFB.LAST_UPDATE_DATE, ZFB.LAST_UPDATE_LOGIN, ZFB.REQUEST_ID, ZFB.PROGRAM_APP_NAME, ZFB.PROGRAM_NAME, 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 ZX_PROFILE.VALUE('ZX_GCO_WRITE_ACCESS') = 'Y' ) OR (ZSD.FIRST_PTY_ORG_ID <> -99))