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

TABLE: APPS.MLOG$_IBW_SITE_VISIT_MV

Object Details
Object Name: MLOG$_IBW_SITE_VISIT_MV
Object Type: TABLE
Owner: APPS
Subobject Name:
Status: VALID

snapshot log for master table APPS.IBW_SITE_VISIT_MV

Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 60
PCT Used:
Columns
Name Datatype Length Mandatory Comments
CAMPAIGN_SOURCE_CODE_ID NUMBER (15)
CARTS NUMBER

CUSTOMER_ID NUMBER (15)
OPT_OUTS NUMBER

ORDERS NUMBER

ORDERS_SITE_VISITS NUMBER

PAGE_VIEWS NUMBER

REFERRAL_CATEGORY_ID NUMBER

REPEAT_VISITS NUMBER

SITE_ID NUMBER (15)
TOTAL_INVOICE_INQUIRIES NUMBER

TOTAL_ORDER_INQUIRIES NUMBER

TOTAL_PAYMENT_INQUIRIES NUMBER

TRANSACTION_DATE DATE

UMARKER NUMBER

VISITS NUMBER

VISIT_DURATION NUMBER

WEB_REGISTRATIONS NUMBER

WEB_REGISTRATIONS_REF NUMBER

M_ROW$$ VARCHAR2 (255)
SEQUENCE$$ NUMBER

SNAPTIME$$ DATE

DMLTYPE$$ VARCHAR2 (1)
OLD_NEW$$ VARCHAR2 (1)
CHANGE_VECTOR$$ RAW (255)
Query Text

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


SELECT CAMPAIGN_SOURCE_CODE_ID
,      CARTS
,      CUSTOMER_ID
,      OPT_OUTS
,      ORDERS
,      ORDERS_SITE_VISITS
,      PAGE_VIEWS
,      REFERRAL_CATEGORY_ID
,      REPEAT_VISITS
,      SITE_ID
,      TOTAL_INVOICE_INQUIRIES
,      TOTAL_ORDER_INQUIRIES
,      TOTAL_PAYMENT_INQUIRIES
,      TRANSACTION_DATE
,      UMARKER
,      VISITS
,      VISIT_DURATION
,      WEB_REGISTRATIONS
,      WEB_REGISTRATIONS_REF
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
FROM APPS.MLOG$_IBW_SITE_VISIT_MV;

Dependencies

[top of page]

APPS.MLOG$_IBW_SITE_VISIT_MV does not reference any database object

APPS.MLOG$_IBW_SITE_VISIT_MV is not referenced by any database object