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: OPI.OPI_PMI_INV_DAILY_STAT_SUM

Object Details

Object Name:	OPI_PMI_INV_DAILY_STAT_SUM
Object Type:	TABLE
Owner:	OPI
FND Design Data:	OPI.OPI_PMI_INV_DAILY_STAT_SUM
Subobject Name:
Status:	VALID

OLTP-Side Summary Table, used for preprocessing IDS Staging Table rows

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OPI_PMI_INV_DAILY_STAT_SUM_PK	NORMAL	UNIQUE	APPS_TS_SUMMARY	CO_CODE ORGN_CODE WHSE_CODE LOCATION ITEM_ID LOT_ID TRX_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
CO_CODE	VARCHAR2	(4)	Yes	OPM Company Code
ORGN_CODE	VARCHAR2	(4)	Yes	OPM Organization Code
WHSE_CODE	VARCHAR2	(4)	Yes	OPM Warehouse Code
LOCATION	VARCHAR2	(16)	Yes	OPM Location
ITEM_ID	NUMBER		Yes	OPM Item ID
LOT_ID	NUMBER		Yes	OPM Lot ID
TRX_DATE	DATE		Yes	Transaction Date
AVG_ONH_QTY	NUMBER			Average On-Hand Quantity
BEG_ONH_QTY	NUMBER			Beginning On-Hand Quantity
CREATION_DATE	DATE			Creation Date
END_ONH_QTY	NUMBER			Ending On-Hand Quantity
FROM_ORG_QTY	NUMBER			Inter-Org Transfer Quantity
INV_ADJ_QTY	NUMBER			Inventory Adjustment Quantity
LAST_UPDATE_DATE	DATE			Last Update Date
PO_DEL_QTY	NUMBER			Quantity Received from Purchases
TOTAL_REC_QTY	NUMBER			Total Quantity Received from Purchasing, Manufacturing, Transfer, Misc Receipts
TOT_CUST_SHIP_QTY	NUMBER			Total Quantity Shipped to Satisfy Customer Orders
TOT_ISSUES_QTY	NUMBER			Total Quanity Issued to Sales and Transfer Shipments, Manufacturing
TO_ORG_QTY	NUMBER			Quantity Received via transfer from other Warehouses
WIP_COMP_QTY	NUMBER			Quantity Received From Manufacturing
WIP_ISSUE_QTY	NUMBER			Quantity Issued to Manufacturing
PERIOD_FLAG	NUMBER			Flag indicating that record is a Period Summary
AVG_ONH_VAL_B	NUMBER			Average On-Hand Value
BEG_ONH_VAL_B	NUMBER			Beginning On-Hand Value
END_ONH_VAL_B	NUMBER			Ending On-Hand Value
FROM_ORG_VAL_B	NUMBER			Value of Transfers from this Org to Other Orgs
INV_ADJ_VAL_B	NUMBER			Value of Inventory Adjustments
PO_DEL_VAL_B	NUMBER			Value of Purchase Receipts
TOTAL_REC_VAL_B	NUMBER			Total Value of Receipts
TOT_CUST_SHIP_VAL_B	NUMBER			Value of Customer Shipments
TOT_ISSUES_VAL_B	NUMBER			Total Value of Issues to Sales and Transfer Shipments, Manufacturing
TO_ORG_VAL_B	NUMBER			Value of Transfers to this Org from Other Orgs
WIP_COMP_VAL_B	NUMBER			Value of Receipts from Manufacturing
WIP_ISSUE_VAL_B	NUMBER			Value of Issues to Manufacturing
PERIOD_STATUS	NUMBER			Status of Calendar Period
DATA_PUSHED_IND	NUMBER			Indicator of whether this row has been pushed before

Query Text

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


SELECT CO_CODE
,      ORGN_CODE
,      WHSE_CODE
,      LOCATION
,      ITEM_ID
,      LOT_ID
,      TRX_DATE
,      AVG_ONH_QTY
,      BEG_ONH_QTY
,      CREATION_DATE
,      END_ONH_QTY
,      FROM_ORG_QTY
,      INV_ADJ_QTY
,      LAST_UPDATE_DATE
,      PO_DEL_QTY
,      TOTAL_REC_QTY
,      TOT_CUST_SHIP_QTY
,      TOT_ISSUES_QTY
,      TO_ORG_QTY
,      WIP_COMP_QTY
,      WIP_ISSUE_QTY
,      PERIOD_FLAG
,      AVG_ONH_VAL_B
,      BEG_ONH_VAL_B
,      END_ONH_VAL_B
,      FROM_ORG_VAL_B
,      INV_ADJ_VAL_B
,      PO_DEL_VAL_B
,      TOTAL_REC_VAL_B
,      TOT_CUST_SHIP_VAL_B
,      TOT_ISSUES_VAL_B
,      TO_ORG_VAL_B
,      WIP_COMP_VAL_B
,      WIP_ISSUE_VAL_B
,      PERIOD_STATUS
,      DATA_PUSHED_IND
FROM OPI.OPI_PMI_INV_DAILY_STAT_SUM;

Dependencies

[top of page]

OPI.OPI_PMI_INV_DAILY_STAT_SUM does not reference any database object

OPI.OPI_PMI_INV_DAILY_STAT_SUM is referenced by following:

APPS: OPI_PMI_INV_DAILY_STAT_SUM