VIEW: APPS.MST_ACT_DELETE_LOAD_V

Source

View Text - Preformatted

SELECT mt.plan_id, mt.trip_id, mt.trip_number, wl1.city, wl1.state, wl2.city, wl2.state, substr(MST_WB_UTIL.get_meaning('WSH_MODE_OF_TRANSPORT', mt.mode_of_transport, 'WSH'), 1, 80), wc.freight_code, substr(MST_WB_UTIL.get_meaning('WSH_SERVICE_LEVELS', mt.service_level, 'WSH'), 1, 80), msikfv.concatenated_segments, mt.mode_of_transport from mst_trips mt, wsh_carriers wc, wsh_locations wl1, wsh_locations wl2, mtl_system_items_kfv msikfv, fte_vehicle_types fvt WHERE mt.carrier_id = wc.carrier_id and mt.origin_location_id = wl1.wsh_location_id and mt.destination_location_id = wl2.wsh_location_id and mt.vehicle_type_id = fvt.vehicle_type_id (+) and msikfv.inventory_item_id (+) = fvt.inventory_item_id and msikfv.organization_id (+) = fvt.organization_id

View Text - HTML Formatted

SELECT MT.PLAN_ID
, MT.TRIP_ID
, MT.TRIP_NUMBER
, WL1.CITY
, WL1.STATE
, WL2.CITY
, WL2.STATE
, SUBSTR(MST_WB_UTIL.GET_MEANING('WSH_MODE_OF_TRANSPORT'
, MT.MODE_OF_TRANSPORT
, 'WSH')
, 1
, 80)
, WC.FREIGHT_CODE
, SUBSTR(MST_WB_UTIL.GET_MEANING('WSH_SERVICE_LEVELS'
, MT.SERVICE_LEVEL
, 'WSH')
, 1
, 80)
, MSIKFV.CONCATENATED_SEGMENTS
, MT.MODE_OF_TRANSPORT
FROM MST_TRIPS MT
, WSH_CARRIERS WC
, WSH_LOCATIONS WL1
, WSH_LOCATIONS WL2
, MTL_SYSTEM_ITEMS_KFV MSIKFV
, FTE_VEHICLE_TYPES FVT
WHERE MT.CARRIER_ID = WC.CARRIER_ID
AND MT.ORIGIN_LOCATION_ID = WL1.WSH_LOCATION_ID
AND MT.DESTINATION_LOCATION_ID = WL2.WSH_LOCATION_ID
AND MT.VEHICLE_TYPE_ID = FVT.VEHICLE_TYPE_ID (+)
AND MSIKFV.INVENTORY_ITEM_ID (+) = FVT.INVENTORY_ITEM_ID
AND MSIKFV.ORGANIZATION_ID (+) = FVT.ORGANIZATION_ID