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

TABLE: OKI.OKI_RULE_MAPS

Object Details
Object Name: OKI_RULE_MAPS
Object Type: TABLE
Owner: OKI
FND Design Data: TableOKI.OKI_RULE_MAPS
Subobject Name:
Status: VALID


RULE MAP maps a rule group/rule pair, within a subclass (category) to a specific reporting use.
In general, rule types are shared across contract subclasses, but not always. Rule groups are not always shared. To use the same rule across subclasses it is necessary to know where to find it. When looking for the revenue forecast rule, for example, RULE MAP will supply the correct rule group and rule for each subclass.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKI_RULE_MAPS_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnRULE_USE
ColumnSCS_CODE
Columns
Name Datatype Length Mandatory Comments
RULE_USE VARCHAR2 (10) Yes The use of the rule, such as BILLING or SHIPPING.
SCS_CODE VARCHAR2 (30) Yes The category (sub-class) code for the contract.
RGD_CODE VARCHAR2 (30) Yes The rule group code.
RDF_CODE VARCHAR2 (30) Yes The address province, if appropriate.
OBJECT_VERSION_NUMBER NUMBER (9) Yes A number used to track the version of the row.
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.
SECURITY_GROUP_ID NUMBER

Used for application hosting.
Query Text

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


SELECT RULE_USE
,      SCS_CODE
,      RGD_CODE
,      RDF_CODE
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
FROM OKI.OKI_RULE_MAPS;

Dependencies

[top of page]

OKI.OKI_RULE_MAPS does not reference any database object

OKI.OKI_RULE_MAPS is referenced by following:

SchemaAPPS
SynonymOKI_RULE_MAPS