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 Length Mandatory Comments
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:

SchemaAPPS
TableBIX_CALL_PRESP_MV
SchemaBIX
TableBIX_CALL_DETAILS_F
APPS.BIX_CALL_PRESP_MV is referenced by following:

SchemaAPPS
Materialized ViewBIM_I_EXT_COL_MV
Materialized ViewBIM_SGMT_ACT_B_MV