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_STG

Object Details

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

Staging table used to collect inventory balances on all days with activity and all period start boundaries for the inventory turns data extraction.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Comments
ORGANIZATION_ID	NUMBER	Organization id
TRANSACTION_DATE	DATE	Date of inventory activity.
INV_BALANCE_G	NUMBER	Total Inventory Balance in the global currency
INV_BALANCE_B	NUMBER	Total Inventory Balance in Functional Currency.
INV_BALANCE_SG	NUMBER	Inventory Balance in secondary global currency

Query Text

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


SELECT ORGANIZATION_ID
,      TRANSACTION_DATE
,      INV_BALANCE_G
,      INV_BALANCE_B
,      INV_BALANCE_SG
FROM OPI.OPI_DBI_INV_TURNS_STG;

Dependencies

[top of page]

OPI.OPI_DBI_INV_TURNS_STG does not reference any database object

OPI.OPI_DBI_INV_TURNS_STG is referenced by following:

APPS: OPI_DBI_INV_TURNS_STG