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_SGMT_ACT_MV

Object Details

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

M-View Details

Container:	BIM_SGMT_ACT_MV
Updatable:	N
Rewrite Enabled:	N
Rewrite Capability:	GENERAL
Refresh Mode:	DEMAND
Refresh Method:	FAST
Build Mode:	DEFERRED
Fast Refreshable:	DIRLOAD_DML

MV Log Dependencies:


BIM_SGMT_ACT_B_MV
     BIL_BI_OPDTL_MV
          BIL_BI_OPDTL_F
          ENI_OLTP_ITEM_STAR
          FII_TIME_DAY
          JTF_RS_GROUP_USAGES
     BIM_I_LD_HEADER_MV
          BIM_I_LEAD_FACTS
     BIM_I_PARTY_SGMT_FACTS
     BIM_SGMT_ACT_H_MV
          BIM_I_SGMT_ACT_FACTS
          BIM_I_SGMT_DENORM
          BIM_I_SOURCE_CODES
     BIX_CALL_PRESP_MV
          BIX_CALL_DETAILS_F
     ISC_BOOK_SUM2_F
FII_TIME_DAY

[View Source Query]

Columns

Name	Datatype	Length	Mandatory	Comments
TIME_ID	NUMBER
PERIOD_TYPE_ID	NUMBER
SEGMENT_ID	NUMBER
CATEGORY_ID	NUMBER
CATEGORY_ID_C	NUMBER
ACTIVITIES_COUNT	NUMBER
ACTIVITIES_COUNT_C	NUMBER
RESPONSES	NUMBER
RESPONSES_C	NUMBER
LEADS	NUMBER
LEADS_C	NUMBER
NEW_OPPORTUNITY_AMT	NUMBER
NEW_OPPORTUNITY_AMT_C	NUMBER
NEW_OPPORTUNITY_AMT_S	NUMBER
NEW_OPPORTUNITY_AMT_S_C	NUMBER
BOOKED_AMT	NUMBER
BOOKED_AMT_C	NUMBER
BOOKED_AMT_S	NUMBER
BOOKED_AMT_S_C	NUMBER
ALL_CNT	NUMBER
DUMMY1_FR	NUMBER
DUMMY2_FR	NUMBER
DUMMY3_FR	NUMBER
DUMMY4_FR	NUMBER
DUMMY5_FR	NUMBER
DUMMY6_FR	NUMBER

Query Text

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


SELECT TIME_ID
,      PERIOD_TYPE_ID
,      SEGMENT_ID
,      CATEGORY_ID
,      CATEGORY_ID_C
,      ACTIVITIES_COUNT
,      ACTIVITIES_COUNT_C
,      RESPONSES
,      RESPONSES_C
,      LEADS
,      LEADS_C
,      NEW_OPPORTUNITY_AMT
,      NEW_OPPORTUNITY_AMT_C
,      NEW_OPPORTUNITY_AMT_S
,      NEW_OPPORTUNITY_AMT_S_C
,      BOOKED_AMT
,      BOOKED_AMT_C
,      BOOKED_AMT_S
,      BOOKED_AMT_S_C
,      ALL_CNT
,      DUMMY1_FR
,      DUMMY2_FR
,      DUMMY3_FR
,      DUMMY4_FR
,      DUMMY5_FR
,      DUMMY6_FR
FROM APPS.BIM_SGMT_ACT_MV;

Dependencies

[top of page]

APPS.BIM_SGMT_ACT_MV references the following:

APPS: BIM_SGMT_ACT_B_MV; BIM_SGMT_ACT_B_MV; BIM_SGMT_ACT_MV
FII: FII_TIME_DAY

APPS.BIM_SGMT_ACT_MV is not referenced by any database object