Skip to content

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

TABLE: APPS.MLOG$_IBW_CMPANALYSIS_TIME

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

snapshot log for master table APPS.IBW_CMPANALYSIS_TIME_MV

Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 60
PCT Used:
Columns
Name Datatype Length Mandatory Comments
A_LEADS NUMBER

BOOKED_AMT_F NUMBER

BOOKED_AMT_G NUMBER

BOOKED_AMT_G1 NUMBER

CAMPAIGN_SOURCE_CODE_ID NUMBER

CARTS NUMBER

CURRENCY_CD_F VARCHAR2 (30)
DAILY_UNIQ_VISITORS NUMBER

D_GID NUMBER

ENT_PERIOD_ID NUMBER

ENT_QTR_ID NUMBER

ENT_YEAR_ID NUMBER

ORDERS NUMBER

PAGE_VIEWS NUMBER

PERIOD_TYPE_ID NUMBER

REPORT_DATE_JULIAN NUMBER

SITE_ID NUMBER

TIME_ID NUMBER

TRANSACTION_DATE DATE

VISITS NUMBER

VISIT_DURATION NUMBER

WEB_REGISTRATIONS NUMBER

WEEK_ID 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 A_LEADS
,      BOOKED_AMT_F
,      BOOKED_AMT_G
,      BOOKED_AMT_G1
,      CAMPAIGN_SOURCE_CODE_ID
,      CARTS
,      CURRENCY_CD_F
,      DAILY_UNIQ_VISITORS
,      D_GID
,      ENT_PERIOD_ID
,      ENT_QTR_ID
,      ENT_YEAR_ID
,      ORDERS
,      PAGE_VIEWS
,      PERIOD_TYPE_ID
,      REPORT_DATE_JULIAN
,      SITE_ID
,      TIME_ID
,      TRANSACTION_DATE
,      VISITS
,      VISIT_DURATION
,      WEB_REGISTRATIONS
,      WEEK_ID
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
FROM APPS.MLOG$_IBW_CMPANALYSIS_TIME;

Dependencies

[top of page]

APPS.MLOG$_IBW_CMPANALYSIS_TIME does not reference any database object

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