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

VIEW: APPS.MST_R_SUPP_DETAIL_V

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

Supplier ID
SUPP_NAME VARCHAR2 (360)
Supplier name
ORDERS NUMBER

number of supplier orders
WEIGHT NUMBER

total weight of the supplier orders
CUBES NUMBER

total volume of the supplier orders
PIECES NUMBER

total number of pieces in the supplier orders
STOPS NUMBER

number of multi-stop TLs, carrying the supplier orders
DIRECTTL NUMBER

number of direct TLs, carrying the supplier orders
LTL NUMBER

number of LTLs, carrying the supplier orders
PARCEL NUMBER

number of parcels, carrying the supplier 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
,      SUPPLIER_ID
,      SUPP_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_SUPP_DETAIL_V;

Dependencies

[top of page]

APPS.MST_R_SUPP_DETAIL_V references the following:

SchemaAPPS
SynonymMST_MAST_SUM_REPORT_TEMP_GT

APPS.MST_R_SUPP_DETAIL_V is not referenced by any database object