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_TEMP

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OPI_PMI_INV_DAILY_STAT_TEMP_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	ORGN_CODE WHSE_CODE ITEM_ID TRX_DATE CO_CODE LOT_ID LOCATION

Columns

Name	Datatype	Length	Mandatory
CO_CODE	VARCHAR2	(4)	Yes
ORGN_CODE	VARCHAR2	(4)	Yes
WHSE_CODE	VARCHAR2	(4)	Yes
LOCATION	VARCHAR2	(16)	Yes
ITEM_ID	NUMBER		Yes
LOT_ID	NUMBER		Yes
TRX_DATE	DATE		Yes
AVG_ONH_QTY	NUMBER
BEG_ONH_QTY	NUMBER
CREATION_DATE	DATE
END_ONH_QTY	NUMBER
FROM_ORG_QTY	NUMBER
INV_ADJ_QTY	NUMBER
LAST_UPDATE_DATE	DATE
PO_DEL_QTY	NUMBER
TOTAL_REC_QTY	NUMBER
TOT_CUST_SHIP_QTY	NUMBER
TOT_ISSUES_QTY	NUMBER
TO_ORG_QTY	NUMBER
WIP_COMP_QTY	NUMBER
WIP_ISSUE_QTY	NUMBER
PERIOD_FLAG	NUMBER
AVG_ONH_VAL_B	NUMBER
BEG_ONH_VAL_B	NUMBER
END_ONH_VAL_B	NUMBER
FROM_ORG_VAL_B	NUMBER
INV_ADJ_VAL_B	NUMBER
PO_DEL_VAL_B	NUMBER
TOTAL_REC_VAL_B	NUMBER
TOT_CUST_SHIP_VAL_B	NUMBER
TOT_ISSUES_VAL_B	NUMBER
TO_ORG_VAL_B	NUMBER
WIP_COMP_VAL_B	NUMBER
WIP_ISSUE_VAL_B	NUMBER
PERIOD_STATUS	NUMBER
DATA_PUSHED_IND	NUMBER

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_TEMP;

Dependencies

[top of page]

OPI.OPI_PMI_INV_DAILY_STAT_TEMP does not reference any database object

OPI.OPI_PMI_INV_DAILY_STAT_TEMP is referenced by following:

APPS: OPI_PMI_INV_DAILY_STAT_TEMP