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

VIEW: APPS.MST_R_BUSINESS_UNIT_DETAIL_V

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

Id of the plan for which report is generated
ORG_NAME VARCHAR2 (60)
Name of My Facility
ORDERS NUMBER

Number of orders originating or terminating at the facility
WEIGHT NUMBER

Total weight of all the orders originating or terminating at the facility
CUBES NUMBER

Total volume of all the orders originating or terminating at the facility
PIECES NUMBER

Total number of pieces of all the orders originating or terminating at the facility
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 cost
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
,      ORG_NAME
,      ORDERS
,      WEIGHT
,      CUBES
,      PIECES
,      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_BUSINESS_UNIT_DETAIL_V;

Dependencies

[top of page]

APPS.MST_R_BUSINESS_UNIT_DETAIL_V references the following:

SchemaAPPS
SynonymMST_MAST_SUM_REPORT_TEMP_GT

APPS.MST_R_BUSINESS_UNIT_DETAIL_V is not referenced by any database object