eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: IBW.IBW_SITE_VISITS#

Source

View Text - Preformatted


select SITE_VISIT_ID SITE_VISIT_ID, VISIT_ID VISIT_ID, SITE_ID SITE_ID, VISIT_START_TIME VISIT_START_TIME, USER_ID USER_ID, REFERRAL_CATEGORY_ID REFERRAL_CATEGORY_ID, VISITOR_ID VISITOR_ID, PARTY_ID PARTY_ID, VISITANT_ID VISITANT_ID, SITE_VISIT_DURATION SITE_VISIT_DURATION, CAMPAIGN_SOURCE_CODE_ID CAMPAIGN_SOURCE_CODE_ID, TOTAL_OPT_OUTS TOTAL_OPT_OUTS, NUM_PAGE_VIEWS NUM_PAGE_VIEWS, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, REPEAT_VISIT_FLAG REPEAT_VISIT_FLAG, TOTAL_CARTS_CREATED TOTAL_CARTS_CREATED, TOTAL_ORDERS_CREATED TOTAL_ORDERS_CREATED, TOTAL_ORDER_INQUIRIES TOTAL_ORDER_INQUIRIES, TOTAL_PAYMENT_INQUIRIES TOTAL_PAYMENT_INQUIRIES, TOTAL_INVOICE_INQUIRIES TOTAL_INVOICE_INQUIRIES, TOTAL_WEB_REGISTRATIONS TOTAL_WEB_REGISTRATIONS, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_ID PROGRAM_ID, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, REQUEST_ID REQUEST_ID from "IBW"."IBW_SITE_VISITS"

View Text - HTML Formatted

SELECT SITE_VISIT_ID SITE_VISIT_ID
, VISIT_ID VISIT_ID
, SITE_ID SITE_ID
, VISIT_START_TIME VISIT_START_TIME
, USER_ID USER_ID
, REFERRAL_CATEGORY_ID REFERRAL_CATEGORY_ID
, VISITOR_ID VISITOR_ID
, PARTY_ID PARTY_ID
, VISITANT_ID VISITANT_ID
, SITE_VISIT_DURATION SITE_VISIT_DURATION
, CAMPAIGN_SOURCE_CODE_ID CAMPAIGN_SOURCE_CODE_ID
, TOTAL_OPT_OUTS TOTAL_OPT_OUTS
, NUM_PAGE_VIEWS NUM_PAGE_VIEWS
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, REPEAT_VISIT_FLAG REPEAT_VISIT_FLAG
, TOTAL_CARTS_CREATED TOTAL_CARTS_CREATED
, TOTAL_ORDERS_CREATED TOTAL_ORDERS_CREATED
, TOTAL_ORDER_INQUIRIES TOTAL_ORDER_INQUIRIES
, TOTAL_PAYMENT_INQUIRIES TOTAL_PAYMENT_INQUIRIES
, TOTAL_INVOICE_INQUIRIES TOTAL_INVOICE_INQUIRIES
, TOTAL_WEB_REGISTRATIONS TOTAL_WEB_REGISTRATIONS
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_ID PROGRAM_ID
, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, REQUEST_ID REQUEST_ID
FROM "IBW"."IBW_SITE_VISITS"