VIEW: APPS.IEX_WEB_ASSIST_DETAILS_V

Source

View Text - Preformatted

SELECT WA.ASSIST_ID, WA.WEB_ASSIST_ID, WS.SEARCH_ID, QS.QUERY_STRING_ID, WA.PROXY_HOST, WA.PROXY_PORT, WS.SEARCH_URL, WS.CGI_SERVER, WS.NEXT_PAGE_IDENT, WS.MAX_NBR_PAGES, WS.ENABLED_FLAG, WS.DIRECTORY_ASSIST_FLAG, QS.SWITCH_SEPARATOR, QS.URL_SEPARATOR, QS.HEADER_CONST, QS.TRAILER_CONST, QS.LAST_UPDATE_DATE, QS.LAST_UPDATED_BY, QS.CREATION_DATE, QS.CREATED_BY, QS.LAST_UPDATE_LOGIN, QS.ATTRIBUTE_CATEGORY, QS.ATTRIBUTE1, QS.ATTRIBUTE2, QS.ATTRIBUTE3, QS.ATTRIBUTE4, QS.ATTRIBUTE5, QS.ATTRIBUTE6, QS.ATTRIBUTE7, QS.ATTRIBUTE8, QS.ATTRIBUTE9, QS.ATTRIBUTE10, QS.ATTRIBUTE11, QS.ATTRIBUTE12, QS.ATTRIBUTE13, QS.ATTRIBUTE14, QS.ATTRIBUTE15 FROM IEX_WEB_ASSISTS WA, IEX_WEB_SEARCHES WS, IEX_QUERY_STRINGS QS WHERE WA.WEB_ASSIST_ID = WS.WEB_ASSIST_ID AND WS.SEARCH_ID = QS.SEARCH_ID

View Text - HTML Formatted

SELECT WA.ASSIST_ID
, WA.WEB_ASSIST_ID
, WS.SEARCH_ID
, QS.QUERY_STRING_ID
, WA.PROXY_HOST
, WA.PROXY_PORT
, WS.SEARCH_URL
, WS.CGI_SERVER
, WS.NEXT_PAGE_IDENT
, WS.MAX_NBR_PAGES
, WS.ENABLED_FLAG
, WS.DIRECTORY_ASSIST_FLAG
, QS.SWITCH_SEPARATOR
, QS.URL_SEPARATOR
, QS.HEADER_CONST
, QS.TRAILER_CONST
, QS.LAST_UPDATE_DATE
, QS.LAST_UPDATED_BY
, QS.CREATION_DATE
, QS.CREATED_BY
, QS.LAST_UPDATE_LOGIN
, QS.ATTRIBUTE_CATEGORY
, QS.ATTRIBUTE1
, QS.ATTRIBUTE2
, QS.ATTRIBUTE3
, QS.ATTRIBUTE4
, QS.ATTRIBUTE5
, QS.ATTRIBUTE6
, QS.ATTRIBUTE7
, QS.ATTRIBUTE8
, QS.ATTRIBUTE9
, QS.ATTRIBUTE10
, QS.ATTRIBUTE11
, QS.ATTRIBUTE12
, QS.ATTRIBUTE13
, QS.ATTRIBUTE14
, QS.ATTRIBUTE15
FROM IEX_WEB_ASSISTS WA
, IEX_WEB_SEARCHES WS
, IEX_QUERY_STRINGS QS
WHERE WA.WEB_ASSIST_ID = WS.WEB_ASSIST_ID
AND WS.SEARCH_ID = QS.SEARCH_ID