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_B_MV

Object Details

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

M-View Details

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

MV Log Dependencies:


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

[View Source Query]

Columns

Name	Datatype	Length
UMARK	NUMBER
SEGMENT_ID	NUMBER
ACTIVITY_ID	NUMBER
SCHEDULE_PURPOSE	VARCHAR2	(240)
CATEGORY_ID	NUMBER
SOURCE_CODE_ID	NUMBER
TRANSACTION_CREATE_DATE	DATE
ACTIVITIES_COUNT	NUMBER
RESPONSES	NUMBER
RESP_CNT	NUMBER
LEADS	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
COUNT_ALL	NUMBER

Query Text

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


SELECT UMARK
,      SEGMENT_ID
,      ACTIVITY_ID
,      SCHEDULE_PURPOSE
,      CATEGORY_ID
,      SOURCE_CODE_ID
,      TRANSACTION_CREATE_DATE
,      ACTIVITIES_COUNT
,      RESPONSES
,      RESP_CNT
,      LEADS
,      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
,      COUNT_ALL
FROM APPS.BIM_SGMT_ACT_B_MV;

Dependencies

[top of page]

APPS.BIM_SGMT_ACT_B_MV references the following:

APPS: BIL_BI_OPDTL_MV; BIL_BI_OPDTL_MV; BIM_I_LD_HEADER_MV; BIM_I_LD_HEADER_MV; BIM_SGMT_ACT_B_MV; BIM_SGMT_ACT_H_MV; BIM_SGMT_ACT_H_MV; BIX_CALL_PRESP_MV; BIX_CALL_PRESP_MV
BIM: BIM_I_PARTY_SGMT_FACTS
ISC: ISC_BOOK_SUM2_F

APPS.BIM_SGMT_ACT_B_MV is referenced by following:

APPS: BIM_SGMT_ACT_CH_MV; BIM_SGMT_ACT_MV; BIM_SGMT_ACT_SH_MV