[Home] [Help] [Dependency Information]
Object Name: | MSC_WORKLIST_GROUPBY |
---|---|
Object Type: | TABLE |
Owner: | MSC |
Subobject Name: | |
Status: | VALID |
This Table contains group by options defined for worklists.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MSC_WORKLIST_GROUPBY_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
QUERY_ID
ATTRIBUTE_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
QUERY_ID | NUMBER | Query ID | ||
ATTRIBUTE_NAME | VARCHAR2 | (240) | Attribute Name | |
CHAR1 | VARCHAR2 | (240) | Char 1 | |
CHAR2 | VARCHAR2 | (240) | Char 2 | |
CHAR3 | VARCHAR2 | (240) | Char 3 | |
CHAR4 | VARCHAR2 | (240) | Char 4 | |
SEQUENCE | NUMBER | Sequence | ||
LAST_UPDATE_DATE | DATE | Standard Who Column | ||
LAST_UPDATED_BY | NUMBER | Standard Who Column | ||
CREATION_DATE | DATE | Standard Who Column | ||
CREATED_BY | NUMBER | Standard Who Column | ||
LAST_UPDATE_LOGIN | NUMBER | Standard Who Column |
Cut, paste (and edit) the following text to query this object:
SELECT QUERY_ID
, ATTRIBUTE_NAME
, CHAR1
, CHAR2
, CHAR3
, CHAR4
, SEQUENCE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
FROM MSC.MSC_WORKLIST_GROUPBY;
MSC.MSC_WORKLIST_GROUPBY does not reference any database object
MSC.MSC_WORKLIST_GROUPBY is referenced by following:
|
|
|