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: ONT.ONT_PRT_MARGIN_ANALYSIS

Object Details

Object Name:	ONT_PRT_MARGIN_ANALYSIS
Object Type:	TABLE
Owner:	ONT
FND Design Data:	ONT.ONT_PRT_MARGIN_ANALYSIS
Subobject Name:
Status:	VALID

ONT_PRT_MARGIN_ANALYSIS contains margin analysis information grouped by customer, item, territory, and sales person for three different time periods, last week, last 30 days, and last 90 days.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ONT_PRT_MARGIN_ANALYSIS_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	ORG_ID BUILD_ID CUSTOMER_ID PRIMARY_SALESREP_ID TERRITORY_ID INVENTORY_ITEM_ID PERIOD

Columns

Name	Datatype	Length	Mandatory	Comments
BUILD_ID	NUMBER		Yes	Build identifier
CUSTOMER_ID	NUMBER		Yes	Customer Identifier
PRIMARY_SALESREP_ID	NUMBER		Yes	Primary sales person identifier
TERRITORY_ID	NUMBER			Territory identifier
INVENTORY_ITEM_ID	NUMBER			Inventory item identifier
PARENT_INVENTORY_ITEM_ID	NUMBER			Parent inventory item identifier in case of a non-standard item
ORG_ID	NUMBER			Organization unique identifier
SOLD_TO_CUSTOMER_NAME	VARCHAR2	(50)		Customer name based on customer identifier
PERIOD	VARCHAR2	(3)	Yes	Period of the margin analysis: 7 days, 30 days, or 90 days
INVOICED_AMOUNT	NUMBER			Invoiced amount
COGS_AMOUNT	NUMBER			Cost of goods sold amount
MARGIN	NUMBER			Margin amount for the specified period

Query Text

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


SELECT BUILD_ID
,      CUSTOMER_ID
,      PRIMARY_SALESREP_ID
,      TERRITORY_ID
,      INVENTORY_ITEM_ID
,      PARENT_INVENTORY_ITEM_ID
,      ORG_ID
,      SOLD_TO_CUSTOMER_NAME
,      PERIOD
,      INVOICED_AMOUNT
,      COGS_AMOUNT
,      MARGIN
FROM ONT.ONT_PRT_MARGIN_ANALYSIS;

Dependencies

[top of page]

ONT.ONT_PRT_MARGIN_ANALYSIS does not reference any database object

ONT.ONT_PRT_MARGIN_ANALYSIS is referenced by following:

APPS: ONT_PRT_MARGIN_ANALYSIS; ONT_PRT_MARGIN_ANALYSIS_SYN