[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:
-
APPS
-
IBE_BI_CUST_INTM_MV
-
ISC
-
ISC_BOOK_SUM2_F
APPS.IBE_BI_CUST_INTM_MV is referenced by following:
-
APPS
-
IBE_BI_CUST_MV