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

VIEW: APPS.MST_R_CUST_DETAIL_V

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

Customer ID.
CUST_NAME VARCHAR2 (360)
Customer name
ORDERS NUMBER

number of customer orders
WEIGHT NUMBER

total weight of the customer orders
CUBES NUMBER

total volume of the customer orders
PIECES NUMBER

total number of pieces in the customer orders
STOPS NUMBER

number of multi-stop trips carrying the customer orders
DIRECTTL NUMBER

number of direct TLs carrying the customer orders
LTL NUMBER

number of LTLs carrying the customer orders
PARCEL NUMBER

number of parcels carrying the customer 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 the facility
COST_PER_ALLOC_VALUE NUMBER

Query Text

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


SELECT PLAN_ID
,      CUSTOMER_ID
,      CUST_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_CUST_DETAIL_V;

Dependencies

[top of page]

APPS.MST_R_CUST_DETAIL_V references the following:

SchemaAPPS
SynonymMST_MAST_SUM_REPORT_TEMP_GT

APPS.MST_R_CUST_DETAIL_V is not referenced by any database object