[Home] [Help] [Dependency Information]
Object Name: | OKE_OBJECT_ATTRIBUTES_B |
---|---|
Object Type: | TABLE |
Owner: | OKE |
FND Design Data: | OKE.OKE_OBJECT_ATTRIBUTES_B |
Subobject Name: | |
Status: | VALID |
OKE_OBJECT_ATTRIBUTES_B stores information about contract attributes. Those attributes can be grouped by assigning attribute groups and are used in security access rules and flow down matrix definitions.
Data is this table is seeded and is not user-definable.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKE_OBJECT_ATTRIBUTES_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
DATABASE_OBJECT_NAME
ATTRIBUTE_CODE |
OKE_OBJECT_ATTRIBUTES_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED |
DATABASE_OBJECT_NAME
ATTRIBUTE_GROUP_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DATABASE_OBJECT_NAME | VARCHAR2 | (30) | Yes | Identifier for the object to which this attribute belongs |
ATTRIBUTE_CODE | VARCHAR2 | (30) | Yes | Attribute code |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
DATATYPE | VARCHAR2 | (30) | Yes | Data type of attribute |
SECURABLE_FLAG | VARCHAR2 | (1) | Flag indicating whether attribute is securable | |
QUERYABLE_FLAG | VARCHAR2 | (1) | Flag indicating whether attribute can be queried | |
VIEW_COLUMN_FLAG | VARCHAR2 | (1) | Yes | Flag indicating whether attribute is a view column |
FORM_ITEM_FLAG | VARCHAR2 | (1) | Flag indicating whether attribute is a form item | |
ATTRIBUTE_GROUP_CODE | VARCHAR2 | (30) | Attribute group code | |
PARENT_ATTRIBUTE_CODE | VARCHAR2 | (30) | Internal code of the parent attribute |
Cut, paste (and edit) the following text to query this object:
SELECT DATABASE_OBJECT_NAME
, ATTRIBUTE_CODE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, DATATYPE
, SECURABLE_FLAG
, QUERYABLE_FLAG
, VIEW_COLUMN_FLAG
, FORM_ITEM_FLAG
, ATTRIBUTE_GROUP_CODE
, PARENT_ATTRIBUTE_CODE
FROM OKE.OKE_OBJECT_ATTRIBUTES_B;
OKE.OKE_OBJECT_ATTRIBUTES_B does not reference any database object
OKE.OKE_OBJECT_ATTRIBUTES_B is referenced by following:
|
|
|