eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: BIM.BIM_R_LIMP_ERROR_SUM_MV

Object Details

Object Name:	BIM_R_LIMP_ERROR_SUM_MV
Object Type:	TABLE
Owner:	BIM
Subobject Name:
Status:	VALID

Stores any error information during Lead Import

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	0
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BIM_R_LIMP_ERROR_SUM_MV_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LEAD_REGION LEAD_COUNTRY
BIM_R_LIMP_ERROR_SUM_MV_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	QTR MONTH YEAR

Columns

Name	Datatype	Length	Comments
LEAD_REGION	VARCHAR2	(30)	Lead region
LEAD_COUNTRY	VARCHAR2	(30)	Lead country
FAILURE_REASON	VARCHAR2	(2000)	Reason for failure
YEAR	VARCHAR2	(30)	Year
QTR	VARCHAR2	(30)	Quarter
MONTH	VARCHAR2	(30)	Month
MONTH_ORDER	NUMBER		Month order
AGGREGATE_BY	VARCHAR2	(9)	Summation By
DISPLAY_TYPE	VARCHAR2	(7)	Type of display
LEADS_INVALID	NUMBER		Invalid leads

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LEAD_REGION
,      LEAD_COUNTRY
,      FAILURE_REASON
,      YEAR
,      QTR
,      MONTH
,      MONTH_ORDER
,      AGGREGATE_BY
,      DISPLAY_TYPE
,      LEADS_INVALID
FROM BIM.BIM_R_LIMP_ERROR_SUM_MV;

Dependencies

[top of page]

BIM.BIM_R_LIMP_ERROR_SUM_MV does not reference any database object

BIM.BIM_R_LIMP_ERROR_SUM_MV is referenced by following:

BIM: BIM_R_LIMP_ERROR_SUM_MV#