[Home] [Help] [Dependency Information]
Object Name: | CN_CALC_FORMULAS_ALL |
---|---|
Object Type: | TABLE |
Owner: | CN |
FND Design Data: | CN.CN_CALC_FORMULAS_ALL |
Subobject Name: | |
Status: | VALID |
CN_CALC_FORMULAS contains information about calculation formula. You need one row
for each calculation formula defined.
CALC_FORMULA_ID is the system generated primary key and is invisible to user.
Name is the user defined value you use to uniquely identify the calculation formula.
Each row contains the calculation rules and output portion for this formula.
The input(s) portion is in CN_FOMULA_INPUTS and rate table assignment information
is in CN_RT_FORMULA_ASGNS.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CN_CALC_FORMULAS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
CALC_FORMULA_ID
ORG_ID |
CN_CALC_FORMULAS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
NAME
ORG_ID |
SYS_IL0000097159C00007$$ | LOB | UNIQUE | APPS_TS_TX_DATA | |
SYS_IL0000097159C00008$$ | LOB | UNIQUE | APPS_TS_TX_DATA | |
SYS_IL0000097159C00009$$ | LOB | UNIQUE | APPS_TS_TX_DATA | |
SYS_IL0000097159C00046$$ | LOB | UNIQUE | APPS_TS_TX_DATA | |
SYS_IL0000097159C00047$$ | LOB | UNIQUE | APPS_TS_TX_DATA | |
SYS_IL0000097159C00048$$ | LOB | UNIQUE | APPS_TS_TX_DATA | |
SYS_IL0000097159C00049$$ | LOB | UNIQUE | APPS_TS_TX_DATA | |
CN_CALC_FORMULAS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PERF_MEASURE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORG_ID | NUMBER | (15) | Organization identifier | |
CALC_FORMULA_ID | NUMBER | (15) | Yes | Primary Key |
NAME | VARCHAR2 | (30) | Yes | Formula name |
DESCRIPTION | VARCHAR2 | (80) | Description | |
COMMENT_LONG | VARCHAR2 | (1900) | Comment | |
FORMULA_STATUS | VARCHAR2 | (30) | Fomula status | |
OUTPUT_DISP | CLOB | (4000) | Display for Output | |
OUTPUT_SQL_SELECT | CLOB | (4000) | output 'select' portion | |
OUTPUT_SQL_FROM | CLOB | (4000) | output 'from' portion | |
OUTPUT_STATUS | VARCHAR2 | (30) | Status 'VALID'/'INVALID' | |
SPLIT_FLAG | VARCHAR2 | (1) | Split Flag | |
CUMULATIVE_FLAG | VARCHAR2 | (1) | Cumulative Flag | |
ITD_FLAG | VARCHAR2 | (1) | Interval-to-date Flag | |
TRX_GROUP_CODE | VARCHAR2 | (30) | Group by/ Individually | |
PERF_MEASURE_ID | NUMBER | (15) | performance accumulation | |
THRESHOLD_ALL_TIER_FLAG | VARCHAR2 | (1) | use threshold across all tiers | |
THRESHOLD_FIRST_TIER_FLAG | VARCHAR2 | (1) | use threshold across first tier | |
NUMBER_DIM | NUMBER | (15) | number of dimensions | |
FORMULA_TYPE | VARCHAR2 | (15) | 'B' : used for bonus calculation only. 'C': used for regular calculation only. 'BC': used for both types of calculations. | |
THRESHOLDS | VARCHAR2 | (1) | Thresholds | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
INPUT_DISP | VARCHAR2 | (1900) | Input display | |
INPUT_SQL_SELECT | VARCHAR2 | (1900) | input 'select' portion | |
INPUT_SQL_FROM | VARCHAR2 | (1900) | input 'from' portion | |
INPUT_STATUS | VARCHAR2 | (30) | Input Status | |
PIPED_OUTPUT_SELECT | CLOB | (4000) | Piped Output Select Statement | |
PIPED_OUTPUT_FROM | CLOB | (4000) | Piped output from clause | |
PIPED_OUTPUT_DISP | CLOB | (4000) | Piped output display | |
PIPED_OUTPUT_SQL | CLOB | (4000) | Piped Output SQL Statement | |
OUTPUT_EXP_ID | NUMBER | (15) | The foreign key to CN_CALC_SQL_EXPS_ALL. | |
F_OUTPUT_EXP_ID | NUMBER | (15) | The foreign key to CN_CALC_SQL_EXPS_ALL. | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | This column is used for locking purposes | |
MODELING_FLAG | VARCHAR2 | (1) | Yes | Modeling Flag |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
Cut, paste (and edit) the following text to query this object:
SELECT ORG_ID
, CALC_FORMULA_ID
, NAME
, DESCRIPTION
, COMMENT_LONG
, FORMULA_STATUS
, OUTPUT_DISP
, OUTPUT_SQL_SELECT
, OUTPUT_SQL_FROM
, OUTPUT_STATUS
, SPLIT_FLAG
, CUMULATIVE_FLAG
, ITD_FLAG
, TRX_GROUP_CODE
, PERF_MEASURE_ID
, THRESHOLD_ALL_TIER_FLAG
, THRESHOLD_FIRST_TIER_FLAG
, NUMBER_DIM
, FORMULA_TYPE
, THRESHOLDS
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, INPUT_DISP
, INPUT_SQL_SELECT
, INPUT_SQL_FROM
, INPUT_STATUS
, PIPED_OUTPUT_SELECT
, PIPED_OUTPUT_FROM
, PIPED_OUTPUT_DISP
, PIPED_OUTPUT_SQL
, OUTPUT_EXP_ID
, F_OUTPUT_EXP_ID
, OBJECT_VERSION_NUMBER
, MODELING_FLAG
, SECURITY_GROUP_ID
FROM CN.CN_CALC_FORMULAS_ALL;
CN.CN_CALC_FORMULAS_ALL does not reference any database object
CN.CN_CALC_FORMULAS_ALL is referenced by following:
|
|
|