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

VIEW: APPS.MST_CARR_LOAD_SUMMARY_V

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

Unique identifier for plan. FK to PLAN_ID of MST_PLANS.
CARRIER_ID NUMBER

Vendor providing (trip) service.
MODE_OF_TRANSPORT VARCHAR2 (6)
Truck, LTL, Ocean, Parcel etc
MODE_TYPE NUMBER

Flag to indicate mode of transport. 0 => All,1=>TL, 2=>LTL,3=>Parcel. This is used to sort data (Fixed) before displaying in UI.
FACILITY_ID NUMBER

ID of Carrier Facility.
TOTAL_TRIPS NUMBER

Total trips to Carrier Facility.
TOTAL_COST NUMBER

Cost related to Carrier Facility.
TOTAL_WEIGHT NUMBER

Weight related to Carrier Facility.
TOTAL_CUBE NUMBER

Cube related to Carrier Facility.
TOTAL_PALLETS NUMBER

Pallets related to Carrier Facility.
TOTAL_PIECES NUMBER

Pieces related to Carrier Facility.
TOTAL_ORDERS NUMBER

Orders related to Carrier Facility.
CURRENCY_UOM VARCHAR2 (3)
Unit of Measure for Cost.
Query Text

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


SELECT PLAN_ID
,      CARRIER_ID
,      MODE_OF_TRANSPORT
,      MODE_TYPE
,      FACILITY_ID
,      TOTAL_TRIPS
,      TOTAL_COST
,      TOTAL_WEIGHT
,      TOTAL_CUBE
,      TOTAL_PALLETS
,      TOTAL_PIECES
,      TOTAL_ORDERS
,      CURRENCY_UOM
FROM APPS.MST_CARR_LOAD_SUMMARY_V;

Dependencies

[top of page]

APPS.MST_CARR_LOAD_SUMMARY_V references the following:

SchemaAPPS
SynonymFTE_LOCATION_PARAMETERS
PL/SQL PackageMST_AGG_PKG - show dependent code
SynonymMST_PLANS
SynonymMST_TRIPS
SynonymWSH_LOCATION_OWNERS

APPS.MST_CARR_LOAD_SUMMARY_V is not referenced by any database object