VIEW: APPS.JTF_USER_CUSTOM_GRIDS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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