ZX_FORMULA_VL

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 PACKING_CHARGE_APPL_FLAG APPLY_UNIT_PRC_THRSHLD_FLAG APPLY_TXBS_VAL_ADD_FLAG

Query

SQL_Statement

SELECT B.ROWID ROW_ID ,B.LAST_UPDATE_DATE ,B.LAST_UPDATE_LOGIN ,B.REQUEST_ID ,B.PROGRAM_APP_NAME ,B.PROGRAM_NAME ,B.PROGRAM_LOGIN_ID ,B.CONTENT_OWNER_ID ,B.FORMULA_TYPE_CODE ,B.FORMULA_CODE ,B.TAX_REGIME_CODE ,B.TAX ,B.EFFECTIVE_FROM ,B.EFFECTIVE_TO ,B.ENABLED_FLAG ,B.TAXABLE_BASIS_TYPE_CODE ,B.RECORD_TYPE_CODE ,B.BASE_RATE_MODIFIER ,B.CASH_DISCOUNT_APPL_FLAG ,B.CREATION_DATE ,B.LAST_UPDATED_BY ,B.FORMULA_ID ,B.CREATED_BY ,B.VOLUME_DISCOUNT_APPL_FLAG ,B.TRADING_DISCOUNT_APPL_FLAG ,B.TRANSFER_CHARGE_APPL_FLAG ,B.TRANSPORT_CHARGE_APPL_FLAG ,B.INSURANCE_CHARGE_APPL_FLAG ,B.OTHER_CHARGE_APPL_FLAG ,B.ATTRIBUTE_CATEGORY ,B.ATTRIBUTE1 ,B.ATTRIBUTE2 ,B.ATTRIBUTE3 ,B.ATTRIBUTE4 ,B.ATTRIBUTE5 ,B.ATTRIBUTE6 ,B.ATTRIBUTE7 ,B.ATTRIBUTE8 ,B.ATTRIBUTE9 ,B.ATTRIBUTE10 ,B.ATTRIBUTE11 ,B.ATTRIBUTE12 ,B.ATTRIBUTE13 ,B.ATTRIBUTE14 ,B.ATTRIBUTE15 ,B.ATTRIBUTE16 ,B.ATTRIBUTE17 ,B.ATTRIBUTE18 ,B.ATTRIBUTE19 ,B.ATTRIBUTE20 ,B.OBJECT_VERSION_NUMBER ,T.FORMULA_NAME ,T.FORMULA_DESCRIPTION ,B.PACKING_CHARGE_APPL_FLAG ,B.APPLY_UNIT_PRC_THRSHLD_FLAG ,B.APPLY_TXBS_VAL_ADD_FLAG FROM ZX_FORMULA_TL T, ZX_FORMULA_B B WHERE B.FORMULA_ID = T.FORMULA_ID AND T.LANGUAGE = userenv('LANG')