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_DBI_INV_VALUE_ORG_F

Object Details

Object Name:	OPI_DBI_INV_VALUE_ORG_F
Object Type:	TABLE
Owner:	OPI
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_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OPI_DBI_INV_VALUE_ORG_F_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	ORGANIZATION_ID TRANSACTION_DATE
OPI_DBI_INV_VALUE_ORG_F_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	TRANSACTION_DATE ORGANIZATION_ID

Columns

Name	Datatype	Mandatory	Comments
OPERATING_UNIT_ID	NUMBER	Yes	Operating Unit ID as in the OLTP system.
ORGANIZATION_ID	NUMBER	Yes	Organization ID as in the OLTP system.
TRANSACTION_DATE	DATE	Yes	Transaction date.
START_DATE_WTD	DATE		Start Week date of the Transaction Date.
START_DATE_MTD	DATE		Start Month date of the Transaction Date.
START_DATE_QTD	DATE		Start Quarter date of the Transaction Date.
START_DATE_YTD	DATE		Start Year date of the Transaction Date.
WEIGHT	NUMBER		Total Inventory Weight on Time.
INV_BALANCE_B	NUMBER		Total Inventory Balance in Functional Currency.
INV_BALANCE_G	NUMBER		Total Inventory Balance in Global Currency.
COGS_VAL_B	NUMBER		COGS Value in Functional Currency.
COGS_VAL_G	NUMBER		COGS Value in Global Currency.
SOURCE	NUMBER	Yes	Source = 1: OPI or 2: OPM.
CREATED_BY	NUMBER	Yes	Standard WHO column.
LAST_UPDATE_LOGIN	NUMBER		Standard WHO column.
CREATION_DATE	DATE	Yes	Creation Date.
LAST_UPDATED_BY	NUMBER	Yes	Standard WHO column.
LAST_UPDATE_DATE	DATE	Yes	Last Update Date.

Query Text

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


SELECT OPERATING_UNIT_ID
,      ORGANIZATION_ID
,      TRANSACTION_DATE
,      START_DATE_WTD
,      START_DATE_MTD
,      START_DATE_QTD
,      START_DATE_YTD
,      WEIGHT
,      INV_BALANCE_B
,      INV_BALANCE_G
,      COGS_VAL_B
,      COGS_VAL_G
,      SOURCE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM OPI.OPI_DBI_INV_VALUE_ORG_F;

Dependencies

[top of page]

OPI.OPI_DBI_INV_VALUE_ORG_F does not reference any database object

OPI.OPI_DBI_INV_VALUE_ORG_F is referenced by following:

APPS: OPI_DBI_INV_VALUE_ORG_F