DBA Data[Home] [Help] [Dependency Information]


TABLE: OKL.OKL_CONTEXT_GROUPS_B

Object Details
Object Name: OKL_CONTEXT_GROUPS_B
Object Type: TABLE
Owner: OKL
FND Design Data: TableOKL.OKL_CONTEXT_GROUPS_B
Subobject Name:
Status: VALID


DEFINITION
A Group of parameters required by formula in order for the operand functions to recognise context and return the appropriate data
EXAMPLE
MISCELLANEOUS
Any FORMULA may be evaluated at many different places within the application code. Because the FORMULA is user modifiable, the caller cannot know which OPERAND therefore which FUNCTION are used within the FORMULA, therefore cannot know which context parameters must be provided.
Formula calling code may be enabled with only a certain set of routines to get context values in this case the formula is associated with a context group which formulae authoring will check to see if users are trying to use operands which require contexts which the formula does not recognise.
It may be all formula calling code is enabled with all routines to get any context value in the "universe" of possible contexts, thus when the formula is evaluated, it can find which contexts are necessary by searching the operands currently defined for that formula


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKL_CGR_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnNAME
ColumnZD_EDITION_NAME
OKL_CONTEXT_GROUPS_B_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnID
ColumnZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Yes Primary key column
NAME VARCHAR2 (150) Yes Standard who column
OBJECT_VERSION_NUMBER NUMBER (9) Yes Column used for locking records during updates
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
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ID
,      NAME
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ZD_EDITION_NAME
FROM OKL.OKL_CONTEXT_GROUPS_B;

Dependencies

[top of page]

OKL.OKL_CONTEXT_GROUPS_B does not reference any database object

OKL.OKL_CONTEXT_GROUPS_B is referenced by following:

SchemaOKL
ViewOKL_CONTEXT_GROUPS_B#