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

TABLE: GMA.GMA_PROCDATA_WF

Object Details
Object Name: GMA_PROCDATA_WF
Object Type: TABLE
Owner: GMA
FND Design Data: TableGMA.GMA_PROCDATA_WF
Subobject Name:
Status: VALID


This table stores users process customizations data. This data determines the approval process behavior and is used by the API to determine if approval is required or not for a data set.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GMA_PROCDATA_WF_UK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnWF_ITEM_TYPE
ColumnPROCESS_NAME
ColumnCOLUMN_VALUE1
ColumnCOLUMN_VALUE2
ColumnCOLUMN_VALUE3
ColumnCOLUMN_VALUE4
ColumnCOLUMN_VALUE5
ColumnCOLUMN_VALUE6
ColumnCOLUMN_VALUE7
ColumnCOLUMN_VALUE8
ColumnCOLUMN_VALUE9
ColumnCOLUMN_VALUE10
Columns
Name Datatype Length Mandatory Comments
WF_ITEM_TYPE VARCHAR2 (8)
Item type of the workflow
PROCESS_NAME VARCHAR2 (30)
Process name of the workflow
COLUMN_NAME1 VARCHAR2 (32)
Column name 1
COLUMN_VALUE1 VARCHAR2 (240)
Column value 1
COLUMN_NAME2 VARCHAR2 (32)
Column name 2
COLUMN_VALUE2 VARCHAR2 (240)
Column value 2
COLUMN_NAME3 VARCHAR2 (32)
Column name 3
COLUMN_VALUE3 VARCHAR2 (240)
Column value 3
COLUMN_NAME4 VARCHAR2 (32)
Column name 4
COLUMN_VALUE4 VARCHAR2 (240)
Column value 4
COLUMN_NAME5 VARCHAR2 (32)
Column name 5
COLUMN_VALUE5 VARCHAR2 (240)
Column value 5
COLUMN_NAME6 VARCHAR2 (32)
Column name 6
COLUMN_VALUE6 VARCHAR2 (240)
Column value 6
COLUMN_NAME7 VARCHAR2 (32)
Column name 7
COLUMN_VALUE7 VARCHAR2 (240)
Column value 7
COLUMN_NAME8 VARCHAR2 (32)
Column name 8
COLUMN_VALUE8 VARCHAR2 (240)
Column value 8
COLUMN_NAME9 VARCHAR2 (32)
Column name 9
COLUMN_VALUE9 VARCHAR2 (240)
Column value 9
COLUMN_NAME10 VARCHAR2 (32)
Column name 10
COLUMN_VALUE10 VARCHAR2 (240)
Column value 10
ROLE VARCHAR2 (30)
Workflow role
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
LAST_UPDATED_BY NUMBER (15)
Standard who column
CREATED_BY NUMBER (15)
Standard who column
CREATION_DATE DATE

Standard who column
LAST_UPDATE_DATE DATE

Standard who column
ENABLE_FLAG VARCHAR2 (1)
Values are N or Y
SORT_ORDER NUMBER (5)
Sort order
Query Text

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


SELECT WF_ITEM_TYPE
,      PROCESS_NAME
,      COLUMN_NAME1
,      COLUMN_VALUE1
,      COLUMN_NAME2
,      COLUMN_VALUE2
,      COLUMN_NAME3
,      COLUMN_VALUE3
,      COLUMN_NAME4
,      COLUMN_VALUE4
,      COLUMN_NAME5
,      COLUMN_VALUE5
,      COLUMN_NAME6
,      COLUMN_VALUE6
,      COLUMN_NAME7
,      COLUMN_VALUE7
,      COLUMN_NAME8
,      COLUMN_VALUE8
,      COLUMN_NAME9
,      COLUMN_VALUE9
,      COLUMN_NAME10
,      COLUMN_VALUE10
,      ROLE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      ENABLE_FLAG
,      SORT_ORDER
FROM GMA.GMA_PROCDATA_WF;

Dependencies

[top of page]

GMA.GMA_PROCDATA_WF does not reference any database object

GMA.GMA_PROCDATA_WF is referenced by following:

SchemaGMA
ViewGMA_PROCDATA_WF#