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

VIEW: APPS.MST_DD_ORDER_SUMMARY_V

Object Details
Object Name: MST_DD_ORDER_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 Identifier of plan to which current record belong
SOURCE_CODE VARCHAR2 (30) Yes OE/WIP/PO
SOURCE_HEADER_NUMBER VARCHAR2 (150)
The user visible identifier for the header, ex. Order number
TP_REFER_HEADER_NUMBER VARCHAR2 (50)
Customer PO Number, Supplier Sales Order Line Number or Shipper's Sales Order reference to return
REFERENCE_SOURCE_TYPE VARCHAR2 (240)
Source type of the reference order SO, PO etc
WEIGHT_UOM VARCHAR2 (3)
Global weight UOM defined in global parameters
VOLUME_UOM VARCHAR2 (3)
Global volume UOM defined in global parameters
WEIGHT NUMBER

Total gross weight of delivery lines in this order.
CUBE NUMBER

Total volume of delivery lines in this order.
PALLETS NUMBER

Total pallets of delivery lines in this order.
PIECES NUMBER

Total pieces of delivery lines in this order.
Query Text

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


SELECT PLAN_ID
,      SOURCE_CODE
,      SOURCE_HEADER_NUMBER
,      TP_REFER_HEADER_NUMBER
,      REFERENCE_SOURCE_TYPE
,      WEIGHT_UOM
,      VOLUME_UOM
,      WEIGHT
,      CUBE
,      PALLETS
,      PIECES
FROM APPS.MST_DD_ORDER_SUMMARY_V;

Dependencies

[top of page]

APPS.MST_DD_ORDER_SUMMARY_V references the following:

SchemaAPPS
SynonymMST_DELIVERY_DETAILS
SynonymMST_PLANS

APPS.MST_DD_ORDER_SUMMARY_V is not referenced by any database object