[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
ONT.ONT_PRT_MARGIN_ANALYSIS does not reference any database object
ONT.ONT_PRT_MARGIN_ANALYSIS is referenced by following:
|
|
|