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_OPM_COGSTST_PRIOR

Object Details

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

Work Table for DBI COGS extraction

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
INVENTORY_ITEM_ID	NUMBER		Inventory Item Id .
ORGANIZATION_ID	NUMBER		Inventory Organization Id .
ORDER_LINE_ID	NUMBER		Order Line Id.
MARGIN_OU_ID	NUMBER		Margin Operating Unit Id.
COGS_VAL_B	NUMBER		COGS value in base currency.
COGS_DATE	DATE		COGS Date .
COGS_CURRENCY_CODE	VARCHAR2	(30)	Currency Code for COGS.
COGS_CONVERSION_RATE	NUMBER		Conversion rate for COGS from base currency to global currency .
SHIP_OU_ID	NUMBER		Shipping Operating Unit Id.
SELL_OU_ID	NUMBER		Selling Operating Unit Id.
TURNS_COGS_FLAG	VARCHAR2	(10)	Indicate if the COGS data is relevant for Inventory Turns computation. Default to Y.
SOURCE	VARCHAR2	(30)	Source.

Query Text

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


SELECT INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      ORDER_LINE_ID
,      MARGIN_OU_ID
,      COGS_VAL_B
,      COGS_DATE
,      COGS_CURRENCY_CODE
,      COGS_CONVERSION_RATE
,      SHIP_OU_ID
,      SELL_OU_ID
,      TURNS_COGS_FLAG
,      SOURCE
FROM OPI.OPI_DBI_OPM_COGSTST_PRIOR;

Dependencies

[top of page]

OPI.OPI_DBI_OPM_COGSTST_PRIOR does not reference any database object

OPI.OPI_DBI_OPM_COGSTST_PRIOR is referenced by following:

APPS: OPI_DBI_OPM_COGSTST_PRIOR