1. Tables and Views for Sales and Fusion Service
  2. CN_FORMULAS_ALL_VL

CN_FORMULAS_ALL_VL

Details

  • Schema: FUSION

  • Object owner: CN

  • Object type: VIEW

Columns

Name

FORMULA_ID

CALC_VARIABLE_ID

OBJECT_VERSION_NUMBER

ORG_ID

FORMULA_NAME

DISPLAY_NAME

DESCRIPTION

FORMULA_TYPE_CODE

FORMULA_STATUS

USE_EXT_FORMULA_FLAG

EXT_FORMULA_NAME

PACKAGE_NAME

START_DATE

END_DATE

OUTPUT_EXP_ID

GOAL_ID

PROCESS_TXN

ACCUMULATION_FLAG

ACCUMULATION_INTERVAL

ITD_FLAG

UNIT_OF_MEASURE

SPLIT_OPTION

REPORT_ENABLED_FLAG

RECALCULATION_REQUIRED_FLAG

NUMBER_DIM

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

INVALID_REASON_CODE

INVALID_REASON_TOKENS

ITD_RESET_INTERVAL

DELETE_FLAG

ATTRIBUTE_NUMBER1

ATTRIBUTE_NUMBER2

ATTRIBUTE_NUMBER3

ATTRIBUTE_NUMBER4

ATTRIBUTE_NUMBER5

ATTRIBUTE_NUMBER6

ATTRIBUTE_NUMBER7

ATTRIBUTE_NUMBER8

ATTRIBUTE_NUMBER9

ATTRIBUTE_NUMBER10

ATTRIBUTE_NUMBER11

ATTRIBUTE_NUMBER12

ATTRIBUTE_NUMBER13

ATTRIBUTE_NUMBER14

ATTRIBUTE_NUMBER15

ATTRIBUTE_DATE1

ATTRIBUTE_DATE2

ATTRIBUTE_DATE3

ATTRIBUTE_DATE4

ATTRIBUTE_DATE5

ATTRIBUTE_DATE6

ATTRIBUTE_DATE7

ATTRIBUTE_DATE8

ATTRIBUTE_DATE9

ATTRIBUTE_DATE10

ATTRIBUTE_DATE11

ATTRIBUTE_DATE12

ATTRIBUTE_DATE13

ATTRIBUTE_DATE14

ATTRIBUTE_DATE15

Query

SQL_Statement

SELECT

b.FORMULA_ID,

CALC_VARIABLE_ID,

b.OBJECT_VERSION_NUMBER,

b.ORG_ID,

FORMULA_NAME,

DISPLAY_NAME,

DESCRIPTION,

FORMULA_TYPE_CODE,

FORMULA_STATUS,

USE_EXT_FORMULA_FLAG,

EXT_FORMULA_NAME,

PACKAGE_NAME,

START_DATE,

END_DATE,

OUTPUT_EXP_ID,

GOAL_ID,

PROCESS_TXN,

ACCUMULATION_FLAG,

ACCUMULATION_INTERVAL,

ITD_FLAG,

UNIT_OF_MEASURE,

SPLIT_OPTION,

REPORT_ENABLED_FLAG,

RECALCULATION_REQUIRED_FLAG,

NUMBER_DIM,

b.CREATED_BY,

b.CREATION_DATE,

b.LAST_UPDATED_BY,

b.LAST_UPDATE_DATE,

b.LAST_UPDATE_LOGIN,

ATTRIBUTE_CATEGORY,

ATTRIBUTE1,

ATTRIBUTE2,

ATTRIBUTE3,

ATTRIBUTE4,

ATTRIBUTE5,

ATTRIBUTE6,

ATTRIBUTE7,

ATTRIBUTE8,

ATTRIBUTE9,

ATTRIBUTE10,

ATTRIBUTE11,

ATTRIBUTE12,

ATTRIBUTE13,

ATTRIBUTE14,

ATTRIBUTE15,

INVALID_REASON_CODE,

INVALID_REASON_TOKENS,

b.ITD_RESET_INTERVAL,

b.DELETE_FLAG,

b.ATTRIBUTE_NUMBER1,

b.ATTRIBUTE_NUMBER2,

b.ATTRIBUTE_NUMBER3,

b.ATTRIBUTE_NUMBER4,

b.ATTRIBUTE_NUMBER5,

b.ATTRIBUTE_NUMBER6,

b.ATTRIBUTE_NUMBER7,

b.ATTRIBUTE_NUMBER8,

b.ATTRIBUTE_NUMBER9,

b.ATTRIBUTE_NUMBER10,

b.ATTRIBUTE_NUMBER11,

b.ATTRIBUTE_NUMBER12,

b.ATTRIBUTE_NUMBER13,

b.ATTRIBUTE_NUMBER14,

b.ATTRIBUTE_NUMBER15,

b.ATTRIBUTE_DATE1,

b.ATTRIBUTE_DATE2,

b.ATTRIBUTE_DATE3,

b.ATTRIBUTE_DATE4,

b.ATTRIBUTE_DATE5,

b.ATTRIBUTE_DATE6,

b.ATTRIBUTE_DATE7,

b.ATTRIBUTE_DATE8,

b.ATTRIBUTE_DATE9,

b.ATTRIBUTE_DATE10,

b.ATTRIBUTE_DATE11,

b.ATTRIBUTE_DATE12,

b.ATTRIBUTE_DATE13,

b.ATTRIBUTE_DATE14,

b.ATTRIBUTE_DATE15

FROM

CN_FORMULAS_ALL_B b,

CN_FORMULAS_ALL_TL t

WHERE

b.FORMULA_ID = t.FORMULA_ID AND t.LANGUAGE = USERENV('LANG')