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

TABLE: WMS.WMS_SAVED_QUERIES

Object Details
Object Name: WMS_SAVED_QUERIES
Object Type: TABLE
Owner: WMS
FND Design Data: TableWMS.WMS_SAVED_QUERIES
Subobject Name:
Status: VALID


WMS Saved Queries stores queries saved from a query find window. There may be multiple records for each query. The number of records for each query depends upon the number of restrictions in the query.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WMS_SAVED_QUERIES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnQUERY_TYPE
ColumnQUERY_NAME
ColumnFIELD_NAME
Columns
Name Datatype Length Mandatory Comments
QUERY_TYPE VARCHAR2 (30)
Type of the Query
QUERY_NAME VARCHAR2 (30) Yes Name of the query
FIELD_NAME VARCHAR2 (60) Yes Name of the query field
FIELD_TYPE VARCHAR2 (1)
Type of query field
FIELD_VALUE VARCHAR2 (240) Yes Value of query field
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
ORGANIZATION_ID NUMBER
Yes Organization Identifier
USER_ID NUMBER

User Identifier
Query Text

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


SELECT QUERY_TYPE
,      QUERY_NAME
,      FIELD_NAME
,      FIELD_TYPE
,      FIELD_VALUE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      ORGANIZATION_ID
,      USER_ID
FROM WMS.WMS_SAVED_QUERIES;

Dependencies

[top of page]

WMS.WMS_SAVED_QUERIES does not reference any database object

WMS.WMS_SAVED_QUERIES is referenced by following:

SchemaWMS
ViewWMS_SAVED_QUERIES#