[Home] [Help] [Dependency Information]
Object Name: | OKL_OPERANDS_B |
---|---|
Object Type: | TABLE |
Owner: | OKL |
FND Design Data: | OKL.OKL_OPERANDS_B |
Subobject Name: | |
Status: | VALID |
DEFINITION
Operands are variables within a formula
EXAMPLE
Formula Name : LP_NET_INVESTMENT_VALUE
String : Unbilled Receivables-Unearned Revenue+Unguaranteed Residual
In this example formula there are 3 operands represented by the labels
Unbilled Receivables
Unearned Revenue
Unguaranteed Residual
Each one of these operands can be either a Formula, Function or a Constant.
Depending on the type Formula Engine returns the value.
MISCELLANEOUS
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKL_OPD_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
NAME
VERSION ZD_EDITION_NAME |
OKL_OPERANDS_B_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ID
ZD_EDITION_NAME |
OPD_DSF_FK_I | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | DSF_ID |
OPD_FMA_FK_I | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | FMA_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Primary key column | |
NAME | VARCHAR2 | (150) | Yes | End date |
FMA_ID | NUMBER | Foreign key to table OKL_FORMULAE_B | ||
DSF_ID | NUMBER | Foreign key to table OKL_DATA_SRC_FNCTNS_B | ||
VERSION | VARCHAR2 | (24) | Yes | Version |
OPD_TYPE | VARCHAR2 | (30) | Yes | This represents the operand type. Possible values are CNST, FNCT, FMLA |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
ORG_ID | NUMBER | (15) | Operating unit identifier | |
START_DATE | DATE | Yes | Start date | |
SOURCE | VARCHAR2 | (150) | This holds the constant value of the operand. It will contain a value only when OPD_TYPE is CNST. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
END_DATE | DATE | End date | ||
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, NAME
, FMA_ID
, DSF_ID
, VERSION
, OPD_TYPE
, OBJECT_VERSION_NUMBER
, ORG_ID
, START_DATE
, SOURCE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, END_DATE
, ZD_EDITION_NAME
FROM OKL.OKL_OPERANDS_B;
OKL.OKL_OPERANDS_B does not reference any database object
OKL.OKL_OPERANDS_B is referenced by following:
|
|
|