[Home] [Help] [Dependency Information]
Object Name: | ONT_PRT_MARGIN_ANA_ERR |
---|---|
Object Type: | TABLE |
Owner: | ONT |
FND Design Data: | ONT.ONT_PRT_MARGIN_ANA_ERR |
Subobject Name: | |
Status: | VALID |
ONT_PRT_MARGIN_ANA_ERR contains primary key values of the failing record while building the ONT_PRT_MARGIN_ANALYSIS table.
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BUILD_ID | NUMBER | Build identifier | ||
CUSTOMER_ID | NUMBER | Customer identifier | ||
PRIMARY_SALESREP_ID | NUMBER | Primary sales person identifier | ||
TERRITORY_ID | NUMBER | Territory identifier | ||
INVENTORY_ITEM_ID | NUMBER | Inventory item identifier | ||
PERIOD | VARCHAR2 | (3) | Yes | Period of the margin analysis: 7 days, 30 days, or 90 days |
Cut, paste (and edit) the following text to query this object:
SELECT BUILD_ID
, CUSTOMER_ID
, PRIMARY_SALESREP_ID
, TERRITORY_ID
, INVENTORY_ITEM_ID
, PERIOD
FROM ONT.ONT_PRT_MARGIN_ANA_ERR;
ONT.ONT_PRT_MARGIN_ANA_ERR does not reference any database object
ONT.ONT_PRT_MARGIN_ANA_ERR is referenced by following:
|
|
|