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]

MATERIALIZED VIEW: APPS.BIM_I_LP_AGE_SG_MV

Object Details

Object Name:	BIM_I_LP_AGE_SG_MV
Object Type:	MATERIALIZED VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

M-View Details

Container:	BIM_I_LP_AGE_SG_MV
Updatable:	N
Rewrite Enabled:	N
Rewrite Capability:	NONE
Refresh Mode:	DEMAND
Refresh Method:	COMPLETE
Build Mode:	DEFERRED
Fast Refreshable:	NO

MV Log Dependencies:


MTL_DEFAULT_CATEGORY_SETS

[View Source Query]

Columns

Name	Datatype	Length
UMARK	NUMBER
GROUP_ID	NUMBER
RESOURCE_ID	NUMBER
PRODUCT_CATEGORY_ID	NUMBER
CHANNEL_CODE	VARCHAR2	(30)
CUST_CATEGORY	VARCHAR2	(30)
LEAD_RANK_ID	NUMBER
LEAD_SOURCE	VARCHAR2	(30)
LEAD_COUNTRY	VARCHAR2	(30)
ITEM_ID	VARCHAR2	(25)
ORGANIZATION_ID	NUMBER
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
,      PRODUCT_CATEGORY_ID
,      CHANNEL_CODE
,      CUST_CATEGORY
,      LEAD_RANK_ID
,      LEAD_SOURCE
,      LEAD_COUNTRY
,      ITEM_ID
,      ORGANIZATION_ID
,      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_LP_AGE_SG_MV;

Dependencies

[top of page]

APPS.BIM_I_LP_AGE_SG_MV references the following:

APPS: BIM_I_LP_AGE_SG_MV; BIM_I_LP_GH_SUM_MV; BIM_I_LP_GH_SUM_MV; BIM_R_CODE_DEFINITIONS
BIM: BIM_R_CODE_DEFINITIONS
ENI: ENI_DENORM_HIERARCHIES
INV: MTL_DEFAULT_CATEGORY_SETS

APPS.BIM_I_LP_AGE_SG_MV is not referenced by any database object