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_PERIODINVENTORY_V

Object Details

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

View Type

A Business Intelligence System view

Qty and usage info for Items in Inv. for closed periods by whse, location, lot and item, unioned with Current inv. in the open period.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
QTY_ONHAND	NUMBER		Yes	Period ending balance of lot/item in secondary UOM of an item, for dual UOM items.
QTY_ONHAND_IN_UM2	NUMBER			Period ending balance of lot/item in primary UOM of an item.
QTY_USED	NUMBER		Yes	Consumption of the item in production during the period, in the primary inventory UOM of an item.
QTY_USED_IN_UM2	NUMBER			Consumption of the item in production during the period, in the secondary inventory UOM of an item, for dual UOM items.
YIELD	NUMBER		Yes	Yield of the item from production during the period, in the primary inventory UOM of an item.
YIELD_IN_UM2	NUMBER			Yield of the item from production during the period, in the secondary inventory UOM of an item, for dual UOM items.
VALUE	NUMBER		Yes	Value of loct_usage. Equals loct_usage*accounting cost.
LAST_PERIOD_CLOSE_DATE	DATE		Yes	Last time Inventory Close was run.
WAREHOUSE_CODE	VARCHAR2	(4)	Yes	Warehouse which contains the item balances.
LOT_ID	NUMBER	(10)	Yes	Surrogate key for the lot/sublot. 0 identifies the default lot. LOT_ID is set to '0' for items without lot control.
LOCATION	VARCHAR2	(16)	Yes	Location in the warehouse, if any, which contains the balance.
ITEM_ID	NUMBER	(10)	Yes	Surrogate key for the item.
LOT_STATUS	VARCHAR2	(4)		Status of the lot.
QC_HOLD_REASON_CODE	VARCHAR2	(4)		Reason code associated with the lot status.
PERIOD_ID	NUMBER	(10)	Yes	Surrogate key of the period.
FISCAL_YEAR	VARCHAR2	(4)	Yes	Name of the inventory calendar.
PERIOD	NUMBER	(5)	Yes	Inventory period for which the balance is stored.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column

Query Text

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


SELECT QTY_ONHAND
,      QTY_ONHAND_IN_UM2
,      QTY_USED
,      QTY_USED_IN_UM2
,      YIELD
,      YIELD_IN_UM2
,      VALUE
,      LAST_PERIOD_CLOSE_DATE
,      WAREHOUSE_CODE
,      LOT_ID
,      LOCATION
,      ITEM_ID
,      LOT_STATUS
,      QC_HOLD_REASON_CODE
,      PERIOD_ID
,      FISCAL_YEAR
,      PERIOD
,      LAST_UPDATED_BY
,      CREATED_BY
,      LAST_UPDATE_DATE
,      CREATION_DATE
FROM APPS.PMIBV_PERIODINVENTORY_V;

Dependencies

[top of page]

APPS.PMIBV_PERIODINVENTORY_V references the following:

APPS: IC_PERD_BAL

APPS.PMIBV_PERIODINVENTORY_V is not referenced by any database object