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

TABLE: ONT.OE_AK_OBJ_WF_ITEMS

Object Details
Object Name: OE_AK_OBJ_WF_ITEMS
Object Type: TABLE
Owner: ONT
FND Design Data: TableONT.OE_AK_OBJ_WF_ITEMS
Subobject Name:
Status: VALID


Extension table to AK Object Attributes that is used to store additional data


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
DATABASE_OBJECT_NAME VARCHAR2 (30) Yes Database object associated with this entity in AK dictionary
ITEM_TYPE VARCHAR2 (30) Yes Workflow item type associated with this object.
ITEMKEY_COLUMN1 VARCHAR2 (30)
Database column on the object that is used in the WF itemkey
ITEMKEY_COLUMN2 VARCHAR2 (30)
Database column on the object that is used in the WF itemkey
ITEMKEY_COLUMN3 VARCHAR2 (30)
Database column on the object that is used in the WF itemkey
ITEMKEY_COLUMN4 VARCHAR2 (30)
Database column on the object that is used in the WF itemkey
ITEMKEY_COLUMN5 VARCHAR2 (30)
Database column on the object that is used in the WF itemkey
ITEMKEY_DELIMITER VARCHAR2 (1)
Delimiter used in concatenating the columns for the WF itemkey if more than one itemkey column
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
Query Text

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


SELECT DATABASE_OBJECT_NAME
,      ITEM_TYPE
,      ITEMKEY_COLUMN1
,      ITEMKEY_COLUMN2
,      ITEMKEY_COLUMN3
,      ITEMKEY_COLUMN4
,      ITEMKEY_COLUMN5
,      ITEMKEY_DELIMITER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM ONT.OE_AK_OBJ_WF_ITEMS;

Dependencies

[top of page]

ONT.OE_AK_OBJ_WF_ITEMS does not reference any database object

ONT.OE_AK_OBJ_WF_ITEMS is referenced by following:

SchemaAPPS
SynonymOE_AK_OBJ_WF_ITEMS