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_EDW_PERD_MARGIN_F

Object Details

Object Name:	OPI_EDW_PERD_MARGIN_F
Object Type:	TABLE
Owner:	OPI
FND Design Data:	OPI.OPI_EDW_PERD_MARGIN_F
Subobject Name:
Status:	VALID

This is the product gross margin fact table summarized at period level, and is derived from product gross margin fact. It contains the product sales revenue and the matching cost of goods sold by period.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OPI_EDW_PERD_MARGIN_F_U	NORMAL	UNIQUE	APPS_TS_SUMMARY	ITEM_ORG_FK_KEY SHIP_LOCATION_FK_KEY CUSTOMER_FK_KEY BILL_TO_LOC_FK_KEY SHIP_TO_LOC_FK_KEY PRIM_SALES_REP_FK_KEY OPERATING_UNIT_FK_KEY PROJECT_FK_KEY MARGIN_PERIOD_FK_KEY SALES_CHANNEL_FK_KEY UOM_FK_KEY BASE_CURR_FK_KEY SOB_FK_KEY INSTANCE_FK_KEY USER_FK5_KEY USER_FK4_KEY USER_FK3_KEY USER_FK2_KEY USER_FK1_KEY
OPI_EDW_PERD_MARGIN_F_N1	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	BASE_CURR_FK_KEY
OPI_EDW_PERD_MARGIN_F_N10	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	SALES_CHANNEL_FK_KEY
OPI_EDW_PERD_MARGIN_F_N11	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	SHIP_LOCATION_FK_KEY
OPI_EDW_PERD_MARGIN_F_N12	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	SHIP_TO_LOC_FK_KEY
OPI_EDW_PERD_MARGIN_F_N13	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	SOB_FK_KEY
OPI_EDW_PERD_MARGIN_F_N14	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	UOM_FK_KEY
OPI_EDW_PERD_MARGIN_F_N2	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	BILL_TO_LOC_FK_KEY
OPI_EDW_PERD_MARGIN_F_N3	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	CUSTOMER_FK_KEY
OPI_EDW_PERD_MARGIN_F_N4	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	INSTANCE_FK_KEY
OPI_EDW_PERD_MARGIN_F_N5	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	ITEM_ORG_FK_KEY
OPI_EDW_PERD_MARGIN_F_N6	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	MARGIN_PERIOD_FK_KEY
OPI_EDW_PERD_MARGIN_F_N7	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	OPERATING_UNIT_FK_KEY
OPI_EDW_PERD_MARGIN_F_N8	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	PRIM_SALES_REP_FK_KEY
OPI_EDW_PERD_MARGIN_F_N9	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	PROJECT_FK_KEY

Columns

