View: XLA_EVENT_CLASSES_FVL

Product:	XLA - Subledger Accounting
Description:	The view XLA_EVENT_CLASSES_FVL returns entity name and user je category name for the entity code and je category name selected.
Implementation/DBA Data:	APPS.XLA_EVENT_CLASSES_FVL

View Text

SELECT B.ROWID ROW_ID
, B.APPLICATION_ID APPLICATION_ID
, B.ENTITY_CODE ENTITY_CODE
, B.EVENT_CLASS_CODE EVENT_CLASS_CODE
, TL.NAME EVENT_CLASS_NAME
, TL.DESCRIPTION EVENT_CLASS_DESCRIPTION
, B.ENABLED_FLAG ENABLED_FLAG
, B.CREATION_DATE CREATION_DATE
, B.CREATED_BY CREATED_BY
, B.LAST_UPDATE_DATE LAST_UPDATE_DATE
, B.LAST_UPDATED_BY LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM XLA_EVENT_CLASSES_B B
, XLA_EVENT_CLASSES_TL TL
WHERE B.APPLICATION_ID = TL.APPLICATION_ID
AND B.ENTITY_CODE = TL.ENTITY_CODE
AND B.EVENT_CLASS_CODE = TL.EVENT_CLASS_CODE
AND TL.LANGUAGE = USERENV('LANG')
AND B.EVENT_CLASS_CODE <> 'MANUAL'
AND B.ENABLED_FLAG = 'Y'
AND EXISTS (SELECT 'X'
FROM XLA_EVENT_TYPES_B E
WHERE E.APPLICATION_ID = B.APPLICATION_ID
AND E.ENTITY_CODE = B.ENTITY_CODE
AND E.EVENT_CLASS_CODE = B.EVENT_CLASS_CODE
AND E.ACCOUNTING_FLAG = 'Y'
AND E.ENABLED_FLAG = 'Y'
AND E.EVENT_TYPE_CODE <> B.EVENT_CLASS_CODE||'_ALL')

Columns