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

VIEW: APPS.MST_PQ_EXCEP_RESULTS_V

Object Details
Object Name: MST_PQ_EXCEP_RESULTS_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
QUERY_ID NUMBER
Yes ID of the Query.
PLAN_ID NUMBER
Yes ID of Plan used in the query.
EXCEPTION_ID NUMBER
Yes Primary Key
EXCEPTION_GROUP NUMBER
Yes Lookup. 100 => Late Order, 200 => Load Exceptions, 300 => Carrier Exceptions, 400 => Timing Exceptions, 500 => Cost Exceptions, 600 => Equipment Exceptions, 700 => Facility Exceptions, 800 => Trading Partner Exceptions, 900 => Unplanned Order Exceptions
EXCEPTION_GROUP_NAME VARCHAR2 (80)
Description of Exception Group
EXCEPTION_TYPE NUMBER
Yes Exception Type ID.
EXCEPTION_TYPE_NAME VARCHAR2 (80)
Description of Exception Type.
EXCEPTION_COUNT NUMBER

Count of Instances of an Exception.
RANK NUMBER
Yes
Query Text

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


SELECT QUERY_ID
,      PLAN_ID
,      EXCEPTION_ID
,      EXCEPTION_GROUP
,      EXCEPTION_GROUP_NAME
,      EXCEPTION_TYPE
,      EXCEPTION_TYPE_NAME
,      EXCEPTION_COUNT
,      RANK
FROM APPS.MST_PQ_EXCEP_RESULTS_V;

Dependencies

[top of page]

APPS.MST_PQ_EXCEP_RESULTS_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymMST_EXCEPTIONS
SynonymMST_EXCEP_PREFERENCES
SynonymMST_PERSONAL_QUERY_RESULTS
PL/SQL PackageMST_WB_UTIL - show dependent code

APPS.MST_PQ_EXCEP_RESULTS_V is not referenced by any database object