ZX_MCO_EO_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 OBJECT_VERSION_NUMBER FORMULA_NAME FORMULA_DESCRIPTION CONTENT_OWNER_NAME UPDATE_ACCESS DUPLICATE_ACCESS

Query

SQL_Statement

SELECT 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, 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