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


TABLE: APPS.IBW_PRODUCT_TIME_MV

Object Details
Object Name: IBW_PRODUCT_TIME_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.IBW_PRODUCT_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_PRODUCT_TIME_M FUNCTION-BASED NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnSYS_OP_MAP_NONNULL("SITE_ID")
ColumnSYS_OP_MAP_NONNULL("TRANSACTION_DATE")
ColumnSYS_OP_MAP_NONNULL("LEAF_CATEG_ID")
ColumnSYS_OP_MAP_NONNULL("PRODUCT_ID")
ColumnSYS_OP_MAP_NONNULL("VISITANT_ID")
ColumnSYS_OP_MAP_NONNULL("VISIT_ID")
ColumnSYS_OP_MAP_NONNULL("CURRENCY_CD_F")
ColumnSYS_OP_MAP_NONNULL("ORDER_ID")
ColumnSYS_OP_MAP_NONNULL("QOT_ORDER_ID")
ColumnSYS_OP_MAP_NONNULL("CART_ID")
ColumnSYS_OP_MAP_NONNULL("ORDERS_SITE_VISITS")
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_PRODUCT_TIME_MV_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTIME_ID
ColumnPERIOD_TYPE_ID
ColumnSITE_ID
ColumnLEAF_CATEG_ID
Columns
Name Datatype Length Mandatory Comments
SITE_ID NUMBER

TRANSACTION_DATE DATE

LEAF_CATEG_ID NUMBER

PRODUCT_ID VARCHAR2 (81)
VISITANT_ID VARCHAR2 (256)
VISIT_ID NUMBER

NO_VISITS NUMBER

PAGE_VIEWS NUMBER

ORDERS_SITE_VISITS VARCHAR2 (281)
ORDER_ID NUMBER

QOT_ORDER_ID NUMBER

CART_ID NUMBER

CURRENCY_CD_F VARCHAR2 (30)
BOOKED_AMT_F NUMBER

BOOKED_AMT_G NUMBER

BOOKED_AMT_G1 NUMBER

D_NO_VISITS NUMBER

D_PAGE_VIEWS NUMBER

D_BOOKED_AMT_F NUMBER

D_BOOKED_AMT_G NUMBER

D_BOOKED_AMT_G1 NUMBER

D_TOT_COL NUMBER

TIME_ID NUMBER

PERIOD_TYPE_ID NUMBER

ENT_YEAR_ID NUMBER

ENT_QTR_ID NUMBER

ENT_PERIOD_ID NUMBER

REPORT_DATE_JULIAN NUMBER

WEEK_ID NUMBER

D_GID NUMBER

Query Text

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


SELECT SITE_ID
,      TRANSACTION_DATE
,      LEAF_CATEG_ID
,      PRODUCT_ID
,      VISITANT_ID
,      VISIT_ID
,      NO_VISITS
,      PAGE_VIEWS
,      ORDERS_SITE_VISITS
,      ORDER_ID
,      QOT_ORDER_ID
,      CART_ID
,      CURRENCY_CD_F
,      BOOKED_AMT_F
,      BOOKED_AMT_G
,      BOOKED_AMT_G1
,      D_NO_VISITS
,      D_PAGE_VIEWS
,      D_BOOKED_AMT_F
,      D_BOOKED_AMT_G
,      D_BOOKED_AMT_G1
,      D_TOT_COL
,      TIME_ID
,      PERIOD_TYPE_ID
,      ENT_YEAR_ID
,      ENT_QTR_ID
,      ENT_PERIOD_ID
,      REPORT_DATE_JULIAN
,      WEEK_ID
,      D_GID
FROM APPS.IBW_PRODUCT_TIME_MV;

Dependencies

[top of page]

APPS.IBW_PRODUCT_TIME_MV does not reference any database object

APPS.IBW_PRODUCT_TIME_MV is referenced by following:

SchemaAPPS
Materialized ViewIBW_PRODUCT_TIME_MV