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

TABLE: FUN.FUN_RULE_PARAM_VALUES

Object Details
Object Name: FUN_RULE_PARAM_VALUES
Object Type: TABLE
Owner: FUN
FND Design Data: TableFUN.FUN_RULE_PARAM_VALUES
Subobject Name:
Status: VALID

Stores the multiple criteria parameter values that are used in evaluation of a criteria. If a criteria uses a parameters that is based on an independent or table based value set, the parameter value is compared against multiple values to see if the parameter value is or is not in this list.

Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FUN_RULE_PARAM_VALUES_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnRULE_PARAM_VALUE_ID
FUN_RULE_PARAM_VALUES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnCRITERIA_ID
Columns
Name Datatype Length Mandatory Comments
RULE_PARAM_VALUE_ID NUMBER (15) Yes Rule parameter value identifier
CRITERIA_ID NUMBER (15) Yes Criteria identifier
RULE_DETAIL_ID NUMBER (15) Yes Rule detail identifier
PARAM_VALUE VARCHAR2 (1024)
Parameter value
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
OBJECT_VERSION_NUMBER NUMBER
Yes Used for locking purposes
Query Text

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


SELECT RULE_PARAM_VALUE_ID
,      CRITERIA_ID
,      RULE_DETAIL_ID
,      PARAM_VALUE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
FROM FUN.FUN_RULE_PARAM_VALUES;

Dependencies

[top of page]

FUN.FUN_RULE_PARAM_VALUES does not reference any database object

FUN.FUN_RULE_PARAM_VALUES is referenced by following:

SchemaAPPS
SynonymFUN_RULE_PARAM_VALUES