[Home] [Help] [Dependency Information]
Object Name: | OKC_RG_ROLE_DEFS |
---|---|
Object Type: | TABLE |
Owner: | OKC |
FND Design Data: | OKC.OKC_RG_ROLE_DEFS |
Subobject Name: | |
Status: | VALID |
A RULE GROUP brings together a number of RULES which collectively define a business function. Such a function may be thought of as having a party which performs the function and another party upon whom the function is performed. For example, in the function "billing" one party is doing the billing, and the other party is being billed. In Contracts, the "doer" is called the subject of the rule group, and the "doee" is called the object.
OKC_RG_ROLE_DEFS defines which roles can act as subject or object for a rule group for a contract subclass.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKC_RG_ROLE_DEFS_U1 | NORMAL | UNIQUE | APPS_TS_SEED | ID |
OKC_RG_ROLE_DEFS_U2 | NORMAL | UNIQUE | APPS_TS_SEED |
SRD_ID
SRE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Primary key column. | |
SRD_ID | NUMBER | Yes | Foreign key to OKC_SUBCLASS_RG_DEFS. | |
SRE_ID | NUMBER | Yes | Foreign key to OKC_SUBCLASS_ROLES. | |
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. |
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. | |
SUBJECT_OBJECT_FLAG | VARCHAR2 | (3) | Yes | Indicates whether the mode is considered active or passive. |
OPTIONAL_YN | VARCHAR2 | (3) | Indicates if the role is optional for this rule group. | |
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 | ||
ACCESS_LEVEL | VARCHAR2 | (1) | Indicates the protection level for the record. |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, SRD_ID
, SRE_ID
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, SUBJECT_OBJECT_FLAG
, OPTIONAL_YN
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SECURITY_GROUP_ID
, ACCESS_LEVEL
FROM OKC.OKC_RG_ROLE_DEFS;
OKC.OKC_RG_ROLE_DEFS does not reference any database object
OKC.OKC_RG_ROLE_DEFS is referenced by following:
|
|
|