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_TURNS_F

Object Details

Object Name:	OPI_DBI_INV_TURNS_F
Object Type:	TABLE
Owner:	OPI
Subobject Name:
Status:	VALID

Stores inventory balances and cost of goods sold for inventory turns reporting.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OPI_DBI_INV_TURNS_F_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	ORGANIZATION_ID TRANSACTION_DATE
OPI_DBI_INV_TURNS_F_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	TRANSACTION_DATE ORGANIZATION_ID

Columns

Name	Datatype	Mandatory	Comments
ORGANIZATION_ID	NUMBER	Yes	Organization id
TRANSACTION_DATE	DATE	Yes	Date of inventory activity.
START_DATE_WTD	DATE		Start date of week of transaction date.
START_DATE_MTD	DATE		Start date of month of transaction date.
START_DATE_QTD	DATE		Start date of quarter of transaction date.
START_DATE_YTD	DATE		Start date of year of transaction date.
WEIGHT	NUMBER		Number of days the inventory balance stayed at the inv_balance_b value.
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, 2 = OPM
CREATED_BY	NUMBER	Yes	Standard Who column.
LAST_UPDATE_LOGIN	NUMBER		Standard Who column.
CREATION_DATE	DATE	Yes	Standard Who column.
LAST_UPDATED_BY	NUMBER	Yes	Standard Who column.
LAST_UPDATE_DATE	DATE	Yes	Standard Who column.
INV_BALANCE_SG	NUMBER		Inventory Balance in secondary global currency
COGS_VAL_SG	NUMBER		COGS value in secondary global currency

Query Text

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


SELECT 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
,      INV_BALANCE_SG
,      COGS_VAL_SG
FROM OPI.OPI_DBI_INV_TURNS_F;

Dependencies

[top of page]

OPI.OPI_DBI_INV_TURNS_F does not reference any database object

OPI.OPI_DBI_INV_TURNS_F is referenced by following:

APPS: OPI_DBI_INV_TURNS_F