[Home] [Help] [Dependency Information]
Object Name: | MST_CM_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 | FK to mst_plans.plan_id | |
CONTINUOUS_MOVE_ID | NUMBER | Yes | FK to mst_cm_trips.cm_trip_id | |
CM_TRIP_NUMBER | NUMBER | Continuous move trip number | ||
CARRIER_ID | NUMBER | Carrier of the continuous move | ||
CARRIER_CODE | VARCHAR2 | (30) | Yes | Carrier name of conntinuous move |
SERVICE_LEVEL | VARCHAR2 | (30) | Untranslated service level of continuous move | |
SERVICE_LEVEL_TL | VARCHAR2 | (80) | Yes | Translated service level of continuous move |
VEHICLE_TYPE | VARCHAR2 | (40) | Vehicle type used for this continuous move | |
ORIGIN_ID | NUMBER | Yes | location_id of origin location of continuous move | |
ORIGIN_FACILITY | VARCHAR2 | (60) | Yes | Facility name of origin location of continuous move |
ORIGIN_FACILITY_DESC | VARCHAR2 | (250) | Facility description of origin location of continuous move | |
ORIGIN_CITY | VARCHAR2 | (120) | City of origin location of continuous move | |
ORIGIN_STATE | VARCHAR2 | (120) | State of origin location of continuous move | |
ORIGIN_ZIP | VARCHAR2 | (60) | Zip of origin location of continuous move | |
ORIGIN_COUNTRY | VARCHAR2 | (120) | Country of origin location of continuous move | |
DESTINATION_ID | NUMBER | Yes | location_id of destination location of continuous move | |
DESTINATION_FACILITY | VARCHAR2 | (60) | Yes | Facility name of destination location of continuous move |
DESTINATION_FACILITY_DESC | VARCHAR2 | (250) | Facility description of destination location of continuous move | |
DESTINATION_CITY | VARCHAR2 | (120) | City of destination location of continuous move | |
DESTINATION_STATE | VARCHAR2 | (120) | State of destination location of continuous move | |
DESTINATION_ZIP | VARCHAR2 | (60) | Zip of destination location of continuous move | |
DESTINATION_COUNTRY | VARCHAR2 | (120) | Country of destination location of continuous move | |
NUMBER_OF_LOADS | NUMBER | Total number of truckloads in this continuous move | ||
DISTANCE | NUMBER | Total distance covered in this continuous move | ||
TOTAL_CM_TRIP_COST | NUMBER | Total of cost of truckloads in this continuous move | ||
CURRENCY_UOM | VARCHAR2 | (3) | Currency uom as considered in plan | |
SAVINGS | NUMBER | Total saving because of formation of this continuous move | ||
FIRST_DEPARTURE | VARCHAR2 | (80) | Time of arrival of first truckload of this continuous move at its first stop | |
LAST_ARRIVAL | VARCHAR2 | (80) | Time of departure of last truckload of this continuous move at its last stop | |
FIRM_STATUS | NUMBER | Yes | 1 - Firm, 2 - Not firm, NULL - Not firm | |
FIRM_STATUS_DESC | VARCHAR2 | (80) | Description of firm status in string as per the saved firm status in number | |
RELEASE | NUMBER | 1 - Flagged for release otherwise not flagged for release | ||
RELEASE_DESC | VARCHAR2 | (80) | Yes | Description of selected for release in string as per the saved selected for release in number |
RELEASED | DATE | DateTime of release as saved in mst_cm_trips | ||
RELEASED_CH | VARCHAR2 | (4000) | ||
RELEASE_STATUS | NUMBER | 1 - Firm, 2 - Not firm, NULL - Not yet released | ||
RELEASE_STATUS_DESC | VARCHAR2 | (80) | Yes | Description of release status in string as per the saved release status in number |
AUTO_RELEASE_FLAG | NUMBER | 1 - auto relased, 2 or null - not auto released |
Cut, paste (and edit) the following text to query this object:
SELECT PLAN_ID
, CONTINUOUS_MOVE_ID
, CM_TRIP_NUMBER
, CARRIER_ID
, CARRIER_CODE
, SERVICE_LEVEL
, SERVICE_LEVEL_TL
, VEHICLE_TYPE
, ORIGIN_ID
, ORIGIN_FACILITY
, ORIGIN_FACILITY_DESC
, ORIGIN_CITY
, ORIGIN_STATE
, ORIGIN_ZIP
, ORIGIN_COUNTRY
, DESTINATION_ID
, DESTINATION_FACILITY
, DESTINATION_FACILITY_DESC
, DESTINATION_CITY
, DESTINATION_STATE
, DESTINATION_ZIP
, DESTINATION_COUNTRY
, NUMBER_OF_LOADS
, DISTANCE
, TOTAL_CM_TRIP_COST
, CURRENCY_UOM
, SAVINGS
, FIRST_DEPARTURE
, LAST_ARRIVAL
, FIRM_STATUS
, FIRM_STATUS_DESC
, RELEASE
, RELEASE_DESC
, RELEASED
, RELEASED_CH
, RELEASE_STATUS
, RELEASE_STATUS_DESC
, AUTO_RELEASE_FLAG
FROM APPS.MST_CM_V;
APPS.MST_CM_V is not referenced by any database object
|
|
|