[Home] [Help] [Dependency Information]
Object Name: | GMA_PROCCOL_WF_B |
---|---|
Object Type: | TABLE |
Owner: | GMA |
FND Design Data: | GMA.GMA_PROCCOL_WF_B |
Subobject Name: | |
Status: | VALID |
This table contains information about configuration columns at workflow process level. Using these columns users can customize the approval process behavior. This data is used as seed data for the Workflow Process Configuration screen. When users query an approval process in the form, this table data is used to determine how many columns are associated with the approval process and what are these columns.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GMA_PROCCOL_WF_B_PK | NORMAL | UNIQUE | APPS_TS_SEED |
WF_ITEM_TYPE
PROCESS_NAME TABLE_NAME COLUMN_NAME |
GMA_PROCCOL_WF_B_UK | NORMAL | UNIQUE | APPS_TS_SEED |
WF_ITEM_TYPE
PROCESS_NAME COLUMN_HIERARCHY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WF_ITEM_TYPE | VARCHAR2 | (8) | Yes | Workflow Item Type |
PROCESS_NAME | VARCHAR2 | (30) | Yes | Workflow process name |
COLUMN_HIERARCHY | NUMBER | (3) | Yes | Workflow column hierarchy |
TABLE_NAME | VARCHAR2 | (100) | Yes | Workflow table name |
COLUMN_NAME | VARCHAR2 | (32) | Yes | Workflow column name |
COLUMN_PROMPT | VARCHAR2 | (40) | Workflow column prompt | |
LOV_TABLE | VARCHAR2 | (100) | Yes | List of Values table |
LOV_COLUMN | VARCHAR2 | (200) | Yes | List of Values column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
CREATION_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column |
Cut, paste (and edit) the following text to query this object:
SELECT WF_ITEM_TYPE
, PROCESS_NAME
, COLUMN_HIERARCHY
, TABLE_NAME
, COLUMN_NAME
, COLUMN_PROMPT
, LOV_TABLE
, LOV_COLUMN
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
FROM GMA.GMA_PROCCOL_WF_B;
GMA.GMA_PROCCOL_WF_B does not reference any database object
GMA.GMA_PROCCOL_WF_B is referenced by following:
|
|
|