[Home] [Help]
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
Name |
ITEM_ID |
WHSE_CODE |
QC_GRADE |
ONHAND_QTY |
ONHAND_QTY2 |
ONHAND_PROD_QTY |
ONHAND_PROD_QTY2 |
ONHAND_ORDER_QTY |
ONHAND_ORDER_QTY2 |
ONHAND_SHIP_QTY |
ONHAND_SHIP_QTY2 |
ONPURCH_QTY |
ONPURCH_QTY2 |
ONPROD_QTY |
ONPROD_QTY2 |
COMMITTEDSALES_QTY |
COMMITTEDSALES_QTY2 |
COMMITTEDPROD_QTY |
COMMITTEDPROD_QTY2 |
INTRANSIT_QTY |
INTRANSIT_QTY2 |
SUMM_INV_ID |
LAST_UPDATED_BY |
CREATED_BY |
LAST_UPDATE_DATE |
CREATION_DATE |
LAST_UPDATE_LOGIN |
PROGRAM_APPLICATION_ID |
PROGRAM_ID |
PROGRAM_UPDATE_DATE |
REQUEST_ID |