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.

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

TABLE: IBW.MLOG$_IBW_PAGE_VIEWS

Object Details

Object Name:	MLOG$_IBW_PAGE_VIEWS
Object Type:	TABLE
Owner:	IBW
Subobject Name:
Status:	VALID

snapshot log for master table IBW.IBW_PAGE_VIEWS

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	60
PCT Used:

Columns

Name	Datatype	Length
BROWSER_OS_INFO	VARCHAR2	(240)
BUSINESS_CONTEXT	VARCHAR2	(30)
BUSINESS_CONTEXT_VALUE	VARCHAR2	(240)
CAMPAIGN_SOURCE_CODE_ID	NUMBER	(15)
CREATED_BY	NUMBER	(15)
CREATION_DATE	DATE
EVNT_ID	VARCHAR2	(240)
EVNT_TYPE	VARCHAR2	(30)
EXACT_RESULT_SIZE_FLAG	VARCHAR2	(1)
IP_ADDRESS	VARCHAR2	(30)
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_DATE	DATE
LAST_UPDATE_LOGIN	NUMBER	(15)
OBJECT_VERSION_NUMBER	NUMBER
PAGE_ID	NUMBER	(15)
PAGE_INSTANCE_ID	NUMBER	(15)
PAGE_VIEW_DURATION	NUMBER	(10)
PAGE_VIEW_ID	NUMBER	(15)
PAGE_VIEW_SEQ_NUM	NUMBER	(10)
PAGE_VIEW_START_TIME	DATE
PARTY_ID	NUMBER	(15)
PARTY_RELATIONSHIP_ID	NUMBER	(15)
PROGRAM_APPLICATION_ID	NUMBER
PROGRAM_ID	NUMBER
PROGRAM_LOGIN_ID	NUMBER
REFERRAL_URL	VARCHAR2	(4000)
REQUEST_ID	NUMBER
SEARCH_PHRASE	VARCHAR2	(240)
SEARCH_RESULT_SIZE	NUMBER	(10)
SITE_ID	NUMBER	(15)
TRACKED_APPLICATION_CONTEXT	VARCHAR2	(30)
TRACKED_PAGE_CODE	VARCHAR2	(30)
TRACKED_PAGE_NAME	VARCHAR2	(360)
TRACKED_PAGE_URL	VARCHAR2	(4000)
TRACKED_SITE_CODE	VARCHAR2	(30)
USER_GUID	VARCHAR2	(256)
USER_ID	NUMBER	(15)
VISITANT_ID	VARCHAR2	(256)
VISITOR_ID	NUMBER	(15)
VISIT_ID	NUMBER	(15)
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 BROWSER_OS_INFO
,      BUSINESS_CONTEXT
,      BUSINESS_CONTEXT_VALUE
,      CAMPAIGN_SOURCE_CODE_ID
,      CREATED_BY
,      CREATION_DATE
,      EVNT_ID
,      EVNT_TYPE
,      EXACT_RESULT_SIZE_FLAG
,      IP_ADDRESS
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      PAGE_ID
,      PAGE_INSTANCE_ID
,      PAGE_VIEW_DURATION
,      PAGE_VIEW_ID
,      PAGE_VIEW_SEQ_NUM
,      PAGE_VIEW_START_TIME
,      PARTY_ID
,      PARTY_RELATIONSHIP_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      REFERRAL_URL
,      REQUEST_ID
,      SEARCH_PHRASE
,      SEARCH_RESULT_SIZE
,      SITE_ID
,      TRACKED_APPLICATION_CONTEXT
,      TRACKED_PAGE_CODE
,      TRACKED_PAGE_NAME
,      TRACKED_PAGE_URL
,      TRACKED_SITE_CODE
,      USER_GUID
,      USER_ID
,      VISITANT_ID
,      VISITOR_ID
,      VISIT_ID
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
FROM IBW.MLOG$_IBW_PAGE_VIEWS;

Dependencies

[top of page]

IBW.MLOG$_IBW_PAGE_VIEWS does not reference any database object

IBW.MLOG$_IBW_PAGE_VIEWS is not referenced by any database object