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: APPS.BIM_I_LD_AGE_SG_MV

Object Details

Object Name:	BIM_I_LD_AGE_SG_MV
Object Type:	TABLE
Owner:	APPS
FND Design Data:	FND.BIM_I_LD_AGE_SG_MV
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BIM_I_LD_AGE_SG_MV_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	GROUP_ID RESOURCE_ID DIM_ID

Columns

Name	Datatype	Length
UMARK	NUMBER
GROUP_ID	NUMBER
RESOURCE_ID	NUMBER
CHANNEL_CODE	VARCHAR2	(30)
CUST_CATEGORY	VARCHAR2	(30)
LEAD_RANK_ID	NUMBER
LEAD_SOURCE	VARCHAR2	(30)
LEAD_COUNTRY	VARCHAR2	(30)
DIM_ID	VARCHAR2	(7)
AGE_3_BELOW	NUMBER
AGE_3_TO_7	NUMBER
AGE_8_TO_14	NUMBER
AGE_15_TO_21	NUMBER
AGE_22_TO_28	NUMBER
AGE_29_TO_35	NUMBER
AGE_36_TO_42	NUMBER
AGE_42_TO_ABOVE	NUMBER
C_DAYS	NUMBER
P_DAYS	NUMBER
C_LEADS_OPEN	NUMBER
P_LEADS_OPEN	NUMBER
C_ADAYS	NUMBER
P_ADAYS	NUMBER
C_ALEADS_OPEN	NUMBER
P_ALEADS_OPEN	NUMBER

Query Text

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


SELECT UMARK
,      GROUP_ID
,      RESOURCE_ID
,      CHANNEL_CODE
,      CUST_CATEGORY
,      LEAD_RANK_ID
,      LEAD_SOURCE
,      LEAD_COUNTRY
,      DIM_ID
,      AGE_3_BELOW
,      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_42_TO_ABOVE
,      C_DAYS
,      P_DAYS
,      C_LEADS_OPEN
,      P_LEADS_OPEN
,      C_ADAYS
,      P_ADAYS
,      C_ALEADS_OPEN
,      P_ALEADS_OPEN
FROM APPS.BIM_I_LD_AGE_SG_MV;

Dependencies

[top of page]

APPS.BIM_I_LD_AGE_SG_MV does not reference any database object

APPS.BIM_I_LD_AGE_SG_MV is referenced by following:

APPS: BIM_I_LD_AGE_SG_MV