VIEW: APPS.MST_MAP_TRIP_LOV_V

Source

View Text - Preformatted

SELECT mt.plan_id, mt.trip_id, mt.trip_number, mt.carrier_id, wl1.city || ', '||wl1.state origin, wl2.city|| ', '||wl2.state destination, hz.party_name from mst_trips mt, wsh_carriers wc, wsh_locations wl1, wsh_locations wl2, hz_parties hz WHERE mt.carrier_id = wc.carrier_id AND wc.carrier_id = hz.party_id AND mt.origin_location_id = wl1.wsh_location_id AND mt.destination_location_id = wl2.wsh_location_id

View Text - HTML Formatted

SELECT MT.PLAN_ID
, MT.TRIP_ID
, MT.TRIP_NUMBER
, MT.CARRIER_ID
, WL1.CITY || '
, '||WL1.STATE ORIGIN
, WL2.CITY|| '
, '||WL2.STATE DESTINATION
, HZ.PARTY_NAME
FROM MST_TRIPS MT
, WSH_CARRIERS WC
, WSH_LOCATIONS WL1
, WSH_LOCATIONS WL2
, HZ_PARTIES HZ
WHERE MT.CARRIER_ID = WC.CARRIER_ID
AND WC.CARRIER_ID = HZ.PARTY_ID
AND MT.ORIGIN_LOCATION_ID = WL1.WSH_LOCATION_ID
AND MT.DESTINATION_LOCATION_ID = WL2.WSH_LOCATION_ID