View: JTF_USER_CUSTOM_GRIDS

Product:	JTF - CRM Foundation
Description:	All the spreadtable customizations that the current end user can access.
Implementation/DBA Data:	APPS.JTF_USER_CUSTOM_GRIDS

View Text

SELECT B.CUSTOM_GRID_ID
, B.GRID_DATASOURCE_NAME
, T.TITLE_TEXT
, B.CREATED_BY
, F.USER_NAME
, B.CUSTOM_GRID_NAME
, B.PUBLIC_FLAG
FROM JTF_CUSTOM_GRIDS B
, JTF_GRID_DATASOURCES_TL T
, FND_USER F
WHERE B.GRID_DATASOURCE_NAME = T.GRID_DATASOURCE_NAME
AND B.LANGUAGE = USERENV('LANG')
AND B.LANGUAGE = T.LANGUAGE
AND (B.CREATED_BY = FND_GLOBAL.USER_ID OR B.PUBLIC_FLAG = 'Y')
AND B.CREATED_BY = F.USER_ID

Columns