Multilevel subtotal of columns [message #334052] |
Tue, 15 July 2008 05:54  |
yogeshyl
Messages: 50 Registered: October 2007 Location: Silvassa
|
Member |
|
|
In the below given query, i want to display the subtotal of the following columns
1)(PRI_QTY_BU/IU_MAX_LOOSE_1)RQTY,
2)((PRI_QTY_BU/IU_MAX_LOOSE_1)*CGCV_COST_1)RMVALUE
Kindly suggest how could i do this?
SELECT DISTINCT PRWD_WO_NO PWO_NO,
PRI_ITEM_CODE,
ITEM_NAME,
(PRI_QTY_BU/IU_MAX_LOOSE_1)RQTY,
((PRI_QTY_BU / IU_MAX_LOOSE_1) * CGCV_COST_1) RMVALUE
FROM OT_PR_ITEM,
OS_COST_GROUP_CURR_VAL,
OM_ITEM,
OM_ITEM_UOM,
OT_PR_WO_DETAIL
WHERE PRI_ITEM_CODE = CGCV_ITEM_CODE
AND PRI_ITEM_CODE = ITEM_CODE
AND PRI_ITEM_CODE = IU_ITEM_CODE
AND PRWD_SYS_ID = PRI_PRWD_SYS_ID
AND CGCV_COST_GROUP_CODE = 'CGSIL001'
GROUP BY PRI_PRWD_SYS_ID,
PRWD_WO_NO,
PRI_ITEM_CODE,
ITEM_NAME,
CGCV_COST_1,
PRI_QTY,
PRI_QTY_LS,
PRI_QTY_BU,
IU_MAX_LOOSE_1
ORDER BY PRWD_WO_NO
Yogesh
|
|
|
|