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: TablePMI.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: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PMI_ONHAND_SALE_SUM_PK NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnFISCAL_YEAR
ColumnORGN_CODE
ColumnWHSE_CODE
ColumnPERIOD_ID
ColumnITEM_ID
PMI_ONHAND_SALE_SUM_I1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnPERIOD_ID
ColumnFISCAL_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:

SchemaAPPS
SynonymPMI_ONHAND_SALE_SUM