DBA Data[Home] [Help]

VIEW: APPS.XLA_JE_CATEGORIES_VL

Source

View Text - Preformatted

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')
View Text - HTML Formatted

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')