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_LEAD_AGE_QU_SUM_MV

Object Details

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

Contains Information about the Lead Quality and their Aging

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	0
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BIM_R_LEAD_AGE_QU_SUM_MV_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GROUP_ID

Columns

Name	Datatype	Length	Comments
GROUP_ID	NUMBER		Group Identifier
RANK_MEANING	VARCHAR2	(240)	Rank Meaning
AGE_0_TO_1	NUMBER		Leads whose age is in between 0 to 1 year
AGE_2_TO_3	NUMBER		Leads whose age is in between 2 to 3 years
AGE_3_TO_7	NUMBER		Leads whose age is in between 3 to 7 years
AGE_8_TO_14	NUMBER		Leads whose age is in between 8 to 14 years
AGE_15_TO_21	NUMBER		Leads whose age is in between 15 to 21 years
AGE_22_TO_28	NUMBER		Leads whose age is in between 22 to 28 years
AGE_29_TO_35	NUMBER		Leads whose age is in between 29 to 35 years
AGE_36_TO_42	NUMBER		Leads whose age is in between 36 to 42 years
AGE_43_TO_ABOVE	NUMBER		Leads whose age is 43 years and above

Query Text

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


SELECT GROUP_ID
,      RANK_MEANING
,      AGE_0_TO_1
,      AGE_2_TO_3
,      AGE_3_TO_7
,      AGE_8_TO_14
,      AGE_15_TO_21
,      AGE_22_TO_28
,      AGE_29_TO_35
,      AGE_36_TO_42
,      AGE_43_TO_ABOVE
FROM BIM.BIM_R_LEAD_AGE_QU_SUM_MV;

Dependencies

[top of page]

BIM.BIM_R_LEAD_AGE_QU_SUM_MV does not reference any database object

BIM.BIM_R_LEAD_AGE_QU_SUM_MV is referenced by following:

BIM: BIM_R_LEAD_AGE_QU_SUM_MV#