View: AST_WEB_ASSIST_DETAILS_V

Product:	AST - TeleSales
Description:
Implementation/DBA Data:	APPS.AST_WEB_ASSIST_DETAILS_V

View Text

SELECT QS.ROWID
, 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 AST_WEB_ASSISTS WA
, AST_WEB_SEARCHES WS
, AST_QUERY_STRINGS QS
WHERE WA.WEB_ASSIST_ID = WS.WEB_ASSIST_ID
AND WS.SEARCH_ID = QS.SEARCH_ID

Columns