DBA Data[Home] [Help] [Dependency Information]

TABLE: ICX.ICX_MARGIN_ANALYSIS_ERR

Object Details
Object Name: ICX_MARGIN_ANALYSIS_ERR
Object Type: TABLE
Owner: ICX
FND Design Data: TableICX.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.
.


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Columns
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
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
,      PERIOD
FROM ICX.ICX_MARGIN_ANALYSIS_ERR;

Dependencies

[top of page]

ICX.ICX_MARGIN_ANALYSIS_ERR does not reference any database object

ICX.ICX_MARGIN_ANALYSIS_ERR is referenced by following:

SchemaAPPS
SynonymICX_MARGIN_ANALYSIS_ERR