eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PMIBV_INV_SUMMARY_V

Product:	PMI - Process Manufacturing Intelligence
Description:	The purpose of this view is to find the Inventory balance by item/warehouse/grade. This view also birngs in the item information from the Item Master Table.
Implementation/DBA Data:	APPS.PMIBV_INV_SUMMARY_V

View Text

SELECT INVSUM.ONHAND_QTY
, /* REGULAR ATTRIBUTES */ INVSUM.ONHAND_QTY2
, INVSUM.ONHAND_PROD_QTY
, INVSUM.ONHAND_PROD_QTY2
, INVSUM.ONHAND_ORDER_QTY
, INVSUM.ONHAND_ORDER_QTY2
, INVSUM.ONHAND_SHIP_QTY
, INVSUM.ONHAND_SHIP_QTY2
, INVSUM.ONPURCH_QTY
, INVSUM.ONPURCH_QTY2
, INVSUM.ONPROD_QTY
, INVSUM.ONPROD_QTY2
, INVSUM.COMMITTEDSALES_QTY
, INVSUM.COMMITTEDSALES_QTY2
, INVSUM.COMMITTEDPROD_QTY
, INVSUM.COMMITTEDPROD_QTY2
, INVSUM.INTRANSIT_QTY
, INVSUM.INTRANSIT_QTY2
, ITEM.ITEM_ID
, /* ID */ INVSUM.WHSE_CODE
, INVSUM.QC_GRADE
, ITEM.ITEM_NO
, ITEM.ITEM_DESC1
, ITEM.ALT_ITEMA
, ITEM.ALT_ITEMB
, ITEM.ITEM_UM
, ITEM.ITEM_UM2
, ITEM.PLANNING_CLASS
, INVSUM.CREATED_BY
, INVSUM.CREATION_DATE
, INVSUM.LAST_UPDATE_DATE
, INVSUM.LAST_UPDATED_BY
FROM IC_SUMM_INV INVSUM
, IC_ITEM_MST ITEM
WHERE ITEM.ITEM_ID = INVSUM.ITEM_ID(+) WITH READ ONLY

Columns

Name
ONHAND_QTY
ONHAND_QTY2
ONHAND_PRODUCTION_QTY
ONHAND_PRODUCTION_QTY2
ONHAND_ORDER_QTY
ONHAND_ORDER_QTY2
ONHAND_SHIP_QTY
ONHAND_SHIP_QTY2
ONPURCH_QTY
ONPURCH_QTY2
PRODUCTION_PENDING_QTY
PRODUCTION_PENDING_QTY2
COMMITTED_SALES_QTY
COMMITTED_SALES_QTY2
COMMITTED_PRODUCTION_QTY
COMMITTED_PRODUCTION_QTY2
INTRANSIT_QTY
NTRANSIT_QTY2
ITEM_ID
WHSE_CODE
QC_GRADE
ITEM_NO
ITEM_DESCRIPTION
ALTERNATE_ITEMA
ALTERNATE_ITEMB
ITEM_UOM
ITEM_UOM2
PLANNING_CLASS
CREATED_BY
CREATION_DATE
LAST_UPDATE_DATE
LAST_UPDATED_BY