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

VIEW: APPS.MST_EXCEPTION_SUMMARY_V

Object Details
Object Name: MST_EXCEPTION_SUMMARY_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
PLAN_ID NUMBER
Yes FK to mst_plans
EXCEPTION_GROUP NUMBER
Yes Lookup codes. 100 => Early and Late Exceptions, 200 => Trip and OrderExceptions, 300 => Carrier Exceptions, 400 => Timing Exceptions, 500 => Cost Exceptions, 600 => Vehicle Exceptions, 700 => Facility Exceptions, 800 => Trading Partner Exceptions, 900 => Unplanned Delivery Lines, 1000 => Unplanned Deliveries
EXCEPTION_GROUP_NAME VARCHAR2 (80) Yes Lookup values. 100 => Early and Late Exceptions, 200 => Trip and OrderExceptions, 300 => Carrier Exceptions, 400 => Timing Exceptions, 500 => Cost Exceptions, 600 => Vehicle Exceptions, 700 => Facility Exceptions, 800 => Trading Partner Exceptions, 900 => Unplanned Delivery Lines, 1000 => Unplanned Deliveries
EXCEPTION_TYPE NUMBER
Yes Lookup code for exception types
EXCEPTION_TYPE_NAME VARCHAR2 (80) Yes Lookup value for exception types
COUNT NUMBER

Total number of exceptions for given exception type
RANK NUMBER
Yes Order in which exceptions are displayed in exception summary
Query Text

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


SELECT PLAN_ID
,      EXCEPTION_GROUP
,      EXCEPTION_GROUP_NAME
,      EXCEPTION_TYPE
,      EXCEPTION_TYPE_NAME
,      COUNT
,      RANK
FROM APPS.MST_EXCEPTION_SUMMARY_V;

Dependencies

[top of page]

APPS.MST_EXCEPTION_SUMMARY_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewMFG_LOOKUPS
SynonymMST_EXCEPTIONS
SynonymMST_EXCEP_PREFERENCES

APPS.MST_EXCEPTION_SUMMARY_V is not referenced by any database object