[Home] [Help]
[Dependency Information]
| Object Name: | IBE_BI_CUST_MV |
|---|---|
| Object Type: | TABLE |
| Owner: | APPS |
| Subobject Name: | |
| Status: | VALID |
| Tablespace: | APPS_TS_SUMMARY |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| I_SNAP$_IBE_BI_CUST_MV | FUNCTION-BASED NORMAL | UNIQUE |
APPS_TS_TX_DATA
|
SYS_OP_MAP_NONNULL("CUSTOMER_ID")
|
| 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_MV;
APPS.IBE_BI_CUST_MV does not reference any database object
APPS.IBE_BI_CUST_MV is referenced by following:
APPS
IBE_BI_CUSTTIME_MV
IBE_BI_CUST_MV
IBW_VISIT_CUST_MV
|
|
|
|