[Home] [Help]
View: AMS_P_DISCOVERER_SQL_V
Product: | AMS - Marketing |
Description: | This public view returns the distinct set of WorkBook and WorkSheet names which are stored in the AMS_DISCOVERER_SQL table. |
Implementation/DBA Data: |
APPS.AMS_P_DISCOVERER_SQL_V
|
View Text
SELECT MIN (DISCOVERER_SQL_ID)
, WORKBOOK_OWNER_NAME
, WORKBOOK_NAME
, WORKSHEET_NAME
, SOURCE_TYPE_CODE
FROM AMS_DISCOVERER_SQL GROUP BY WORKBOOK_OWNER_NAME
, WORKBOOK_NAME
, WORKSHEET_NAME
, SOURCE_TYPE_CODE
Columns
Name |
DISCOVERER_SQL_ID |
WORKBOOK_OWNER_NAME |
WORKBOOK_NAME |
WORKSHEET_NAME |
SOURCE_TYPE_CODE |