[Home] [Help]
[Dependency Information]
Object Name: | MSC_PERSONAL_QUERIES |
---|---|
Object Type: | TABLE |
Owner: | MSC |
Subobject Name: | |
Status: | VALID |
This Table contains the definition of personal/public queries
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MSC_PERSONAL_QUERIES_U1 | NORMAL | UNIQUE |
![]() |
![]() |
MSC_PERSONAL_QUERIES_U2 | NORMAL | UNIQUE |
![]() |
![]() |
MSC_PERSONAL_QUERIES_N1 | NORMAL | NONUNIQUE |
![]() |
![]() ![]() ![]() ![]() |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
QUERY_ID | NUMBER | Yes | Query Id - Primary key | |
QUERY_NAME | VARCHAR2 | (80) | Yes | PersonalPublic Query Name |
DESCRIPTION | VARCHAR2 | (250) | PersonalPublic Query Description | |
QUERY_TYPE | NUMBER | Yes | Query Type [item/resources, exception, item, supplier, loads] | |
PUBLIC_FLAG | NUMBER | Yes | Public or Personal | |
AND_OR_FLAG | NUMBER | And Condition or Or Condition | ||
EXECUTE_FLAG | NUMBER | Query Executed or Not | ||
CREATED_BY | NUMBER | Standard Who Columns | ||
CREATION_DATE | DATE | Standard Who Columns | ||
LAST_UPDATE_DATE | DATE | Standard Who Columns | ||
LAST_UPDATED_BY | NUMBER | Standard Who Columns | ||
LAST_UPDATE_LOGIN | NUMBER | Standard Who Columns | ||
PLAN_TYPE | NUMBER | Plan Type | ||
UNSAVED_FLAG | NUMBER | saved to db or not | ||
AUTO_RELEASE | NUMBER | Flag to indicate Auto Release | ||
GROUP_ID | NUMBER | User Group ID | ||
UPDATED_FLAG | NUMBER | Flag to indicate whether worklist is updated after execution. | ||
EXECUTION_DATE | DATE | Date of Execution |
Cut, paste (and edit) the following text to query this object:
SELECT QUERY_ID
, QUERY_NAME
, DESCRIPTION
, QUERY_TYPE
, PUBLIC_FLAG
, AND_OR_FLAG
, EXECUTE_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PLAN_TYPE
, UNSAVED_FLAG
, AUTO_RELEASE
, GROUP_ID
, UPDATED_FLAG
, EXECUTION_DATE
FROM MSC.MSC_PERSONAL_QUERIES;
MSC.MSC_PERSONAL_QUERIES does not reference any database object
MSC.MSC_PERSONAL_QUERIES is referenced by following:
|
|
|