VIEW: APPS.FND_PROFILE_CATS_VL

Source

View Text - Preformatted

SELECT B.APPLICATION_ID, B.ROWID ROW_ID, B.CREATED_BY, B.LAST_UPDATE_LOGIN, B.NAME, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY,
      B.CREATION_DATE, B.ENABLED, T.DESCRIPTION, T.DISPLAY_NAME
      FROM FND_PROFILE_CATS_TL T,FND_PROFILE_CATS B
      WHERE B.NAME = T.NAME
      and B.APPLICATION_ID = T.APPLICATION_ID
      and T.LANGUAGE = userenv('LANG')

   

View Text - HTML Formatted

SELECT B.APPLICATION_ID
, B.ROWID ROW_ID
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.NAME
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.ENABLED
, T.DESCRIPTION
, T.DISPLAY_NAME
FROM FND_PROFILE_CATS_TL T
, FND_PROFILE_CATS B
WHERE B.NAME = T.NAME
AND B.APPLICATION_ID = T.APPLICATION_ID
AND T.LANGUAGE = USERENV('LANG')