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_WEEKLY_FACTS

Object Details

Object Name:	BIM_R_LIMP_WEEKLY_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_WEEKLY_FACTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LEAD_REGION
BIM_R_LIMP_WEEKLY_FACTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LEAD_COUNTRY
BIM_R_LIMP_WEEKLY_FACTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_OBJECT_ID PARENT_OBJECT_TYPE LEAD_REGION LEAD_COUNTRY OBJECT_ID OBJECT_TYPE WEEKEND_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
WEEKLY_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 new leads added in import table
FAILURE_REASON	VARCHAR2	(2000)		Lead Import failure reason
WEEKEND_DATE	DATE			weekend 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

Query Text

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


SELECT WEEKLY_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
,      WEEKEND_DATE
,      SECURITY_GROUP_ID
,      METRIC1
,      METRIC2
,      METRIC3
,      METRIC4
,      METRIC5
,      METRIC6
,      METRIC7
,      METRIC8
,      METRIC9
,      METRIC10
FROM BIM.BIM_R_LIMP_WEEKLY_FACTS;

Dependencies

[top of page]

BIM.BIM_R_LIMP_WEEKLY_FACTS does not reference any database object

BIM.BIM_R_LIMP_WEEKLY_FACTS is referenced by following:

APPS: BIM_R_LIMP_WEEKLY_FACTS