[Home] [Help] [Dependency Information]
Object Name: | MLOG$_IBW_SITE_VISITS |
---|---|
Object Type: | TABLE |
Owner: | IBW |
Subobject Name: | |
Status: | VALID |
snapshot log for master table IBW.IBW_SITE_VISITS
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 60 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CAMPAIGN_SOURCE_CODE_ID | NUMBER | (15) | ||
CREATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
NUM_PAGE_VIEWS | NUMBER | (10) | ||
OBJECT_VERSION_NUMBER | NUMBER | |||
PARTY_ID | NUMBER | (15) | ||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_LOGIN_ID | NUMBER | |||
REFERRAL_CATEGORY_ID | NUMBER | (15) | ||
REPEAT_VISIT_FLAG | VARCHAR2 | (1) | ||
REQUEST_ID | NUMBER | |||
SITE_ID | NUMBER | (15) | ||
SITE_VISIT_DURATION | NUMBER | (10) | ||
SITE_VISIT_ID | NUMBER | (15) | ||
TOTAL_CARTS_CREATED | NUMBER | (10) | ||
TOTAL_INVOICE_INQUIRIES | NUMBER | (10) | ||
TOTAL_OPT_OUTS | NUMBER | (10) | ||
TOTAL_ORDERS_CREATED | NUMBER | (10) | ||
TOTAL_ORDER_INQUIRIES | NUMBER | (10) | ||
TOTAL_PAYMENT_INQUIRIES | NUMBER | (10) | ||
TOTAL_WEB_REGISTRATIONS | NUMBER | (10) | ||
USER_ID | NUMBER | (15) | ||
VISITANT_ID | VARCHAR2 | (256) | ||
VISITOR_ID | NUMBER | (15) | ||
VISIT_ID | NUMBER | (15) | ||
VISIT_START_TIME | DATE | |||
M_ROW$$ | VARCHAR2 | (255) | ||
SEQUENCE$$ | NUMBER | |||
SNAPTIME$$ | DATE | |||
DMLTYPE$$ | VARCHAR2 | (1) | ||
OLD_NEW$$ | VARCHAR2 | (1) | ||
CHANGE_VECTOR$$ | RAW | (255) |
Cut, paste (and edit) the following text to query this object:
SELECT CAMPAIGN_SOURCE_CODE_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, NUM_PAGE_VIEWS
, OBJECT_VERSION_NUMBER
, PARTY_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_LOGIN_ID
, REFERRAL_CATEGORY_ID
, REPEAT_VISIT_FLAG
, REQUEST_ID
, SITE_ID
, SITE_VISIT_DURATION
, SITE_VISIT_ID
, TOTAL_CARTS_CREATED
, TOTAL_INVOICE_INQUIRIES
, TOTAL_OPT_OUTS
, TOTAL_ORDERS_CREATED
, TOTAL_ORDER_INQUIRIES
, TOTAL_PAYMENT_INQUIRIES
, TOTAL_WEB_REGISTRATIONS
, USER_ID
, VISITANT_ID
, VISITOR_ID
, VISIT_ID
, VISIT_START_TIME
, M_ROW$$
, SEQUENCE$$
, SNAPTIME$$
, DMLTYPE$$
, OLD_NEW$$
, CHANGE_VECTOR$$
FROM IBW.MLOG$_IBW_SITE_VISITS;
IBW.MLOG$_IBW_SITE_VISITS does not reference any database object
IBW.MLOG$_IBW_SITE_VISITS is referenced by following:
|
|
|