DBA Data[Home] [Help] [Dependency Information]

MATERIALIZED VIEW: APPS.BIM_I_LD_AGE_SG_MV

Object Details
Object Name: BIM_I_LD_AGE_SG_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: BIM_I_LD_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:

BIM_R_CODE_DEFINITIONS

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
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 references the following:

SchemaAPPS
TableBIM_I_LD_AGE_SG_MV
Materialized ViewBIM_I_LD_GH_SUM_MV
TableBIM_I_LD_GH_SUM_MV
SynonymBIM_R_CODE_DEFINITIONS
SchemaBIM
TableBIM_R_CODE_DEFINITIONS

APPS.BIM_I_LD_AGE_SG_MV is not referenced by any database object