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

VIEW: APPS.MST_OD_SUMMARY_V

Object Details
Object Name: MST_OD_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
COMPILE_DESIGNATOR VARCHAR2 (10) Yes Plan name
DESCRIPTION VARCHAR2 (50)
Plan description
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 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
,      COMPILE_DESIGNATOR
,      DESCRIPTION
,      SOURCE_CODE
,      SOURCE_HEADER_NUMBER
,      TP_REFER_HEADER_NUMBER
,      REFERENCE_SOURCE_TYPE
,      WEIGHT_UOM
,      VOLUME_UOM
,      WEIGHT
,      CUBE
,      PALLETS
,      PIECES
FROM APPS.MST_OD_SUMMARY_V;

Dependencies

[top of page]

APPS.MST_OD_SUMMARY_V references the following:

SchemaAPPS
SynonymMST_DELIVERY_DETAILS
SynonymMST_PLANS

APPS.MST_OD_SUMMARY_V is not referenced by any database object