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]

TABLE: PMI.PMI_ONHAND_SALE_SUM

Object Details

Object Name:	PMI_ONHAND_SALE_SUM
Object Type:	TABLE
Owner:	PMI
FND Design Data:	PMI.PMI_ONHAND_SALE_SUM
Subobject Name:
Status:	VALID

This table hold the summary of total Inventory . The summary consists of
On-Hand inventory and value, Sold inventory and value, Returned
inventory and value at Fiscal year,Quarter,Period,Warehouse level. The
Quanatities are calculated ina common UOM.This data is populated by a
Concurrent program 'PMI OnHand Sales Summary' registered under Process
Manufacturing Intelligence. This Table is used by Process Manufacturing
Intelligence reports and KPI.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PMI_ONHAND_SALE_SUM_PK	NORMAL	UNIQUE	APPS_TS_SUMMARY	FISCAL_YEAR ORGN_CODE WHSE_CODE PERIOD_ID ITEM_ID
PMI_ONHAND_SALE_SUM_I1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	PERIOD_ID FISCAL_YEAR

Columns

Name	Datatype	Length	Mandatory	Comments
FISCAL_YEAR	VARCHAR2	(4)	Yes	GL Fiscal Year
CO_CODE	VARCHAR2	(4)		Company Code
ORGN_CODE	VARCHAR2	(4)	Yes	Organization Code
WHSE_CODE	VARCHAR2	(4)	Yes	Warehouse Code
PERIOD_ID	NUMBER	(10)	Yes	Period ID
QUARTER	NUMBER	(15)		GL Calendar Quarter
PERIOD	NUMBER	(15)		GL Calendar Period
CONVERTIBLE_UOM	VARCHAR2	(4)		To convert entire data into single UOM
ITEM_ID	NUMBER	(10)	Yes	Item ID
ITEM_NO	VARCHAR2	(32)		Item Name
ITEM_UM	VARCHAR2	(4)		Item UOM
WHSE_ONHAND_QTY	NUMBER			Warehouse On-Hand Quantity in Primary UOM
WHSE_ONHAND_CONV	NUMBER			Warehouse On-Hand Quantity in Converted UOM
WHSE_ONHAND_VALUE	NUMBER			Warehouse On-Hand Inventory Value
WHSE_SALE_QTY	NUMBER			Warehouse Sale Quantity in Primary UOM
WHSE_SALE_CONV	NUMBER			Warehouse Sale Quantity in Converted UOM
WHSE_SALE_VALUE	NUMBER			Warehouse Sale Inventory Value
WHSE_RTRN_QTY	NUMBER			Warehouse Return Quantity in Primary UOM
WHSE_RTRN_CONV	NUMBER			Warehouse Return Quantity in Converted UOM
WHSE_RTRN_VALUE	NUMBER			Warehouse Return Inventory Value
LOG_END_DATE	DATE			Last Populated Date
PERIOD_IND	NUMBER			Period Indicator which indicates whether the period is open/closed (preliminary/final)
WHSE_NAME	VARCHAR2	(40)		Warehouse Name
ORGN_NAME	VARCHAR2	(40)		Organization name
PERIOD_NAME	VARCHAR2	(40)		GL Period Name
QUARTER_NAME	VARCHAR2	(40)		GL Quarter Name
PERIOD_SET_NAME	VARCHAR2	(40)		GL Period Set Name
GL_PERIOD_YEAR	NUMBER	(15)		GL Period Year
GL_FISCAL_YEAR_NAME	VARCHAR2	(15)		Gl Fiscal Year Name
GL_PERIOD_END_DATE	DATE			GL Period End Date
GL_PERIOD_START_DATE	DATE			GL Period Start Date
MISS_CONV_FACT_CNT	NUMBER			This column is required to show visual queue on the reports
GL_FISCAL_YEAR	NUMBER	(15)		GL Fiscal Year

Query Text

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


SELECT FISCAL_YEAR
,      CO_CODE
,      ORGN_CODE
,      WHSE_CODE
,      PERIOD_ID
,      QUARTER
,      PERIOD
,      CONVERTIBLE_UOM
,      ITEM_ID
,      ITEM_NO
,      ITEM_UM
,      WHSE_ONHAND_QTY
,      WHSE_ONHAND_CONV
,      WHSE_ONHAND_VALUE
,      WHSE_SALE_QTY
,      WHSE_SALE_CONV
,      WHSE_SALE_VALUE
,      WHSE_RTRN_QTY
,      WHSE_RTRN_CONV
,      WHSE_RTRN_VALUE
,      LOG_END_DATE
,      PERIOD_IND
,      WHSE_NAME
,      ORGN_NAME
,      PERIOD_NAME
,      QUARTER_NAME
,      PERIOD_SET_NAME
,      GL_PERIOD_YEAR
,      GL_FISCAL_YEAR_NAME
,      GL_PERIOD_END_DATE
,      GL_PERIOD_START_DATE
,      MISS_CONV_FACT_CNT
,      GL_FISCAL_YEAR
FROM PMI.PMI_ONHAND_SALE_SUM;

Dependencies

[top of page]

PMI.PMI_ONHAND_SALE_SUM does not reference any database object

PMI.PMI_ONHAND_SALE_SUM is referenced by following:

APPS: PMI_ONHAND_SALE_SUM