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.BIX_CALL_PRESP_MV

Object Details

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

M-View Details

Container:	BIX_CALL_PRESP_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:


BIX_CALL_DETAILS_F

[View Source Query]

Columns

Name	Datatype	Mandatory
SOURCE_CODE_ID	NUMBER
PARTY_ID	NUMBER
TRANSACTION_CREATE_DATE	DATE	Yes
RESPONSE_COUNT	NUMBER
RESPONSE_COUNT_C	NUMBER
ALL_COUNT	NUMBER

Query Text

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


SELECT SOURCE_CODE_ID
,      PARTY_ID
,      TRANSACTION_CREATE_DATE
,      RESPONSE_COUNT
,      RESPONSE_COUNT_C
,      ALL_COUNT
FROM APPS.BIX_CALL_PRESP_MV;

Dependencies

[top of page]

APPS.BIX_CALL_PRESP_MV references the following:

APPS: BIX_CALL_PRESP_MV
BIX: BIX_CALL_DETAILS_F

APPS.BIX_CALL_PRESP_MV is referenced by following:

APPS: BIM_I_EXT_COL_MV; BIM_SGMT_ACT_B_MV