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


VIEW: APPS.MST_CONTINUOUS_MOVES_V

Object Details
Object Name: MST_CONTINUOUS_MOVES_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
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.
Query Text

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;

Dependencies

[top of page]

APPS.MST_CONTINUOUS_MOVES_V references the following:

SchemaAPPS
PL/SQL PackageFND_DATE - show dependent code
SynonymFTE_VEHICLE_TYPES
SynonymMST_CM_TRIPS
SynonymMST_PLANS
PL/SQL PackageMST_WB_UTIL - show dependent code
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymWSH_CARRIERS

APPS.MST_CONTINUOUS_MOVES_V is not referenced by any database object