VIEW: APPS.MST_WSH_TRIPS_V

Source

View Text - Preformatted

SELECT wt.TRIP_ID TRIP_ID ,wt.MODE_OF_TRANSPORT MODE_OF_TRANSPORT , decode(ft.MOVE_TYPE_CODE, 'CONTINUOUS',decode(ft.planned_flag,'Y',ft.MOVE_ID,null),null) CONTINUOUS_MOVE_ID , decode(ft.MOVE_TYPE_CODE, 'CONTINUOUS', decode(ft.planned_flag,'Y',fwt.sequence_number, null),null) CONTINUOUS_MOVE_SEQUENCE ,to_number(NULL) MOVE_TYPE ,wt.PLANNED_FLAG ,wt.STATUS_CODE STATUS_CODE ,wt.LANE_ID LANE_ID ,wt.CARRIER_ID CARRIER_ID ,wt.SERVICE_LEVEL SERVICE_LEVEL ,fvt.VEHICLE_TYPE_ID VEHICLE_TYPE_ID ,wt.created_by created_by ,wt.last_updated_by last_updated_by ,to_number(NULL) ORIGIN_LOCATION_ID ,to_number(NULL) DESTINATION_LOCATION_ID ,to_date(NULL) TRIP_START_DATE ,to_date(NULL) TRIP_END_DATE ,to_number(NULL) TOTAL_TRIP_DISTANCE ,to_number(NULL) TOTAL_DIRECT_DISTANCE ,to_number(NULL) TOTAL_BASIC_TRANSPORT_COST ,to_number(NULL) TOTAL_STOP_COST ,to_number(NULL) TOTAL_LAYOVER_COST ,to_number(NULL) TOTAL_LOAD_UNLOAD_COST ,to_number(NULL) TOTAL_ACCESSORIAL_COST ,to_number(NULL) TOTAL_HANDLING_COST ,to_number(NULL) PEAK_PALLET_UTILIZATION ,to_number(NULL) PEAK_VOLUME_UTILIZATION ,to_number(NULL) PEAK_WEIGHT_UTILIZATION ,cs.CARRIER_SERVICE_ID CARRIER_SERVICE_ID FROM WSH_TRIPS wt, FTE_MOVES ft, FTE_TRIP_MOVES fwt, FTE_VEHICLE_TYPES fvt, WSH_CARRIER_SERVICES cs WHERE wt.trip_id = fwt.TRIP_ID (+) and fwt.MOVE_ID = ft.MOVE_ID (+) and wt.VEHICLE_ITEM_ID = fvt.INVENTORY_ITEM_ID (+) and wt.VEHICLE_ORGANIZATION_ID = fvt.ORGANIZATION_ID(+) and wt.SERVICE_LEVEL = cs.SERVICE_LEVEL (+) and wt.MODE_OF_TRANSPORT = cs.MODE_OF_TRANSPORT(+) and wt.CARRIER_ID = cs.carrier_id (+) and nvl(wt.ignore_for_planning, 'N') <> 'Y'

View Text - HTML Formatted

SELECT WT.TRIP_ID TRIP_ID
, WT.MODE_OF_TRANSPORT MODE_OF_TRANSPORT
, DECODE(FT.MOVE_TYPE_CODE
, 'CONTINUOUS'
, DECODE(FT.PLANNED_FLAG
, 'Y'
, FT.MOVE_ID
, NULL)
, NULL) CONTINUOUS_MOVE_ID
, DECODE(FT.MOVE_TYPE_CODE
, 'CONTINUOUS'
, DECODE(FT.PLANNED_FLAG
, 'Y'
, FWT.SEQUENCE_NUMBER
, NULL)
, NULL) CONTINUOUS_MOVE_SEQUENCE
, TO_NUMBER(NULL) MOVE_TYPE
, WT.PLANNED_FLAG
, WT.STATUS_CODE STATUS_CODE
, WT.LANE_ID LANE_ID
, WT.CARRIER_ID CARRIER_ID
, WT.SERVICE_LEVEL SERVICE_LEVEL
, FVT.VEHICLE_TYPE_ID VEHICLE_TYPE_ID
, WT.CREATED_BY CREATED_BY
, WT.LAST_UPDATED_BY LAST_UPDATED_BY
, TO_NUMBER(NULL) ORIGIN_LOCATION_ID
, TO_NUMBER(NULL) DESTINATION_LOCATION_ID
, TO_DATE(NULL) TRIP_START_DATE
, TO_DATE(NULL) TRIP_END_DATE
, TO_NUMBER(NULL) TOTAL_TRIP_DISTANCE
, TO_NUMBER(NULL) TOTAL_DIRECT_DISTANCE
, TO_NUMBER(NULL) TOTAL_BASIC_TRANSPORT_COST
, TO_NUMBER(NULL) TOTAL_STOP_COST
, TO_NUMBER(NULL) TOTAL_LAYOVER_COST
, TO_NUMBER(NULL) TOTAL_LOAD_UNLOAD_COST
, TO_NUMBER(NULL) TOTAL_ACCESSORIAL_COST
, TO_NUMBER(NULL) TOTAL_HANDLING_COST
, TO_NUMBER(NULL) PEAK_PALLET_UTILIZATION
, TO_NUMBER(NULL) PEAK_VOLUME_UTILIZATION
, TO_NUMBER(NULL) PEAK_WEIGHT_UTILIZATION
, CS.CARRIER_SERVICE_ID CARRIER_SERVICE_ID
FROM WSH_TRIPS WT
, FTE_MOVES FT
, FTE_TRIP_MOVES FWT
, FTE_VEHICLE_TYPES FVT
, WSH_CARRIER_SERVICES CS
WHERE WT.TRIP_ID = FWT.TRIP_ID (+)
AND FWT.MOVE_ID = FT.MOVE_ID (+)
AND WT.VEHICLE_ITEM_ID = FVT.INVENTORY_ITEM_ID (+)
AND WT.VEHICLE_ORGANIZATION_ID = FVT.ORGANIZATION_ID(+)
AND WT.SERVICE_LEVEL = CS.SERVICE_LEVEL (+)
AND WT.MODE_OF_TRANSPORT = CS.MODE_OF_TRANSPORT(+)
AND WT.CARRIER_ID = CS.CARRIER_ID (+)
AND NVL(WT.IGNORE_FOR_PLANNING
, 'N') <> 'Y'