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

VIEW: APPS.MST_SUPPLIER_ORDERS_V

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

FK to PLAN_ID of MST_PLANS.
SUPPLIER_ID NUMBER

ID of Supplier for the Order.
FACILITY_ID NUMBER

ID of Facility related to Order.
SOURCE_CODE VARCHAR2 (30)
Order Source Code.
SOURCE_HEADER_NUMBER VARCHAR2 (150)
Order Number.
TP_REFER_HEADER_NUMBER VARCHAR2 (50)
Reference number for TP order.
REFERENCE_SOURCE_TYPE VARCHAR2 (240)
Reference to Source order type.
COST NUMBER

Cost related to Order.
WEIGHT NUMBER

Weight related to Order.
CUBE NUMBER

Cube related to Order.
PALLETS NUMBER

Pallets related to Order.
PIECES NUMBER

Pieces related to Order.
CURRENCY_UOM VARCHAR2 (3)
Unit of Measure for Cost.
WEIGHT_UOM VARCHAR2 (3)
Unit of Measure for Weight.
VOLUME_UOM VARCHAR2 (3)
Unit of Measure for Cube.
Query Text

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


SELECT PLAN_ID
,      SUPPLIER_ID
,      FACILITY_ID
,      SOURCE_CODE
,      SOURCE_HEADER_NUMBER
,      TP_REFER_HEADER_NUMBER
,      REFERENCE_SOURCE_TYPE
,      COST
,      WEIGHT
,      CUBE
,      PALLETS
,      PIECES
,      CURRENCY_UOM
,      WEIGHT_UOM
,      VOLUME_UOM
FROM APPS.MST_SUPPLIER_ORDERS_V;

Dependencies

[top of page]

APPS.MST_SUPPLIER_ORDERS_V references the following:

SchemaAPPS
SynonymFTE_LOCATION_PARAMETERS
SynonymMST_DELIVERIES
SynonymMST_DELIVERY_ASSIGNMENTS
SynonymMST_DELIVERY_DETAILS
SynonymMST_DELIVERY_LEGS
SynonymMST_PLANS
SynonymMST_TRIP_STOPS
SynonymWSH_LOCATIONS

APPS.MST_SUPPLIER_ORDERS_V is not referenced by any database object