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_PROD_SUM

Object Details

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

This table hold the summary of total Production usage and yield . The
summary consists of Production Usage and value, Produciton Yield 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 Production Summary' registered under Process Manufacturing
Intelligence. This Table is used by Process Manufacturing Intelligence
reports .

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PMI_PROD_SUM_PK	NORMAL	UNIQUE	APPS_TS_SUMMARY	FISCAL_YEAR ORGN_CODE WHSE_CODE PERIOD_ID ITEM_ID

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 Primary UOM
WHSE_USAGE_QTY	NUMBER			Warehouse Usage Quantity in Primary UOM
WHSE_USAGE_CONV	NUMBER			Warehouse Usage Quantity in Converted UOM
WHSE_USAGE_VALUE	NUMBER			Warehouse Usage Inventory Value
WHSE_YIELD_QTY	NUMBER			Warehouse Yield Quantity in Primary UOM
WHSE_YIELD_CONV	NUMBER			Warehouse Usage Quantity in Converted UOM
WHSE_YIELD_VALUE	NUMBER			Warehouse Yield 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_START_DATE	DATE			GL Period Start Date
GL_PERIOD_END_DATE	DATE			GL Period End 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_USAGE_QTY
,      WHSE_USAGE_CONV
,      WHSE_USAGE_VALUE
,      WHSE_YIELD_QTY
,      WHSE_YIELD_CONV
,      WHSE_YIELD_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_START_DATE
,      GL_PERIOD_END_DATE
,      MISS_CONV_FACT_CNT
,      GL_FISCAL_YEAR
FROM PMI.PMI_PROD_SUM;

Dependencies

[top of page]

PMI.PMI_PROD_SUM does not reference any database object

PMI.PMI_PROD_SUM is referenced by following:

APPS: PMI_PROD_SUM