VIEW: APPS.MST_ACT_EMPTY_TRIPS_V

Source

View Text - Preformatted

SELECT mt.plan_id , mt.trip_id , mt.planned_flag , mor.in_request_id , mt.trip_number , mt.mode_of_transport , wlk1.meaning , wc.freight_code , wlk2.meaning , flp1.facility_code , wl1.city , wl1.state , wl1.postal_code , wl1.country , flp2.facility_code , wl2.city , wl2.state , wl2.postal_code , wl2.country from mst_trips mt, mst_out_requests mor, mst_in_requests mir, wsh_carriers wc, fte_location_parameters flp1, fte_location_parameters flp2, wsh_locations wl1, wsh_locations wl2, wsh_lookups wlk1, wsh_lookups wlk2 WHERE mir.in_request_id = mor.in_request_id and mor.plan_id = mt.plan_id and mor.trip_id = mt.trip_id and mt.carrier_id = wc.carrier_id and mt.origin_location_id = wl1.wsh_location_id and wl1.wsh_location_id = flp1.location_id and mt.destination_location_id = wl2.wsh_location_id and wl2.wsh_location_id = flp2.location_id and mt.mode_of_transport = wlk1.lookup_code and wlk1.lookup_type = 'WSH_MODE_OF_TRANSPORT' and mt.service_level = wlk2.lookup_code and wlk2.lookup_type = 'WSH_SERVICE_LEVELS'

View Text - HTML Formatted

SELECT MT.PLAN_ID
, MT.TRIP_ID
, MT.PLANNED_FLAG
, MOR.IN_REQUEST_ID
, MT.TRIP_NUMBER
, MT.MODE_OF_TRANSPORT
, WLK1.MEANING
, WC.FREIGHT_CODE
, WLK2.MEANING
, FLP1.FACILITY_CODE
, WL1.CITY
, WL1.STATE
, WL1.POSTAL_CODE
, WL1.COUNTRY
, FLP2.FACILITY_CODE
, WL2.CITY
, WL2.STATE
, WL2.POSTAL_CODE
, WL2.COUNTRY
FROM MST_TRIPS MT
, MST_OUT_REQUESTS MOR
, MST_IN_REQUESTS MIR
, WSH_CARRIERS WC
, FTE_LOCATION_PARAMETERS FLP1
, FTE_LOCATION_PARAMETERS FLP2
, WSH_LOCATIONS WL1
, WSH_LOCATIONS WL2
, WSH_LOOKUPS WLK1
, WSH_LOOKUPS WLK2
WHERE MIR.IN_REQUEST_ID = MOR.IN_REQUEST_ID
AND MOR.PLAN_ID = MT.PLAN_ID
AND MOR.TRIP_ID = MT.TRIP_ID
AND MT.CARRIER_ID = WC.CARRIER_ID
AND MT.ORIGIN_LOCATION_ID = WL1.WSH_LOCATION_ID
AND WL1.WSH_LOCATION_ID = FLP1.LOCATION_ID
AND MT.DESTINATION_LOCATION_ID = WL2.WSH_LOCATION_ID
AND WL2.WSH_LOCATION_ID = FLP2.LOCATION_ID
AND MT.MODE_OF_TRANSPORT = WLK1.LOOKUP_CODE
AND WLK1.LOOKUP_TYPE = 'WSH_MODE_OF_TRANSPORT'
AND MT.SERVICE_LEVEL = WLK2.LOOKUP_CODE
AND WLK2.LOOKUP_TYPE = 'WSH_SERVICE_LEVELS'