eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: MSC.MSC_PERSONAL_QUERIES

Object Details

Object Name:	MSC_PERSONAL_QUERIES
Object Type:	TABLE
Owner:	MSC
Subobject Name:
Status:	VALID

This Table contains the definition of personal/public queries

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MSC_PERSONAL_QUERIES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	QUERY_ID
MSC_PERSONAL_QUERIES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	QUERY_NAME
MSC_PERSONAL_QUERIES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PLAN_TYPE PUBLIC_FLAG QUERY_TYPE EXECUTE_FLAG

Columns

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

Query Text

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;

Dependencies

[top of page]

MSC.MSC_PERSONAL_QUERIES does not reference any database object

MSC.MSC_PERSONAL_QUERIES is referenced by following:

MSC: MSC_PERSONAL_QUERIES#