[Home] [Help] [Dependency Information]
Object Name: | MST_CM_LOADS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLAN_ID | NUMBER | Yes | Unique identifier for plan | |
ROW_ID | ROWID | (10) | rowid of mst_trips | |
TRIP_ID | NUMBER | Yes | FK to mst_trips | |
CONTINUOUS_MOVE_ID | NUMBER | Yes | Continuous move to which this trip is part of | |
CONTINUOUS_MOVE_SEQUENCE | NUMBER | Sequence of this trip in its continuous move | ||
TRIP_NUMBER | NUMBER | Trip number with in plan | ||
CARRIER_ID | NUMBER | Yes | Id of vendor providing (trip) service | |
CARRIER_CODE | VARCHAR2 | (30) | Yes | Name of vendor providing (trip) service |
SERVICE_LEVEL | VARCHAR2 | (30) | Untranslated service level of this trip | |
SERVICE_LEVEL_TL | VARCHAR2 | (80) | Yes | Translated service level of this trip |
VEHICLE_TYPE | VARCHAR2 | (40) | Vehicle type used in this trip (translated) | |
TRIP_LOADING_STATUS | VARCHAR2 | (4000) | Loaded or Empty | |
ORIGIN_COMPANY | VARCHAR2 | (80) | Owner company name of very first facility (first stop) of this truckload | |
ORIGIN_FACILITY_ID | NUMBER | Yes | facility_id of of first stop of this truckload | |
ORIGIN_FACILITY | VARCHAR2 | (60) | Yes | Facility name of very first facility (first stop) of this truckload |
ORIGIN_FACILITY_DESC | VARCHAR2 | (250) | Facility description of very first facility (first stop) of this truckload | |
ORIGIN_CITY | VARCHAR2 | (120) | City of very first facility (first stop) of this truckload | |
ORIGIN_STATE | VARCHAR2 | (120) | State of very first facility (first stop) of this truckload | |
ORIGIN_ZIP | VARCHAR2 | (60) | Zip of very first facility (first stop) of this truckload | |
ORIGIN_COUNTRY | VARCHAR2 | (120) | Country of very first facility (first stop) of this truckload | |
DESTINATION_COMPANY | VARCHAR2 | (80) | Owner company name of very last facility (last stop) of this truckload | |
DESTINATION_FACILITY_ID | NUMBER | Yes | facility_id of last stop of this truckload | |
DESTINATION_FACILITY | VARCHAR2 | (60) | Yes | Facility name of very last facility (last stop) of this truckload |
DESTINATION_FACILITY_DESC | VARCHAR2 | (250) | Facility description of very last facility (last stop) of this truckload | |
DESTINATION_CITY | VARCHAR2 | (120) | City in which very last facility (last stop) of this truckload is located | |
DESTINATION_STATE | VARCHAR2 | (120) | State in which very last facility (last stop) of this truckload is located | |
DESTINATION_ZIP | VARCHAR2 | (60) | Zip in which very last facility (last stop) of this truckload is located | |
DESTINATION_COUNTRY | VARCHAR2 | (120) | Country in which very last facility (last stop) of this truckload is located | |
TRIP_START_DATE | DATE | DateTime when truckload vehicle arrive at its first stop | ||
TIME_ZONE1 | VARCHAR2 | (4000) | Time zone of first stop of trip | |
TRIP_END_DATE | DATE | DateTime when truckload vehicle depart from its last stop | ||
TOTAL_TRIP_DISTANCE | NUMBER | Total distance travelled by this trip | ||
STOPS | NUMBER | Total number of stops in this trip | ||
TOTAL_TRIP_COST | NUMBER | Total cost of this trip | ||
FIRST_DEPARTURE_DATE | VARCHAR2 | (80) | Departure DateTime at first stop | |
LAST_ARRIVAL_DATE | VARCHAR2 | (80) | Arrival DateTime at last stop | |
WEIGHT | NUMBER | Total weight carried by this trip | ||
CUBE | NUMBER | Total volume carried by this trip | ||
PALLETS | NUMBER | Total pallets carried by this trip | ||
PIECES | NUMBER | Total pieces carried by this trip | ||
ORDERS | NUMBER | Total orders carried by this trip | ||
FIRM_STATUS | NUMBER | Yes | Firm status (planned_flag) as stored in of mst_trips | |
FIRM_STATUS_DESC | VARCHAR2 | (80) | Yes | Routing and Contents Firm, Routing Firm, Not Firm etc. |
RELEASE | NUMBER | Flagged for release (selected_for_release in mst_trips) | ||
RELEASE_DESC | VARCHAR2 | (80) | Yes | Whether Flagged for release or not |
RELEASED | DATE | DateTime of release | ||
RELEASED_CH | VARCHAR2 | (4000) | ||
RELEASE_STATUS | NUMBER | Release status (release_status) as stored in of mst_trips | ||
RELEASE_STATUS_DESC | VARCHAR2 | (80) | Yes | Firm status at the time of release or failed |
CURRENCY_UOM | VARCHAR2 | (3) | Currency UOM as considered in plan | |
WEIGHT_UOM | VARCHAR2 | (3) | Weight UOM as considered in plan | |
CUBE_UOM | VARCHAR2 | (3) | Volume UOM as considered in plan |
Cut, paste (and edit) the following text to query this object:
SELECT PLAN_ID
, ROW_ID
, TRIP_ID
, CONTINUOUS_MOVE_ID
, CONTINUOUS_MOVE_SEQUENCE
, TRIP_NUMBER
, CARRIER_ID
, CARRIER_CODE
, SERVICE_LEVEL
, SERVICE_LEVEL_TL
, VEHICLE_TYPE
, TRIP_LOADING_STATUS
, ORIGIN_COMPANY
, ORIGIN_FACILITY_ID
, ORIGIN_FACILITY
, ORIGIN_FACILITY_DESC
, ORIGIN_CITY
, ORIGIN_STATE
, ORIGIN_ZIP
, ORIGIN_COUNTRY
, DESTINATION_COMPANY
, DESTINATION_FACILITY_ID
, DESTINATION_FACILITY
, DESTINATION_FACILITY_DESC
, DESTINATION_CITY
, DESTINATION_STATE
, DESTINATION_ZIP
, DESTINATION_COUNTRY
, TRIP_START_DATE
, TIME_ZONE1
, TRIP_END_DATE
, TOTAL_TRIP_DISTANCE
, STOPS
, TOTAL_TRIP_COST
, FIRST_DEPARTURE_DATE
, LAST_ARRIVAL_DATE
, WEIGHT
, CUBE
, PALLETS
, PIECES
, ORDERS
, FIRM_STATUS
, FIRM_STATUS_DESC
, RELEASE
, RELEASE_DESC
, RELEASED
, RELEASED_CH
, RELEASE_STATUS
, RELEASE_STATUS_DESC
, CURRENCY_UOM
, WEIGHT_UOM
, CUBE_UOM
FROM APPS.MST_CM_LOADS_V;
APPS.MST_CM_LOADS_V is not referenced by any database object
|
|
|