[Home] [Help] [Dependency Information]
Object Name: | MST_CONTINUOUS_MOVES_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 PLAN_ID of MST_PLANS | |
PLAN_NAME | VARCHAR2 | (10) | Yes | Plan Name. |
DESCRIPTION | VARCHAR2 | (50) | Plan Description. | |
ROW_ID | ROWID | (10) | Row id of MST_CM_TRIPS | |
CM_TRIP_NUMBER | NUMBER | Continuous Move Number. | ||
CONTINUOUS_MOVE_ID | NUMBER | Yes | FK to CONTINUOUS_MOVE_ID of MST_CM_TRIPS | |
CARRIER_ID | NUMBER | ID of Carrier for the Continuous Move. | ||
CARRIER | VARCHAR2 | (30) | Yes | Name of Carrier for the Continuous Move. |
SERVICE | VARCHAR2 | (30) | ID of Carrier Service for the Continuous Move. | |
SERVICE_DESC | VARCHAR2 | (80) | Description of Carrier Service for the Continuous Move. | |
VEHICLE_TYPE_ID | NUMBER | ID of Carrier Vehicle for the Continuous Move. | ||
VEHICLE | VARCHAR2 | (40) | Description of Carrier Vehicle for the Continuous Move. | |
TOTAL_TRANSPORTATION_COST | NUMBER | Transportation Cost of the Continuous Move. | ||
TOTAL_SAVING | NUMBER | Savings resulted from Continuous Move over Independent Trips. | ||
TOTAL_LOADS | NUMBER | Count of Trips in the Continuous move. | ||
TOTAL_DISTANCE | NUMBER | Distance of the Continuous Move. | ||
DISTANCE_UOM | VARCHAR2 | (3) | Unit of Measure for Distance. | |
CURRENCY_UOM1 | VARCHAR2 | (3) | Unit of Measure for Transportation Cost. | |
CURRENCY_UOM2 | VARCHAR2 | (3) | Unit of Measure for Cost Savings. | |
FIRM_STATUS | NUMBER | Yes | Status of Continuous Move. | |
RELEASE_STATUS | NUMBER | Release status of Continuous Move. | ||
RELEASE_STATUS_DESC | VARCHAR2 | (80) | Description of Release status of Continuous Move. | |
RELEASED | DATE | Date of release for Continuous Move. | ||
RELEASED_CH | VARCHAR2 | (4000) | ||
RELEASE | NUMBER | Flag to indicate release of Continuous Move. | ||
CHANGED_BY_USER | NUMBER | Flag to indicate User Edit for Continuous Move. | ||
LOCKED_FOR_IMPACT | NUMBER | Flag to indicate Lock on continuous Move. |
Cut, paste (and edit) the following text to query this object:
SELECT PLAN_ID
, PLAN_NAME
, DESCRIPTION
, ROW_ID
, CM_TRIP_NUMBER
, CONTINUOUS_MOVE_ID
, CARRIER_ID
, CARRIER
, SERVICE
, SERVICE_DESC
, VEHICLE_TYPE_ID
, VEHICLE
, TOTAL_TRANSPORTATION_COST
, TOTAL_SAVING
, TOTAL_LOADS
, TOTAL_DISTANCE
, DISTANCE_UOM
, CURRENCY_UOM1
, CURRENCY_UOM2
, FIRM_STATUS
, RELEASE_STATUS
, RELEASE_STATUS_DESC
, RELEASED
, RELEASED_CH
, RELEASE
, CHANGED_BY_USER
, LOCKED_FOR_IMPACT
FROM APPS.MST_CONTINUOUS_MOVES_V;
APPS.MST_CONTINUOUS_MOVES_V is not referenced by any database object
|
|
|