eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.MST_DD_LOAD_SUMMARY_V

Source

View Text - Preformatted


SELECT mt.rowid , mt.plan_id , mt.trip_id , mt.trip_number , mt.carrier_id , mt.mode_of_transport , wlk.meaning , wc.freight_code , mt.service_level , wlk1.meaning , wl1.city , wl1.state , wl2.city , wl2.state , nvl(mt.total_basic_transport_cost,0) + nvl(mt.total_handling_cost,0) + nvl(total_accessorial_cost,0) + nvl(total_layover_cost,0) + nvl(total_load_unload_cost,0) + nvl(total_stop_cost,0) , mp.currency_uom , ml.meaning from mst_plans mp , mst_trips mt , wsh_locations wl1 , wsh_locations wl2 , wsh_carriers wc , mfg_lookups ml , wsh_lookups wlk , wsh_lookups wlk1 WHERE mp.plan_id = mt.plan_id and mt.origin_location_id = wl1.wsh_location_id and mt.destination_location_id = wl2.wsh_location_id and mt.carrier_id = wc.carrier_id and nvl(mt.planned_flag,4) = ml.lookup_code and ml.lookup_type = 'MST_TRIP_PLANNED_FLAG' and wlk.lookup_code = mt.mode_of_transport and wlk.lookup_type = 'WSH_MODE_OF_TRANSPORT' and wlk1.lookup_code = mt.service_level and wlk1.lookup_type = 'WSH_SERVICE_LEVELS'

View Text - HTML Formatted

SELECT MT.ROWID
, MT.PLAN_ID
, MT.TRIP_ID
, MT.TRIP_NUMBER
, MT.CARRIER_ID
, MT.MODE_OF_TRANSPORT
, WLK.MEANING
, WC.FREIGHT_CODE
, MT.SERVICE_LEVEL
, WLK1.MEANING
, WL1.CITY
, WL1.STATE
, WL2.CITY
, WL2.STATE
, NVL(MT.TOTAL_BASIC_TRANSPORT_COST
, 0) + NVL(MT.TOTAL_HANDLING_COST
, 0) + NVL(TOTAL_ACCESSORIAL_COST
, 0) + NVL(TOTAL_LAYOVER_COST
, 0) + NVL(TOTAL_LOAD_UNLOAD_COST
, 0) + NVL(TOTAL_STOP_COST
, 0)
, MP.CURRENCY_UOM
, ML.MEANING
FROM MST_PLANS MP
, MST_TRIPS MT
, WSH_LOCATIONS WL1
, WSH_LOCATIONS WL2
, WSH_CARRIERS WC
, MFG_LOOKUPS ML
, WSH_LOOKUPS WLK
, WSH_LOOKUPS WLK1
WHERE MP.PLAN_ID = MT.PLAN_ID
AND MT.ORIGIN_LOCATION_ID = WL1.WSH_LOCATION_ID
AND MT.DESTINATION_LOCATION_ID = WL2.WSH_LOCATION_ID
AND MT.CARRIER_ID = WC.CARRIER_ID
AND NVL(MT.PLANNED_FLAG
, 4) = ML.LOOKUP_CODE
AND ML.LOOKUP_TYPE = 'MST_TRIP_PLANNED_FLAG'
AND WLK.LOOKUP_CODE = MT.MODE_OF_TRANSPORT
AND WLK.LOOKUP_TYPE = 'WSH_MODE_OF_TRANSPORT'
AND WLK1.LOOKUP_CODE = MT.SERVICE_LEVEL
AND WLK1.LOOKUP_TYPE = 'WSH_SERVICE_LEVELS'