VIEW: APPS.MST_WSH_TRIP_STOPS_V

Source

View Text - Preformatted

SELECT s.stop_id stop_id, s.trip_id trip_id, s.STOP_SEQUENCE_NUMBER STOP_SEQUENCE_NUMBER, nvl(s.PHYSICAL_LOCATION_ID, s.STOP_LOCATION_ID) STOP_LOCATION_ID, s.PLANNED_ARRIVAL_DATE PLANNED_ARRIVAL_DATE, s.PLANNED_DEPARTURE_DATE PLANNED_DEPARTURE_DATE, s.UNLOADING_START_DATETIME PLN_UNLOADING_START_TIME, s.UNLOADING_END_DATETIME PLN_UNLOADING_END_TIME, s.LOADING_START_DATETIME PLN_LOADING_START_TIME, s.LOADING_END_DATETIME PLN_LOADING_END_TIME, s.DEPARTURE_GROSS_WEIGHT DEPARTURE_GROSS_WEIGHT, s.DEPARTURE_VOLUME DEPARTURE_VOLUME, to_number(NULL) DEPARTURE_PIECES, to_number(NULL) DEPARTURE_PALLETS, to_number(NULL) DEPARTURE_FILL_PERCENT, to_number(NULL) DISTANCE_TO_NEXT_STOP , to_number(NULL) DRV_TIME_TO_NEXT_STOP, s.WKEND_LAYOVER_STOPS WKEND_LAYOVER_STOPS, s.WKDAY_LAYOVER_STOPS WKDAY_LAYOVER_STOPS, to_number(NULL) TOTAL_LAYOVER_DURATION, to_number(NULL) DISTANCE_COST, to_number(NULL) CARRIER_LOADING_COST, to_number(NULL) CARRIER_UNLOADING_COST, s.Created_by Created_by, s.Last_updated_by Last_updated_by, s.WEIGHT_UOM_CODE WEIGHT_UOM_CODE, s.VOLUME_UOM_CODE VOLUME_UOM_CODE, nvl(s.PHYSICAL_STOP_ID, s.STOP_ID) PHYSICAL_STOP_ID FROM WSH_TRIP_STOPS s

View Text - HTML Formatted

SELECT S.STOP_ID STOP_ID
, S.TRIP_ID TRIP_ID
, S.STOP_SEQUENCE_NUMBER STOP_SEQUENCE_NUMBER
, NVL(S.PHYSICAL_LOCATION_ID
, S.STOP_LOCATION_ID) STOP_LOCATION_ID
, S.PLANNED_ARRIVAL_DATE PLANNED_ARRIVAL_DATE
, S.PLANNED_DEPARTURE_DATE PLANNED_DEPARTURE_DATE
, S.UNLOADING_START_DATETIME PLN_UNLOADING_START_TIME
, S.UNLOADING_END_DATETIME PLN_UNLOADING_END_TIME
, S.LOADING_START_DATETIME PLN_LOADING_START_TIME
, S.LOADING_END_DATETIME PLN_LOADING_END_TIME
, S.DEPARTURE_GROSS_WEIGHT DEPARTURE_GROSS_WEIGHT
, S.DEPARTURE_VOLUME DEPARTURE_VOLUME
, TO_NUMBER(NULL) DEPARTURE_PIECES
, TO_NUMBER(NULL) DEPARTURE_PALLETS
, TO_NUMBER(NULL) DEPARTURE_FILL_PERCENT
, TO_NUMBER(NULL) DISTANCE_TO_NEXT_STOP
, TO_NUMBER(NULL) DRV_TIME_TO_NEXT_STOP
, S.WKEND_LAYOVER_STOPS WKEND_LAYOVER_STOPS
, S.WKDAY_LAYOVER_STOPS WKDAY_LAYOVER_STOPS
, TO_NUMBER(NULL) TOTAL_LAYOVER_DURATION
, TO_NUMBER(NULL) DISTANCE_COST
, TO_NUMBER(NULL) CARRIER_LOADING_COST
, TO_NUMBER(NULL) CARRIER_UNLOADING_COST
, S.CREATED_BY CREATED_BY
, S.LAST_UPDATED_BY LAST_UPDATED_BY
, S.WEIGHT_UOM_CODE WEIGHT_UOM_CODE
, S.VOLUME_UOM_CODE VOLUME_UOM_CODE
, NVL(S.PHYSICAL_STOP_ID
, S.STOP_ID) PHYSICAL_STOP_ID
FROM WSH_TRIP_STOPS S