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.PMIFV_PERIODINVENTORY_V

Object Details

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

View Type

A Business Intelligence System view

[View Source]

Columns

Name	Datatype	Length	Comments
QTY_ONHAND	NUMBER		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		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		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		Value of loct_usage. Equals loct_usage*accounting cost.
LAST_PERIOD_CLOSE_DATE	DATE		Last time Inventory Close was run.
WAREHOUSE_CODE	VARCHAR2	(4)	Warehouse which contains the item balances.
LOT_ID	NUMBER	(10)	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)	Location in the warehouse, if any, which contains the balance.
ITEM_ID	NUMBER	(10)	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)	Surrogate key of the period.
FISCAL_YEAR	VARCHAR2	(4)	Name of the inventory calendar.
CALENDER_DESCRIPTION	VARCHAR2	(40)	Cost Calendar Description
PERIOD_DESCRIPTION	VARCHAR2	(40)	Cost Period Description
PERIOD	NUMBER	(5)	Inventory period for which the balance is stored.
ITEM_NUMBER	VARCHAR2	(32)	Name of the item.
ITEM_DESCRIPTION	VARCHAR2	(70)	Short description of the item that is displayed during the item look up.
ITEM_UOM	VARCHAR2	(4)	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.
LOT_NUMBER	VARCHAR2	(32)	Code for the lot.
SUBLOT_NUMBER	VARCHAR2	(32)	Code for the sublot.
QC_GRADE	VARCHAR2	(4)	QC grade of the lot.
LOT_EXPIRE_DATE	DATE		Lot expiration date.
LOT_CREATION_DATE	DATE		Standard who column
VENDOR_LOT_NUMBER	VARCHAR2	(32)	Vendor lot number.
WAREHOUSE_NAME	VARCHAR2	(40)	Name of the warehouse.
ORGANIZATION_CODE	VARCHAR2	(4)	Organization that owns the warehouse.
CO_CODE	VARCHAR2	(4)	Company code of the organization.
LOCATION_DESCRIPTION	VARCHAR2	(40)	Description of the location.
LOCATION_CAPACITY	NUMBER		Capacity of the location.
CAPACITY_UM	VARCHAR2	(4)	Unit of measure in which the capacity is expressed.
STATUS_DESCRIPTION	VARCHAR2	(40)	Description of status.
QCHOLD_REASON_DESCRIPTION	VARCHAR2	(80)	Description of the QC hold reason.
PERIOD_START_DATE	DATE		Cost Period Start Date
PERIOD_END_DATE	DATE		Cost Period End Date
CREATED_BY	NUMBER	(15)	Standard who column
CREATION_DATE	DATE		Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Standard who column
LAST_UPDATE_DATE	DATE		Standard who column
PERIOD_STATUS	NUMBER		'0=frozen', 1= open'
PERIOD_STATUS_MEANING	VARCHAR2	(10)	meaning of period status 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
,      CALENDER_DESCRIPTION
,      PERIOD_DESCRIPTION
,      PERIOD
,      ITEM_NUMBER
,      ITEM_DESCRIPTION
,      ITEM_UOM
,      ITEM_UOM2
,      LOT_NUMBER
,      SUBLOT_NUMBER
,      QC_GRADE
,      LOT_EXPIRE_DATE
,      LOT_CREATION_DATE
,      VENDOR_LOT_NUMBER
,      WAREHOUSE_NAME
,      ORGANIZATION_CODE
,      CO_CODE
,      LOCATION_DESCRIPTION
,      LOCATION_CAPACITY
,      CAPACITY_UM
,      STATUS_DESCRIPTION
,      QCHOLD_REASON_DESCRIPTION
,      PERIOD_START_DATE
,      PERIOD_END_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      PERIOD_STATUS
,      PERIOD_STATUS_MEANING
FROM APPS.PMIFV_PERIODINVENTORY_V;

Dependencies

[top of page]

APPS.PMIFV_PERIODINVENTORY_V references the following:

APPS: GMD_HOLD_REASONS_VL; IC_ITEM_MST; IC_LOCT_INV; IC_LOCT_MST; IC_LOTS_MST; IC_LOTS_STS; IC_PERD_BAL; IC_WHSE_MST; PMI_COST_ANALZ_PACK - show dependent code; PMI_INV_CALENDAR_V; PMI_SECURITY_PKG - show dependent code; SY_ORGN_MST

APPS.PMIFV_PERIODINVENTORY_V is not referenced by any database object