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

TABLE: ONT.ONT_PRT_MARGIN_ANA_ERR

Object Details
Object Name: ONT_PRT_MARGIN_ANA_ERR
Object Type: TABLE
Owner: ONT
FND Design Data: TableONT.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.


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 ONT.ONT_PRT_MARGIN_ANA_ERR;

Dependencies

[top of page]

ONT.ONT_PRT_MARGIN_ANA_ERR does not reference any database object

ONT.ONT_PRT_MARGIN_ANA_ERR is referenced by following:

SchemaAPPS
SynonymONT_PRT_MARGIN_ANA_ERR