View: XLA_JE_SOURCES_VL

Product:	XLA - Subledger Accounting
Description:
Implementation/DBA Data:	APPS.XLA_JE_SOURCES_VL

View Text

SELECT XLO.MEANING JE_SOURCE_NAME
, 101 APPLICATION_ID
FROM XLA_LOOKUPS XLO
WHERE LOOKUP_TYPE = 'XLA_ADR_SIDE'
AND LOOKUP_CODE = 'ALL' UNION SELECT GJS.USER_JE_SOURCE_NAME JE_SOURCE_NAME
, XLS.APPLICATION_ID APPLICATION_ID
FROM XLA_SUBLEDGERS XLS
, GL_JE_SOURCES_TL GJS
WHERE GJS.JE_SOURCE_NAME = XLS.JE_SOURCE_NAME
AND LANGUAGE = USERENV('LANG')

Columns