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

VIEW: APPS.OKL_CONTEXT_GROUPS_V

Object Details
Object Name: OKL_CONTEXT_GROUPS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_CONTEXT_GROUPS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


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


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Identifier in the database
ID NUMBER
Yes Primary key column
OBJECT_VERSION_NUMBER NUMBER (9) Yes Column used for locking records during updates
SFWT_FLAG VARCHAR2 (3) Yes Column used by the translation batch program
NAME VARCHAR2 (150) Yes Standard who column
DESCRIPTION VARCHAR2 (1995)
User entered description
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
Query Text

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


SELECT ROW_ID
,      ID
,      OBJECT_VERSION_NUMBER
,      SFWT_FLAG
,      NAME
,      DESCRIPTION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.OKL_CONTEXT_GROUPS_V;

Dependencies

[top of page]

APPS.OKL_CONTEXT_GROUPS_V references the following:

SchemaAPPS
SynonymOKL_CONTEXT_GROUPS_B
SynonymOKL_CONTEXT_GROUPS_TL
APPS.OKL_CONTEXT_GROUPS_V is referenced by following:

SchemaAPPS
Package BodyOKL_CGM_PVT - show dependent code
PL/SQL PackageOKL_CGR_PVT - show dependent code
Package BodyOKL_CGR_PVT - show dependent code
PL/SQL PackageOKL_EXECUTE_FORMULA_PVT - show dependent code
Package BodyOKL_FMA_PVT - show dependent code
Package BodyOKL_FORMULAEVALUATE_PVT - show dependent code
PL/SQL PackageOKL_FORMULAVALIDATE_PUB - show dependent code
Package BodyOKL_FORMULAVALIDATE_PUB - show dependent code
Package BodyOKL_SETUPCONTEXTGROUPS_PVT - show dependent code