[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: |
APPS.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 |