[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: |
APPS.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 |