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_DAILY_FACTS

Object Details

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

Stores lead import facts information

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BIM_R_LIMP_DAILY_FACTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LEAD_REGION
BIM_R_LIMP_DAILY_FACTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LEAD_COUNTRY
BIM_R_LIMP_DAILY_FACTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_CREATE_DATE LEAD_REGION LEAD_COUNTRY OBJECT_ID OBJECT_TYPE PARENT_OBJECT_ID PARENT_OBJECT_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
DAILY_TRANSACTION_ID	NUMBER		Yes	Unique Identifier
CREATION_DATE	DATE			Who column
LAST_UPDATE_DATE	DATE			Who column
CREATED_BY	NUMBER			Who column
LAST_UPDATED_BY	NUMBER			Who column
LAST_UPDATE_LOGIN	NUMBER			Who column
LEAD_REGION	VARCHAR2	(30)		Region where lead is generated
LEAD_COUNTRY	VARCHAR2	(30)		Country in which lead is generated
OBJECT_BUSINESS_UNIT_ID	NUMBER			Business Unit of the object generating the lead
LEAD_IMPORT_STATUS	VARCHAR2	(30)		Import status (Success or Error)
OBJECT_ID	NUMBER			Object Identifier
OBJECT_TYPE	VARCHAR2	(30)		Object Type (CSCH, EONE, EVEO)
PARENT_OBJECT_ID	NUMBER			Parent object Identifier
PARENT_OBJECT_TYPE	VARCHAR2	(30)		Parent Object type (CAMP or EVEH)
YEAR	VARCHAR2	(30)		Year
QTR	VARCHAR2	(30)		Quarter
MONTH	VARCHAR2	(30)		Month
LEADS_VALID	NUMBER			No of leads valid
LEADS_INVALID	NUMBER			No of leads invalid
LEADS_NEW	NUMBER			Number of hot leads in current period
FAILURE_REASON	VARCHAR2	(2000)		Lead Import failure reason
TRANSACTION_CREATE_DATE	DATE			Record creation date
WEEKEND_DATE	DATE			weekend date for transaction create date
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
METRIC1	NUMBER			Future Usage
METRIC2	NUMBER			Future Usage
METRIC3	NUMBER			Future Usage
METRIC4	NUMBER			Future Usage
METRIC5	NUMBER			Future Usage
METRIC6	NUMBER			Future Usage
METRIC7	NUMBER			Future Usage
METRIC8	NUMBER			Future Usage
METRIC9	NUMBER			Future Usage
METRIC10	NUMBER			Future Usage
METRIC11	NUMBER			Future Usage
METRIC12	NUMBER			Future Usage
METRIC13	NUMBER			Future Usage
METRIC14	NUMBER			Future Usage
METRIC15	NUMBER			Future Usage

Query Text

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


SELECT DAILY_TRANSACTION_ID
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LEAD_REGION
,      LEAD_COUNTRY
,      OBJECT_BUSINESS_UNIT_ID
,      LEAD_IMPORT_STATUS
,      OBJECT_ID
,      OBJECT_TYPE
,      PARENT_OBJECT_ID
,      PARENT_OBJECT_TYPE
,      YEAR
,      QTR
,      MONTH
,      LEADS_VALID
,      LEADS_INVALID
,      LEADS_NEW
,      FAILURE_REASON
,      TRANSACTION_CREATE_DATE
,      WEEKEND_DATE
,      SECURITY_GROUP_ID
,      METRIC1
,      METRIC2
,      METRIC3
,      METRIC4
,      METRIC5
,      METRIC6
,      METRIC7
,      METRIC8
,      METRIC9
,      METRIC10
,      METRIC11
,      METRIC12
,      METRIC13
,      METRIC14
,      METRIC15
FROM BIM.BIM_R_LIMP_DAILY_FACTS;

Dependencies

[top of page]

BIM.BIM_R_LIMP_DAILY_FACTS does not reference any database object

BIM.BIM_R_LIMP_DAILY_FACTS is referenced by following:

BIM: BIM_R_LIMP_DAILY_FACTS#