FND Design Data [Home] [Help]

View: AMS_SEARCH_IDS_V

Product: AMS - Marketing
Description: This view returns search result rows only for the current users session.
Implementation/DBA Data: ViewAPPS.AMS_SEARCH_IDS_V
View Text

SELECT DB_AUDSID
, OBJECT_CODE
, OBJECT_ID
FROM AMS_SEARCH_IDS
WHERE DB_AUDSID = USERENV('SESSIONID')

Columns

Name
DB_AUDSID
OBJECT_CODE
OBJECT_ID