[Home] [Help]
[Dependency Information]
| Object Name: | IBE_BI_CUST_INTM_MV |
|---|---|
| Object Type: | MATERIALIZED VIEW |
| Owner: | APPS |
| Subobject Name: | |
| Status: | VALID |
| 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 |
ISC_BOOK_SUM2_F
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CUSTOMER_ID | NUMBER | |||
| BOOKED_DATE | DATE | |||
| D_TOTAL_CNT | NUMBER |
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;
APPS
IBE_BI_CUST_INTM_MV
ISC
ISC_BOOK_SUM2_F
APPS
IBE_BI_CUST_MV
|
|
|
|