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_MARGIN_F

Object Details

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

This is a table to store data for product gross margin.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OPI_DBI_MARGIN_F_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	ORDER_LINE_ID MARGIN_OU_ID

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_DATE	DATE		Margin Date.
MARGIN_OU_ID	NUMBER		Margin Operating Unit Id.
COGS_VAL_B	NUMBER		COGS value in base currency.
COGS_CONVERSION_RATE	NUMBER		Conversion rate for COGS from base currency to global currency .
COGS_DATE	DATE		COGS Date .
COGS_SOURCE	VARCHAR2	(30)	COGS Source.
COGS_SHIP_OU_ID	NUMBER		COGS Shipping Operating Unit Id.
COGS_SELL_OU_ID	NUMBER		COGS Selling Operating Unit Id.
TURNS_COGS_FLAG	VARCHAR2	(10)	Indicate if the COGS data is relevant for Inventory Turns computation.
REVENUE_VAL_B	NUMBER		Revenue value in base currency.
REVENUE_VAL_G	NUMBER		Revenue value in global currency.
REVENUE_DATE	DATE		Revenue Date.
REVENUE_SHIP_OU_ID	NUMBER		Revenue Shipping Operating Unit Id.
REVENUE_SELL_OU_ID	NUMBER		Revenue Selling Operating Unit Id.
CREATION_DATE	DATE		Creation Date.
LAST_UPDATE_DATE	DATE		Last Update Date.
CREATED_BY	NUMBER		Standard who column.
LAST_UPDATED_BY	NUMBER		Standard who column.
LAST_UPDATE_LOGIN	NUMBER		Standard who column.

Query Text

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


SELECT INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      ORDER_LINE_ID
,      MARGIN_DATE
,      MARGIN_OU_ID
,      COGS_VAL_B
,      COGS_CONVERSION_RATE
,      COGS_DATE
,      COGS_SOURCE
,      COGS_SHIP_OU_ID
,      COGS_SELL_OU_ID
,      TURNS_COGS_FLAG
,      REVENUE_VAL_B
,      REVENUE_VAL_G
,      REVENUE_DATE
,      REVENUE_SHIP_OU_ID
,      REVENUE_SELL_OU_ID
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM OPI.OPI_DBI_MARGIN_F;

Dependencies

[top of page]

OPI.OPI_DBI_MARGIN_F does not reference any database object

OPI.OPI_DBI_MARGIN_F is referenced by following:

APPS: OPI_DBI_MARGIN_F