[Home] [Help]
View: GML_GASNO_SUM_V
Product: | GML - Process Manufacturing Logistics |
Description: | Total Weights view |
Implementation/DBA Data: |
APPS.GML_GASNO_SUM_V
|
View Text
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
Columns
Name |
BOL_ID |
NET_WT |
TARE_WT |
PALLET_WT |
SHIP_VOLUME |