VIEW: APPS.MST_AP_SUMMARY_V

Source

View Text - Preformatted

SELECT mp.plan_id , mt.mode_of_transport , mp.compile_designator , mp.description , count(1) , mp.total_parcel_weight , mp.weight_uom , mp.total_parcel_volume , mp.volume_uom , mp.total_parcel_pallets , mp.total_parcel_pieces , mp.total_parcel_orders , nvl(sum(mt.total_basic_transport_cost),0) , mp.currency_uom , nvl(sum(mt.total_accessorial_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 = 'PARCEL' group by mp.plan_id , mt.mode_of_transport , mp.compile_designator , mp.description , mp.total_parcel_weight , mp.weight_uom , mp.total_parcel_volume , mp.volume_uom , mp.total_parcel_pallets , mp.total_parcel_pieces , mp.total_parcel_orders , mp.currency_uom , mp.currency_uom , mp.currency_uom

View Text - HTML Formatted

SELECT MP.PLAN_ID
, MT.MODE_OF_TRANSPORT
, MP.COMPILE_DESIGNATOR
, MP.DESCRIPTION
, COUNT(1)
, MP.TOTAL_PARCEL_WEIGHT
, MP.WEIGHT_UOM
, MP.TOTAL_PARCEL_VOLUME
, MP.VOLUME_UOM
, MP.TOTAL_PARCEL_PALLETS
, MP.TOTAL_PARCEL_PIECES
, MP.TOTAL_PARCEL_ORDERS
, NVL(SUM(MT.TOTAL_BASIC_TRANSPORT_COST)
, 0)
, MP.CURRENCY_UOM
, NVL(SUM(MT.TOTAL_ACCESSORIAL_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 = 'PARCEL' GROUP BY MP.PLAN_ID
, MT.MODE_OF_TRANSPORT
, MP.COMPILE_DESIGNATOR
, MP.DESCRIPTION
, MP.TOTAL_PARCEL_WEIGHT
, MP.WEIGHT_UOM
, MP.TOTAL_PARCEL_VOLUME
, MP.VOLUME_UOM
, MP.TOTAL_PARCEL_PALLETS
, MP.TOTAL_PARCEL_PIECES
, MP.TOTAL_PARCEL_ORDERS
, MP.CURRENCY_UOM
, MP.CURRENCY_UOM
, MP.CURRENCY_UOM