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

VIEW: APPS.MST_ALL_LOADS_V

Object Details
Object Name: MST_ALL_LOADS_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 mst_plans
OUTPUT_TYPE VARCHAR2 (7)
Record type, i.e., Total, Truckloads, LTLs, Parcels
COUNT NUMBER

Count of trips in this type in plan
COST NUMBER

Cost of trips in this type in the plans
WEIGHT NUMBER

Weights carried by trips in this type in the plans
CUBE NUMBER

Cubes carried by trips in this type in the plans
PALLETS NUMBER

Pallets carried by trips in this type in the plans
PIECES NUMBER

Pieces carried by trips in this type in the plans
ORDERS NUMBER

Count of orders carried by trips in this type in the plans
TYPE_ID NUMBER

1->Total, 2-> Truckloads, 3-> LTLs, 4-> Parcels
CURRENCY_UOM VARCHAR2 (3)
Currency UOM considered in this paln
WEIGHT_UOM VARCHAR2 (3)
Weight UOM considered in this paln
VOLUME_UOM VARCHAR2 (3)
Volume UOM considered in this paln
Query Text

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


SELECT PLAN_ID
,      OUTPUT_TYPE
,      COUNT
,      COST
,      WEIGHT
,      CUBE
,      PALLETS
,      PIECES
,      ORDERS
,      TYPE_ID
,      CURRENCY_UOM
,      WEIGHT_UOM
,      VOLUME_UOM
FROM APPS.MST_ALL_LOADS_V;

Dependencies

[top of page]

APPS.MST_ALL_LOADS_V references the following:

SchemaAPPS
PL/SQL PackageMST_AGG_PKG - show dependent code
SynonymMST_PLANS

APPS.MST_ALL_LOADS_V is not referenced by any database object