View: IC_SUMM_INV_V

Product:	GMI - Process Manufacturing Inventory
Description:	GMI summary inventory view
Implementation/DBA Data:	APPS.IC_SUMM_INV_V

View Text

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

Columns