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


MATERIALIZED VIEW: APPS.IBE_BI_CUST_INTM_MV

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

ISC_BOOK_SUM2_F

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
CUSTOMER_ID NUMBER

BOOKED_DATE DATE

D_TOTAL_CNT NUMBER

Query Text

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


SELECT CUSTOMER_ID
,      BOOKED_DATE
,      D_TOTAL_CNT
FROM APPS.IBE_BI_CUST_INTM_MV;

Dependencies

[top of page]

APPS.IBE_BI_CUST_INTM_MV references the following:

SchemaAPPS
TableIBE_BI_CUST_INTM_MV
SchemaISC
TableISC_BOOK_SUM2_F
APPS.IBE_BI_CUST_INTM_MV is referenced by following:

SchemaAPPS
Materialized ViewIBE_BI_CUST_MV