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


TABLE: APPS.IBW_CART_BASE_MV

Object Details
Object Name: IBW_CART_BASE_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.IBW_CART_BASE_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
UMARKER NUMBER

TRANSACTION_DATE DATE

SITE_ID NUMBER

CUSTOMER_ID NUMBER

CARTS NUMBER

ORDERS NUMBER

ANONYMOUS_CARTS NUMBER

LEAD_RANK NUMBER

MARKETING_SOURCE_CODE_ID_HDR NUMBER

SOURCE_PRIMARY_REFERENCE VARCHAR2 (240)
D_TOTAL_CNT NUMBER

Query Text

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


SELECT UMARKER
,      TRANSACTION_DATE
,      SITE_ID
,      CUSTOMER_ID
,      CARTS
,      ORDERS
,      ANONYMOUS_CARTS
,      LEAD_RANK
,      MARKETING_SOURCE_CODE_ID_HDR
,      SOURCE_PRIMARY_REFERENCE
,      D_TOTAL_CNT
FROM APPS.IBW_CART_BASE_MV;

Dependencies

[top of page]

APPS.IBW_CART_BASE_MV does not reference any database object

APPS.IBW_CART_BASE_MV is referenced by following:

SchemaAPPS
Materialized ViewIBW_CART_BASE_MV
Materialized ViewIBW_CMPANALYSIS_MV
Materialized ViewIBW_VISIT_CUST_MV