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