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

VIEW: APPS.MST_R_ORIGIN_DETAIL_V

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

Primary key
ORIGIN_NAME VARCHAR2 (60)
origin state
ORDERS NUMBER

count of orders in the deliveries which originated from the state
WEIGHT NUMBER

total weight of all such orders
CUBES NUMBER

total volume of all such orders
PIECES NUMBER

total number of pieces in all such orders
STOPS NUMBER

number of multi-stop trips carrying such orders
DIRECTTL NUMBER

number of direct TLs carrying such orders
LTL NUMBER

number of LTLs carrying such orders
PARCEL NUMBER

number of parcels carrying such orders
TL_COST NUMBER

loading/unloading, transportation and handling cost of all the TLs carrying such orders
LTL_COST NUMBER

loading/unloading, transportation and handling cost of all the LTLs carrying such orders
PARCEL_COST NUMBER

loading/unloading, transportation and handling cost of all the Parcels carrying such orders
TOTAL_COST NUMBER

Sum of TL, LTL, Parcel costs
COST_PER_UNIT_WEIGHT NUMBER

total_cost / weight
COST_PER_UNIT_CUBE NUMBER

total_cost / volume
COST_PER_TOTAL_VALUE NUMBER

total_cost / allocated value for all the origin locations of the deliveries in a state
COST_PER_ALLOC_VALUE NUMBER

Query Text

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


SELECT PLAN_ID
,      ORIGIN_NAME
,      ORDERS
,      WEIGHT
,      CUBES
,      PIECES
,      STOPS
,      DIRECTTL
,      LTL
,      PARCEL
,      TL_COST
,      LTL_COST
,      PARCEL_COST
,      TOTAL_COST
,      COST_PER_UNIT_WEIGHT
,      COST_PER_UNIT_CUBE
,      COST_PER_TOTAL_VALUE
,      COST_PER_ALLOC_VALUE
FROM APPS.MST_R_ORIGIN_DETAIL_V;

Dependencies

[top of page]

APPS.MST_R_ORIGIN_DETAIL_V references the following:

SchemaAPPS
SynonymMST_MAST_SUM_REPORT_TEMP_GT

APPS.MST_R_ORIGIN_DETAIL_V is not referenced by any database object