VIEW: APPS.MST_AT_SUMMARY_V

Source

View Text - Preformatted

SELECT mp.plan_id , mp.compile_designator , mp.description , count(mt.trip_id) , mp.total_tl_weight , mp.weight_uom , mp.total_tl_volume , mp.volume_uom , mp.total_tl_pallets , mp.total_tl_pieces , mp.total_tl_orders , nvl(sum(mt.total_basic_transport_cost),0) , mp.currency_uom , nvl(sum(mt.total_stop_cost),0) , mp.currency_uom , nvl(sum(mt.total_load_unload_cost),0) , mp.currency_uom , nvl(sum(mt.total_layover_cost),0) , mp.currency_uom , nvl(sum(mt.total_accessorial_cost),0) + nvl(sum(mt.total_handling_cost),0) , mp.currency_uom , mp.currency_uom from mst_plans mp , mst_trips mt WHERE mp.plan_id = mt.plan_id and mt.mode_of_transport = 'TRUCK' group by mp.plan_id , mp.compile_designator , mp.description , mp.total_tl_weight , mp.weight_uom , mp.total_tl_volume , mp.volume_uom , mp.total_tl_pallets , mp.total_tl_pieces , mp.total_tl_orders , mp.currency_uom , mp.currency_uom , mp.currency_uom , mp.currency_uom , mp.currency_uom , mp.currency_uom

View Text - HTML Formatted

SELECT MP.PLAN_ID
, MP.COMPILE_DESIGNATOR
, MP.DESCRIPTION
, COUNT(MT.TRIP_ID)
, MP.TOTAL_TL_WEIGHT
, MP.WEIGHT_UOM
, MP.TOTAL_TL_VOLUME
, MP.VOLUME_UOM
, MP.TOTAL_TL_PALLETS
, MP.TOTAL_TL_PIECES
, MP.TOTAL_TL_ORDERS
, NVL(SUM(MT.TOTAL_BASIC_TRANSPORT_COST)
, 0)
, MP.CURRENCY_UOM
, NVL(SUM(MT.TOTAL_STOP_COST)
, 0)
, MP.CURRENCY_UOM
, NVL(SUM(MT.TOTAL_LOAD_UNLOAD_COST)
, 0)
, MP.CURRENCY_UOM
, NVL(SUM(MT.TOTAL_LAYOVER_COST)
, 0)
, MP.CURRENCY_UOM
, NVL(SUM(MT.TOTAL_ACCESSORIAL_COST)
, 0) + NVL(SUM(MT.TOTAL_HANDLING_COST)
, 0)
, MP.CURRENCY_UOM
, MP.CURRENCY_UOM
FROM MST_PLANS MP
, MST_TRIPS MT
WHERE MP.PLAN_ID = MT.PLAN_ID
AND MT.MODE_OF_TRANSPORT = 'TRUCK' GROUP BY MP.PLAN_ID
, MP.COMPILE_DESIGNATOR
, MP.DESCRIPTION
, MP.TOTAL_TL_WEIGHT
, MP.WEIGHT_UOM
, MP.TOTAL_TL_VOLUME
, MP.VOLUME_UOM
, MP.TOTAL_TL_PALLETS
, MP.TOTAL_TL_PIECES
, MP.TOTAL_TL_ORDERS
, MP.CURRENCY_UOM
, MP.CURRENCY_UOM
, MP.CURRENCY_UOM
, MP.CURRENCY_UOM
, MP.CURRENCY_UOM
, MP.CURRENCY_UOM