[Home] [Help] [Dependency Information]
Object Name: | MST_WSH_TRIP_STOPS_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 |
---|---|---|---|---|
STOP_ID | NUMBER | Yes | ||
TRIP_ID | NUMBER | Yes | ||
STOP_SEQUENCE_NUMBER | NUMBER | Yes | ||
STOP_LOCATION_ID | NUMBER | |||
PLANNED_ARRIVAL_DATE | DATE | |||
PLANNED_DEPARTURE_DATE | DATE | |||
PLN_UNLOADING_START_TIME | DATE | |||
PLN_UNLOADING_END_TIME | DATE | |||
PLN_LOADING_START_TIME | DATE | |||
PLN_LOADING_END_TIME | DATE | |||
DEPARTURE_GROSS_WEIGHT | NUMBER | |||
DEPARTURE_VOLUME | NUMBER | |||
DEPARTURE_PIECES | NUMBER | |||
DEPARTURE_PALLETS | NUMBER | |||
DEPARTURE_FILL_PERCENT | NUMBER | |||
DISTANCE_TO_NEXT_STOP | NUMBER | |||
DRV_TIME_TO_NEXT_STOP | NUMBER | |||
WKEND_LAYOVER_STOPS | NUMBER | |||
WKDAY_LAYOVER_STOPS | NUMBER | |||
TOTAL_LAYOVER_DURATION | NUMBER | |||
DISTANCE_COST | NUMBER | |||
CARRIER_LOADING_COST | NUMBER | |||
CARRIER_UNLOADING_COST | NUMBER | |||
CREATED_BY | NUMBER | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
WEIGHT_UOM_CODE | VARCHAR2 | (3) | ||
VOLUME_UOM_CODE | VARCHAR2 | (3) | ||
PHYSICAL_STOP_ID | NUMBER | Physical Stop Id |
Cut, paste (and edit) the following text to query this object:
SELECT STOP_ID
, TRIP_ID
, STOP_SEQUENCE_NUMBER
, STOP_LOCATION_ID
, PLANNED_ARRIVAL_DATE
, PLANNED_DEPARTURE_DATE
, PLN_UNLOADING_START_TIME
, PLN_UNLOADING_END_TIME
, PLN_LOADING_START_TIME
, PLN_LOADING_END_TIME
, DEPARTURE_GROSS_WEIGHT
, DEPARTURE_VOLUME
, DEPARTURE_PIECES
, DEPARTURE_PALLETS
, DEPARTURE_FILL_PERCENT
, DISTANCE_TO_NEXT_STOP
, DRV_TIME_TO_NEXT_STOP
, WKEND_LAYOVER_STOPS
, WKDAY_LAYOVER_STOPS
, TOTAL_LAYOVER_DURATION
, DISTANCE_COST
, CARRIER_LOADING_COST
, CARRIER_UNLOADING_COST
, CREATED_BY
, LAST_UPDATED_BY
, WEIGHT_UOM_CODE
, VOLUME_UOM_CODE
, PHYSICAL_STOP_ID
FROM APPS.MST_WSH_TRIP_STOPS_V;
APPS.MST_WSH_TRIP_STOPS_V is not referenced by any database object
|
|
|