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

VIEW: APPS.MST_AO_ORDERS_V

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

Total weight of lines in this order
CUBE NUMBER

Total volume of lines in this order
PALLETS NUMBER

Total pallets in this order
PIECES NUMBER

Total pieces of lines in this order
WEIGHT_UOM VARCHAR2 (3)
Unit of measurement of weight in the plan
VOLUME_UOM VARCHAR2 (3)
Unit of measurement of volume in the plan
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
,      CUBE
,      PALLETS
,      PIECES
,      WEIGHT_UOM
,      VOLUME_UOM
FROM APPS.MST_AO_ORDERS_V;

Dependencies

[top of page]

APPS.MST_AO_ORDERS_V references the following:

SchemaAPPS
SynonymMST_DELIVERY_DETAILS
SynonymMST_PLANS

APPS.MST_AO_ORDERS_V is not referenced by any database object