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


TABLE: APPS.IBE_BI_CUST_MV

Object Details
Object Name: IBE_BI_CUST_MV
Object Type: TABLE
Owner: APPS
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
I_SNAP$_IBE_BI_CUST_MV FUNCTION-BASED NORMAL UNIQUE TablespaceAPPS_TS_TX_DATA ColumnSYS_OP_MAP_NONNULL("CUSTOMER_ID")
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_MV;

Dependencies

[top of page]

APPS.IBE_BI_CUST_MV does not reference any database object

APPS.IBE_BI_CUST_MV is referenced by following:

SchemaAPPS
Materialized ViewIBE_BI_CUSTTIME_MV
Materialized ViewIBE_BI_CUST_MV
Materialized ViewIBW_VISIT_CUST_MV