FND Design Data [Home] [Help]

View: XLA_JE_CATEGORIES_VL

Product: XLA - Subledger Accounting
Description: View displays a list of journal categories that are translated.
Implementation/DBA Data: ViewAPPS.XLA_JE_CATEGORIES_VL
View Text

SELECT DISTINCT XAC.JE_CATEGORY_NAME
, GJC.USER_JE_CATEGORY_NAME
, XAC.APPLICATION_ID
FROM XLA_EVENT_CLASS_ATTRS XAC
, GL_JE_CATEGORIES_TL GJC
WHERE XAC.JE_CATEGORY_NAME = GJC.JE_CATEGORY_NAME
AND GJC.LANGUAGE = USERENV('LANG')

Columns

Name
JE_CATEGORY_NAME
USER_JE_CATEGORY_NAME
APPLICATION_ID