Name	Datatype	Length	Comments
ITEM_ORG_FK_KEY	NUMBER		System generated foreign key to the Item dimension
OPERATING_UNIT_FK_KEY	NUMBER		System generated foreign key to the Internal Org dimension
SOB_FK_KEY	NUMBER		System generated foreign key to the Set of Books dimension.
CUSTOMER_FK_KEY	NUMBER		System generated foreign key to the Trading Partner dimension
SALES_CHANNEL_FK_KEY	NUMBER		System generated foreign key to the Sales Channel dimension
INSTANCE_FK_KEY	NUMBER		System generated foreign key to the Instance dimension
PRIM_SALES_REP_FK_KEY	NUMBER		System generated foreign key to the HR Person dimension (primary sales representative of the account)
BILL_TO_LOC_FK_KEY	NUMBER		System generated foreign key to the Geography dimension (bill to location)
SHIP_TO_LOC_FK_KEY	NUMBER		System generated foreign key to the Geography dimension (ship to location)
PROJECT_FK_KEY	NUMBER		system generated foreign key to the Projects dimension
UOM_FK_KEY	NUMBER		System generated foreign key to the UOM dimension (unit of measurement)
SHIP_LOCATION_FK_KEY	NUMBER		System generated foreign key to the Inventory Locator Dimension
MARGIN_PERIOD_FK_KEY	NUMBER		System generated foreign key to the Time dimension at period level.
COGS_G	NUMBER		Cost of sales in Warehouse currency summarized at period level
COGS_B	NUMBER		Cost of sales in functional currency summarized at period level
PROD_AMT_G	NUMBER		Product sales revenue in Warehouse currency summarized at period level
PROD_AMT_B	NUMBER		Product sales revenue in functional currency summarized at period level
PROD_LINE_QTY_INVOICED	NUMBER		Product quantity invoiced in Base UOM summarized at period level
PROD_LINE_QTY_CREDITED	NUMBER		Product quantity credited to customer in Base UOM summarized at period level
SHIPPED_QTY	NUMBER		Quantity shipped to customer in Base UOM summarized at period level
RMA_QTY	NUMBER		Quantity returned by customer in Base UOM summarized at period level
ICAP_QTY	NUMBER		Quantity from Inter company Account Payable invoices in Base UOM summarized at period level
LAST_UPDATE_DATE	DATE		Last Update Date
CREATION_DATE	DATE		Creation Date
USER_FK5_KEY	NUMBER		User defined foreign key5
USER_FK4_KEY	NUMBER		User defined foreign key4
USER_FK3_KEY	NUMBER		User defined foreign key3
USER_FK2_KEY	NUMBER		User defined foreign key2
USER_FK1_KEY	NUMBER		User defined foreign key1
USER_MEASURE5	NUMBER		User defined measure5
USER_MEASURE4	NUMBER		User defined measure4
USER_MEASURE3	NUMBER		User defined measure3
USER_MEASURE2	NUMBER		User defined measure2
USER_MEASURE1	NUMBER		User defined measure1
USER_ATTRIBUTE15	VARCHAR2	(240)	User defined attribute15
USER_ATTRIBUTE14	VARCHAR2	(240)	User defined attribute14
USER_ATTRIBUTE13	VARCHAR2	(240)	User defined attribute13
USER_ATTRIBUTE12	VARCHAR2	(240)	User defined attribute12
USER_ATTRIBUTE11	VARCHAR2	(240)	User defined attribute11
USER_ATTRIBUTE10	VARCHAR2	(240)	User defined attribute10
USER_ATTRIBUTE9	VARCHAR2	(240)	User defined attribute9
USER_ATTRIBUTE8	VARCHAR2	(240)	User defined attribute8
USER_ATTRIBUTE7	VARCHAR2	(240)	User defined attribute7
USER_ATTRIBUTE6	VARCHAR2	(240)	User defined attribute6
USER_ATTRIBUTE5	VARCHAR2	(240)	User defined attribute5
USER_ATTRIBUTE4	VARCHAR2	(240)	User defined attribute4
USER_ATTRIBUTE3	VARCHAR2	(240)	User defined attribute3
USER_ATTRIBUTE2	VARCHAR2	(240)	User defined attribute2
USER_ATTRIBUTE1	VARCHAR2	(240)	User defined attribute1
BASE_CURR_FK_KEY	NUMBER		System generated foreign key to the Currency dimension
MARGIN_PERIOD_PK	VARCHAR2	(240)	PK for Margin Period Summary.
PRIM_SALESRESOURCE_FK_KEY	NUMBER		System generated foreign key to the Sales Resource dimension (Primary Sales Rep)

Query Text

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


SELECT ITEM_ORG_FK_KEY
,      OPERATING_UNIT_FK_KEY
,      SOB_FK_KEY
,      CUSTOMER_FK_KEY
,      SALES_CHANNEL_FK_KEY
,      INSTANCE_FK_KEY
,      PRIM_SALES_REP_FK_KEY
,      BILL_TO_LOC_FK_KEY
,      SHIP_TO_LOC_FK_KEY
,      PROJECT_FK_KEY
,      UOM_FK_KEY
,      SHIP_LOCATION_FK_KEY
,      MARGIN_PERIOD_FK_KEY
,      COGS_G
,      COGS_B
,      PROD_AMT_G
,      PROD_AMT_B
,      PROD_LINE_QTY_INVOICED
,      PROD_LINE_QTY_CREDITED
,      SHIPPED_QTY
,      RMA_QTY
,      ICAP_QTY
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      USER_FK5_KEY
,      USER_FK4_KEY
,      USER_FK3_KEY
,      USER_FK2_KEY
,      USER_FK1_KEY
,      USER_MEASURE5
,      USER_MEASURE4
,      USER_MEASURE3
,      USER_MEASURE2
,      USER_MEASURE1
,      USER_ATTRIBUTE15
,      USER_ATTRIBUTE14
,      USER_ATTRIBUTE13
,      USER_ATTRIBUTE12
,      USER_ATTRIBUTE11
,      USER_ATTRIBUTE10
,      USER_ATTRIBUTE9
,      USER_ATTRIBUTE8
,      USER_ATTRIBUTE7
,      USER_ATTRIBUTE6
,      USER_ATTRIBUTE5
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE1
,      BASE_CURR_FK_KEY
,      MARGIN_PERIOD_PK
,      PRIM_SALESRESOURCE_FK_KEY
FROM OPI.OPI_EDW_PERD_MARGIN_F;

Dependencies

[top of page]

OPI.OPI_EDW_PERD_MARGIN_F does not reference any database object

OPI.OPI_EDW_PERD_MARGIN_F is referenced by following:

APPS: OPI_EDW_PERD_MARGIN_F