[Home] [Help] [Dependency Information]
Object Name: | ICX_MARGIN_ANALYSIS_ERR |
---|---|
Object Type: | TABLE |
Owner: | ICX |
FND Design Data: | ICX.ICX_MARGIN_ANALYSIS_ERR |
Subobject Name: | |
Status: | VALID |
ICX_MARGIN_ANALYSIS_ERR contains primary key values of the
failing record while building the ICX_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 ICX.ICX_MARGIN_ANALYSIS_ERR;
ICX.ICX_MARGIN_ANALYSIS_ERR does not reference any database object
ICX.ICX_MARGIN_ANALYSIS_ERR is referenced by following:
|
|
|