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

VIEW: APPS.MST_PQ_EXCEP_DETAILS_V

Object Details
Object Name: MST_PQ_EXCEP_DETAILS_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

Primary key
EXCEPTION_ID NUMBER

Primary Key
EXCEPTION_DETAIL_ID NUMBER

Primary Key
EXCEPTION_TYPE NUMBER

Lookup
EXCEPTION_STATUS NUMBER

1 => ACTION TAKEN, 2 => IGNORE, 3 => TO BE REVIEWED
TOTAL_EXCEPTIONS NUMBER

Count of Instances of an Exception.
MODE_OF_TRANSPORT VARCHAR2 (30)
Mode of Transport for the Trips.
DELIVERY_ID NUMBER

Delivery Id Corresponding to the Exception.
CONTINUOUS_MOVE_ID NUMBER

Continuous Move Id Corresponding to the Exception.
FACILITY_ID NUMBER

Facility Id Corresponding to the Exception.
CARRIER_ID NUMBER

Carrier Id Corresponding to the Exception.
CUSTOMER_ID NUMBER

Customer Id Corresponding to the Exception.
SUPPLIER_ID NUMBER

Supplier Id Corresponding to the Exception.
Query Text

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


SELECT PLAN_ID
,      EXCEPTION_ID
,      EXCEPTION_DETAIL_ID
,      EXCEPTION_TYPE
,      EXCEPTION_STATUS
,      TOTAL_EXCEPTIONS
,      MODE_OF_TRANSPORT
,      DELIVERY_ID
,      CONTINUOUS_MOVE_ID
,      FACILITY_ID
,      CARRIER_ID
,      CUSTOMER_ID
,      SUPPLIER_ID
FROM APPS.MST_PQ_EXCEP_DETAILS_V;

Dependencies

[top of page]

APPS.MST_PQ_EXCEP_DETAILS_V references the following:

SchemaAPPS
SynonymFTE_LOCATION_PARAMETERS
SynonymMST_DELIVERIES
SynonymMST_EXCEPTIONS
SynonymMST_EXCEPTION_DETAILS
SynonymMST_PLANS
SynonymMST_TRIPS
SynonymMST_TRIP_STOPS

APPS.MST_PQ_EXCEP_DETAILS_V is not referenced by any database object