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


TABLE: APPS.IBW_KPI_METRICS_TIME_MV

Object Details
Object Name: IBW_KPI_METRICS_TIME_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.IBW_KPI_METRICS_TIME_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
I_SNAP$_IBW_KPI_METRICS_TI FUNCTION-BASED NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnSYS_OP_MAP_NONNULL("SITE_ID")
ColumnSYS_OP_MAP_NONNULL("CURRENCY_CD_F")
ColumnSYS_OP_MAP_NONNULL("TRANSACTION_DATE")
ColumnSYS_OP_MAP_NONNULL("ENT_YEAR_ID")
ColumnSYS_OP_MAP_NONNULL("ENT_QTR_ID")
ColumnSYS_OP_MAP_NONNULL("ENT_PERIOD_ID")
ColumnSYS_OP_MAP_NONNULL("WEEK_ID")
ColumnSYS_OP_MAP_NONNULL("REPORT_DATE_JULIAN")
ColumnSYS_OP_MAP_NONNULL("D_GID")
IBW_KPI_METRICS_TIME_MV_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTIME_ID
ColumnPERIOD_TYPE_ID
ColumnSITE_ID
Columns
Name Datatype Length Mandatory Comments
SITE_ID NUMBER

TRANSACTION_DATE DATE

CURRENCY_CD_F VARCHAR2 (30)
VISITS NUMBER

WEB_REGISTRATIONS NUMBER

CARTS NUMBER

ANONYMOUS_CARTS NUMBER

BOOKED_AMT_F NUMBER

BOOKED_AMT_G NUMBER

BOOKED_AMT_G1 NUMBER

ORDERS_SITE_VISITS NUMBER

BOOKED_WEB_ORDERS NUMBER

NEW_WEB_CUSTOMERS NUMBER

REPEAT_WEB_ORDERS NUMBER

TOTAL_BOOKED_ORDERS NUMBER

TIME_ID NUMBER

PERIOD_TYPE_ID NUMBER

ENT_YEAR_ID NUMBER

ENT_QTR_ID NUMBER

ENT_PERIOD_ID NUMBER

WEEK_ID NUMBER

REPORT_DATE_JULIAN NUMBER

D_GID NUMBER

D_VISITS NUMBER

D_WEB_REGISTRATIONS NUMBER

D_CARTS NUMBER

D_ANONYMOUS_CARTS NUMBER

D_BOOKED_AMT_F NUMBER

D_BOOKED_AMT_G NUMBER

D_BOOKED_AMT_G1 NUMBER

D_ORDERS_SITE_VISITS NUMBER

D_BOOKED_WEB_ORDERS NUMBER

D_NEW_WEB_CUSTOMERS NUMBER

D_REPEAT_WEB_ORDERS NUMBER

D_TOTAL_BOOKED_ORDERS NUMBER

D_CNT NUMBER

Query Text

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


SELECT SITE_ID
,      TRANSACTION_DATE
,      CURRENCY_CD_F
,      VISITS
,      WEB_REGISTRATIONS
,      CARTS
,      ANONYMOUS_CARTS
,      BOOKED_AMT_F
,      BOOKED_AMT_G
,      BOOKED_AMT_G1
,      ORDERS_SITE_VISITS
,      BOOKED_WEB_ORDERS
,      NEW_WEB_CUSTOMERS
,      REPEAT_WEB_ORDERS
,      TOTAL_BOOKED_ORDERS
,      TIME_ID
,      PERIOD_TYPE_ID
,      ENT_YEAR_ID
,      ENT_QTR_ID
,      ENT_PERIOD_ID
,      WEEK_ID
,      REPORT_DATE_JULIAN
,      D_GID
,      D_VISITS
,      D_WEB_REGISTRATIONS
,      D_CARTS
,      D_ANONYMOUS_CARTS
,      D_BOOKED_AMT_F
,      D_BOOKED_AMT_G
,      D_BOOKED_AMT_G1
,      D_ORDERS_SITE_VISITS
,      D_BOOKED_WEB_ORDERS
,      D_NEW_WEB_CUSTOMERS
,      D_REPEAT_WEB_ORDERS
,      D_TOTAL_BOOKED_ORDERS
,      D_CNT
FROM APPS.IBW_KPI_METRICS_TIME_MV;

Dependencies

[top of page]

APPS.IBW_KPI_METRICS_TIME_MV does not reference any database object

APPS.IBW_KPI_METRICS_TIME_MV is referenced by following:

SchemaAPPS
Materialized ViewIBW_KPI_METRICS_TIME_MV