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

MATERIALIZED VIEW: APPS.IBE_BI_CUSTTIME_MV

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

FII_TIME_DAY
IBE_BI_CUST_MV
     IBE_BI_CUST_INTM_MV
          ISC_BOOK_SUM2_F
IBE_BI_ORDERS_MV
     IBE_BI_ORDERBOM_MV
          IBE_BI_CARTS_MV
               ASO_BI_QUOTE_LINES_ALL
          ISC_BOOK_SUM2_F

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
UMARKER CHAR (7)
Record Marker
MINISITE_ID NUMBER

Mini Site Identifier for iStore
TIME_ID NUMBER

Time Identifier (Foreign key to join to the Time Dimension Views)
PERIOD_TYPE_ID NUMBER

Period Type Identifier
ENT_YEAR_ID NUMBER

Foreign Key for Enterprise Year
ENT_QTR_ID NUMBER

Foreign Key for Enterprise Quarter
ENT_PERIOD_ID NUMBER

Foreign Key for Enterprise Period
REPORT_DATE_JULIAN NUMBER

Report as-of-date (Julian Day)
WEEK_ID NUMBER

Foreign Key for Week
D_GID NUMBER

Grouping Id for rollups (Internally Used Column)
TOTAL NUMBER

Total Number of New Customers
D_TOTAL_CNT NUMBER

Dummy Count for materialized view refresh functionality (Not Used Otherwise)
Query Text

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


SELECT UMARKER
,      MINISITE_ID
,      TIME_ID
,      PERIOD_TYPE_ID
,      ENT_YEAR_ID
,      ENT_QTR_ID
,      ENT_PERIOD_ID
,      REPORT_DATE_JULIAN
,      WEEK_ID
,      D_GID
,      TOTAL
,      D_TOTAL_CNT
FROM APPS.IBE_BI_CUSTTIME_MV;

Dependencies

[top of page]

APPS.IBE_BI_CUSTTIME_MV references the following:

SchemaAPPS
TableIBE_BI_CUSTTIME_MV
Materialized ViewIBE_BI_CUST_MV
TableIBE_BI_CUST_MV
TableIBE_BI_ORDERS_MV
Materialized ViewIBE_BI_ORDERS_MV
SchemaFII
TableFII_TIME_DAY

APPS.IBE_BI_CUSTTIME_MV is not referenced by any database object