VIEW: APPS.GML_GASNO_SUM_V

Source

View Text - Preformatted

SELECT od.bol_id bol_id, sum(od.net_wt) net_wt, sum(od.tare_wt) tare_wt, sum(od.pallet_wt) pallet_wt, sum(od.ship_volume) ship_volume FROM op_ordr_dtl od GROUP BY od.bol_id

View Text - HTML Formatted

SELECT OD.BOL_ID BOL_ID
, SUM(OD.NET_WT) NET_WT
, SUM(OD.TARE_WT) TARE_WT
, SUM(OD.PALLET_WT) PALLET_WT
, SUM(OD.SHIP_VOLUME) SHIP_VOLUME
FROM OP_ORDR_DTL OD GROUP BY OD.BOL_ID