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

TABLE: MSC.MSC_PQ_TYPES

Object Details
Object Name: MSC_PQ_TYPES
Object Type: TABLE
Owner: MSC
Subobject Name:
Status: VALID


This Table contains the exception type/order sub query definition of personal/public queries


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_PQ_TYPES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnQUERY_ID
ColumnOBJECT_TYPE
ColumnSOURCE_TYPE
ColumnSEQUENCE_ID
Columns
Name Datatype Length Mandatory Comments
QUERY_ID NUMBER
Yes Query Id
SOURCE_TYPE NUMBER
Yes Source Type, CP or ASCP
OBJECT_TYPE NUMBER
Yes Object Type
SEQUENCE_ID NUMBER
Yes Sequence Id
AND_OR_FLAG NUMBER

AND or OR Flag
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
CUSTOMIZED_TEXT VARCHAR2 (80)
Customized exception name
SR_INSTANCE_ID NUMBER

sr instance id
OBJECT_TYPE_TEXT VARCHAR2 (80)
Stores Custom text for Order Query
ACTIVE_FLAG NUMBER

Flag to indicate whether Query is active or not.
DETAIL_QUERY_ID NUMBER

Id of sub query in a worklist
FREQUENCY NUMBER

Number of days from action taken date.
PRIORITY NUMBER

Priority in the worklist Result
Query Text

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


SELECT QUERY_ID
,      SOURCE_TYPE
,      OBJECT_TYPE
,      SEQUENCE_ID
,      AND_OR_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CUSTOMIZED_TEXT
,      SR_INSTANCE_ID
,      OBJECT_TYPE_TEXT
,      ACTIVE_FLAG
,      DETAIL_QUERY_ID
,      FREQUENCY
,      PRIORITY
FROM MSC.MSC_PQ_TYPES;

Dependencies

[top of page]

MSC.MSC_PQ_TYPES does not reference any database object

MSC.MSC_PQ_TYPES is referenced by following:

SchemaAPPS
SynonymMSC_PQ_TYPES