VIEW: APPS.IC_SUMM_INV_V

Source

View Text - Preformatted

SELECT item_id , whse_code , qc_grade , sum(onhand_qty) , sum(onhand_qty2) , sum(onhand_prod_qty) , sum(onhand_prod_qty2) , sum(onhand_order_qty) , sum(onhand_order_qty2) , sum(onhand_ship_qty) , sum(onhand_ship_qty2) , sum(onpurch_qty) , sum(onpurch_qty2) , sum(onprod_qty) , sum(onprod_qty2) , sum(committedsales_qty) * -1 , sum(committedsales_qty2) * -1 , sum(committedprod_qty) * -1 , sum(committedprod_qty2) * -1 , sum(intransit_qty) , sum(intransit_qty2) , 0 , -1 , -1 , sysdate , sysdate , -1 , 0 , 0 , sysdate , 0 from ic_summ_inv_int_v group by item_id , whse_code , qc_grade

View Text - HTML Formatted

SELECT ITEM_ID
, WHSE_CODE
, QC_GRADE
, SUM(ONHAND_QTY)
, SUM(ONHAND_QTY2)
, SUM(ONHAND_PROD_QTY)
, SUM(ONHAND_PROD_QTY2)
, SUM(ONHAND_ORDER_QTY)
, SUM(ONHAND_ORDER_QTY2)
, SUM(ONHAND_SHIP_QTY)
, SUM(ONHAND_SHIP_QTY2)
, SUM(ONPURCH_QTY)
, SUM(ONPURCH_QTY2)
, SUM(ONPROD_QTY)
, SUM(ONPROD_QTY2)
, SUM(COMMITTEDSALES_QTY) * -1
, SUM(COMMITTEDSALES_QTY2) * -1
, SUM(COMMITTEDPROD_QTY) * -1
, SUM(COMMITTEDPROD_QTY2) * -1
, SUM(INTRANSIT_QTY)
, SUM(INTRANSIT_QTY2)
, 0
, -1
, -1
, SYSDATE
, SYSDATE
, -1
, 0
, 0
, SYSDATE
, 0
FROM IC_SUMM_INV_INT_V GROUP BY ITEM_ID
, WHSE_CODE
, QC_GRADE