[Home] [Help] [Dependency Information]
Object Name: | MST_LOAD_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 |
---|---|---|---|---|
PLAN_ID | NUMBER | Yes | FK to PLAN_ID of MST_PLANS. | |
TRIP_ID | NUMBER | Yes | Trip id. Foreign key to MST_TRIPS. | |
STOP_ID | NUMBER | Yes | FK to STOP_ID of MST_TRIP_STOPS. | |
STOP_NUMBER | NUMBER | Yes | Indicates sequence of stop on trip. | |
STOP_LOCATION_ID | NUMBER | Yes | Foreign key to WSH_LOCATIONS | |
ROW_ID | ROWID | (10) | Row id of MST_TRIP_STOPS | |
COMPANY | VARCHAR2 | (80) | Company Name of the Stop Facility. | |
FACILITY_ID | NUMBER | Yes | ID of Stop Facility. | |
FACILITY | VARCHAR2 | (60) | Yes | Name of Stop Facility. |
DESCRIPTION | VARCHAR2 | (250) | Description of Stop Facility. | |
CITY | VARCHAR2 | (120) | City of Stop Facility. | |
STATE | VARCHAR2 | (120) | State of Stop Facility. | |
ZIP | VARCHAR2 | (60) | Postal Code of Stop Facility. | |
COUNTRY | VARCHAR2 | (120) | Country of Stop Facility. | |
ARRIVAL_DATE_TIME | VARCHAR2 | (80) | Arrival Date at Stop. | |
ARR_DATETIME_HIDDEN | DATE | Hidden Field for Arrival Date at Stop. | ||
ARRIVAL_TIME_ZONE | VARCHAR2 | (10) | Arrival Date Time zone. | |
DEPARTURE_DATE_TIME | VARCHAR2 | (80) | Departure Date from Stop. | |
DEP_DATETIME_HIDDEN | DATE | Hidden Field for Departure Date from Stop. | ||
DEPARTURE_TIME_ZONE | VARCHAR2 | (10) | Departure Date Time zone. | |
STOP_TIME | VARCHAR2 | (12) | Total Stop Time. | |
LOAD_WEIGHT | NUMBER | Weight at Departure. | ||
LOAD_CUBE | NUMBER | Cube at Departure. | ||
PALLETS | NUMBER | Pallets at Departure. | ||
PIECES | NUMBER | Pieces at Departure. | ||
WEIGHT_UNLOADED | NUMBER | Weight Unloaded at stop. | ||
CUBE_UNLOADED | NUMBER | Cube Unloaded at stop. | ||
PALLETS_UNLOADED | NUMBER | Pallets Unloaded at stop. | ||
PIECES_UNLOADED | NUMBER | Pieces Unloaded at stop. | ||
WEIGHT_LOADED | NUMBER | Weight loaded at stop. | ||
CUBE_LOADED | NUMBER | Cube loaded at stop. | ||
PALLETS_LOADED | NUMBER | Pallets loaded at stop. | ||
PIECES_LOADED | NUMBER | Pieces loaded at stop. | ||
WEIGHT_UOM | VARCHAR2 | (3) | Unit of Measure for Weight. | |
VOLUME_UOM | VARCHAR2 | (3) | Unit of Measure for Volume. |
Cut, paste (and edit) the following text to query this object:
SELECT PLAN_ID
, TRIP_ID
, STOP_ID
, STOP_NUMBER
, STOP_LOCATION_ID
, ROW_ID
, COMPANY
, FACILITY_ID
, FACILITY
, DESCRIPTION
, CITY
, STATE
, ZIP
, COUNTRY
, ARRIVAL_DATE_TIME
, ARR_DATETIME_HIDDEN
, ARRIVAL_TIME_ZONE
, DEPARTURE_DATE_TIME
, DEP_DATETIME_HIDDEN
, DEPARTURE_TIME_ZONE
, STOP_TIME
, LOAD_WEIGHT
, LOAD_CUBE
, PALLETS
, PIECES
, WEIGHT_UNLOADED
, CUBE_UNLOADED
, PALLETS_UNLOADED
, PIECES_UNLOADED
, WEIGHT_LOADED
, CUBE_LOADED
, PALLETS_LOADED
, PIECES_LOADED
, WEIGHT_UOM
, VOLUME_UOM
FROM APPS.MST_LOAD_STOPS_V;
APPS.MST_LOAD_STOPS_V is not referenced by any database object
|
|
|