[Home] [Help] [Dependency Information]
Object Name: | OKC_RULE_GROUPS_B |
---|---|
Object Type: | TABLE |
Owner: | OKC |
FND Design Data: | OKC.OKC_RULE_GROUPS_B |
Subobject Name: | |
Status: | VALID |
A RULE GROUP is a collection of RULES needed to inform an automated process about a business function.
There are two types of rule groups: Contract and Standard.
Contract rule groups are instantiated in a contract. A contract rule group may be associated with either a contract header or a contract line. If associated with a header, the rule group pertains to the entire contract. If associated with a line, it pertains to that line and its sublines.
Standard rule groups are associated with STANDARD ARTICLE SETS. Standard rule groups allow users to predefine rule groups and rules that will be copied into a contract when that standard article set is copied or referenced into a contract.
If created in a subcontract, the rule group may refer back to the rule group in the prime contract from whence it came, via the PARENT_RGP_ID foreign key.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKC_RULE_GROUPS_B_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ID |
OKC_RULE_GROUPS_B_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
DNZ_CHR_ID
CLE_ID |
OKC_RULE_GROUPS_B_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CLE_ID |
OKC_RULE_GROUPS_B_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PARENT_RGP_ID |
OKC_RULE_GROUPS_B_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SAT_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Primary key column. | |
RGD_CODE | VARCHAR2 | (30) | Yes | Rule groups code. |
CHR_ID | NUMBER | ID of the contract associated with the rule groups.. | ||
CLE_ID | NUMBER | ID of the contract line with which this rule group is associated. | ||
DNZ_CHR_ID | NUMBER | Contract ID. Denormalized for performance. | ||
PARENT_RGP_ID | NUMBER | ID of the parent rule group for this record. A rule group can be parent or child of another rule group.. | ||
SAT_CODE | VARCHAR2 | (30) | Standard Article Set code, for formatting standard article sets. | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed. |
RGP_TYPE | VARCHAR2 | (10) | Yes | RGP type. |
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. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | Descriptive flexfield category column. | |
ATTRIBUTE1 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE2 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE3 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE4 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE5 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE6 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE7 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE8 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE9 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE10 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE11 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE12 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE13 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE14 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE15 | VARCHAR2 | (450) | Descriptive flexfield column. | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, RGD_CODE
, CHR_ID
, CLE_ID
, DNZ_CHR_ID
, PARENT_RGP_ID
, SAT_CODE
, OBJECT_VERSION_NUMBER
, RGP_TYPE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SECURITY_GROUP_ID
FROM OKC.OKC_RULE_GROUPS_B;
OKC.OKC_RULE_GROUPS_B does not reference any database object
OKC.OKC_RULE_GROUPS_B is referenced by following:
|
|
|