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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.PMIBV_INV_SUMMARY_V

Object Details

Object Name:	PMIBV_INV_SUMMARY_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PMI.PMIBV_INV_SUMMARY_V
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

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.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ONHAND_QTY	NUMBER			Total nettable qty of this item/grade in this warehouse, expressed in the primary unit of measure of an item.
ONHAND_QTY2	NUMBER			Total nettable qty of this item/grade in this warehouse, expressed in the secondary unit of measure of an item, if dual UOM controlled.
ONHAND_PRODUCTION_QTY	NUMBER			Total qty available for use as a production ingredient, expressed in the primary UOM of an item.
ONHAND_PRODUCTION_QTY2	NUMBER			Total qty available for use as a production ingredient, expressed in the secondary UOM of an itemif dual UOM controlled.
ONHAND_ORDER_QTY	NUMBER			Total qty available for ordering, expressed in the primary UOM of an item.
ONHAND_ORDER_QTY2	NUMBER			Total qty available for ordering, expressed in the secondary UOM of an item, if dual UOM controlled.
ONHAND_SHIP_QTY	NUMBER			Total qty available for shipping, expressed in the primary UOM of an item.
ONHAND_SHIP_QTY2	NUMBER			Total qty available for shipping, expressed in the secondary UOM of an item, if dual UOM controlled.
ONPURCH_QTY	NUMBER			Total qty pending from purchase orders, expressed in the primary UOM of an item.
ONPURCH_QTY2	NUMBER			Total qty pending from purchase orders, expressed in the secondary UOM of an item if dual UOM controlled.
PRODUCTION_PENDING_QTY	NUMBER			Total qty of product pending from production, expressed in the primary UOM of an item.
PRODUCTION_PENDING_QTY2	NUMBER			Total qty of product pending from production, expressed in the secondary UOM of an item.
COMMITTED_SALES_QTY	NUMBER			Total qty committed to sales orders and shipments, expressed in the primary UOM of an item.
COMMITTED_SALES_QTY2	NUMBER			Total qty committed to sales orders and shipments, expressed in the secondary UOM of an item if dual UOM controlled.
COMMITTED_PRODUCTION_QTY	NUMBER			Total qty of ingredient committed to batches, expressed in the primary UOM of an item.
COMMITTED_PRODUCTION_QTY2	NUMBER			Total qty of ingredient committed to batches, expressed in the secondary UOM of an item if dual UOM controlled.
INTRANSIT_QTY	NUMBER			Not currently used.
NTRANSIT_QTY2	NUMBER			Not currently used.
ITEM_ID	NUMBER	(10)	Yes	Surrogate key for the item.
WHSE_CODE	VARCHAR2	(4)		Warehouse in which the inventory is located.
QC_GRADE	VARCHAR2	(4)		Grade of the inventory. NULL value denotes that QC Grade does not apply to item.
ITEM_NO	VARCHAR2	(32)	Yes	Name of the item.
ITEM_DESCRIPTION	VARCHAR2	(70)	Yes	Short description of the item that is displayed during the item look up.
ALTERNATE_ITEMA	VARCHAR2	(32)		Alternate name for the item.
ALTERNATE_ITEMB	VARCHAR2	(32)		Second alternate name for the item.
ITEM_UOM	VARCHAR2	(4)	Yes	Uom of the item by which the inventory balances are maintained.
ITEM_UOM2	VARCHAR2	(4)		Second UOM for in which inventory balances are maintained, for dual UOM items.
PLANNING_CLASS	VARCHAR2	(8)		Planning class for an item. Used for MPS and MRP reporting.
CREATED_BY	NUMBER			Standard who column
CREATION_DATE	DATE			Standard who column
LAST_UPDATE_DATE	DATE			Standard who column
LAST_UPDATED_BY	NUMBER			Standard who column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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
FROM APPS.PMIBV_INV_SUMMARY_V;

Dependencies

[top of page]

APPS.PMIBV_INV_SUMMARY_V references the following:

APPS: IC_ITEM_MST; IC_SUMM_INV

APPS.PMIBV_INV_SUMMARY_V is not referenced by any database object