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

VIEW: APPS.MST_CARRIER_DETAILS_V

Object Details
Object Name: MST_CARRIER_DETAILS_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
Yes FK to PLAN_ID of MST_PLANS.
CARRIER_ID NUMBER

FK to CARRIER_ID of WSH_CARRIERS.
CARRIER_NAME VARCHAR2 (360) Yes Name of the Carrier.
COMPILE_DESIGNATOR VARCHAR2 (10) Yes Plan Name
DESCRIPTION VARCHAR2 (50)
Plan Description.
LOAD_COUNT_STR VARCHAR2 (80)
String contains Concatenated Counts of Direct TLs, multistop TLs, LTLs, Parcels.
TOTAL_COST NUMBER

Total Cost related to Carrier.
TOTAL_WEIGHT NUMBER

Total Weight related to Carrier.
TOTAL_CUBE NUMBER

Total Cube related to Carrier.
TOTAL_PALLETS NUMBER

Total Pallets related to Carrier.
TOTAL_PIECES NUMBER

Total Pieces related to Carrier.
TOTAL_ORDERS NUMBER

Total Orders related to Carrier.
CURRENCY_UOM VARCHAR2 (3)
Unit of Measure for Cost.
WEIGHT_UOM VARCHAR2 (3)
Unit of Measure for Weight.
VOLUME_UOM VARCHAR2 (3)
Unit of Measure for Volume.
Query Text

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


SELECT PLAN_ID
,      CARRIER_ID
,      CARRIER_NAME
,      COMPILE_DESIGNATOR
,      DESCRIPTION
,      LOAD_COUNT_STR
,      TOTAL_COST
,      TOTAL_WEIGHT
,      TOTAL_CUBE
,      TOTAL_PALLETS
,      TOTAL_PIECES
,      TOTAL_ORDERS
,      CURRENCY_UOM
,      WEIGHT_UOM
,      VOLUME_UOM
FROM APPS.MST_CARRIER_DETAILS_V;

Dependencies

[top of page]

APPS.MST_CARRIER_DETAILS_V references the following:

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

APPS.MST_CARRIER_DETAILS_V is not referenced by any database object