Product: | XLA - Subledger Accounting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.XLA_EVENT_SOURCES_FVL |
SELECT ESS.ROWID ROW_ID
, ESS.APPLICATION_ID APPLICATION_ID
, ESS.ENTITY_CODE ENTITY_CODE
, ESS.EVENT_CLASS_CODE EVENT_CLASS_CODE
, ESS.SOURCE_APPLICATION_ID SOURCE_APPLICATION_ID
, ESS.SOURCE_TYPE_CODE SOURCE_TYPE_CODE
, ESS.SOURCE_CODE SOURCE_CODE
, ESS.LEVEL_CODE LEVEL_CODE
, LKP1.MEANING LEVEL_NAME
, STL.NAME SOURCE_NAME
, STL.DESCRIPTION DESCRIPTION
, ESS.ACTIVE_FLAG ACTIVE_FLAG
, ESS.CREATION_DATE CREATION_DATE
, ESS.CREATED_BY CREATED_BY
, ESS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ESS.LAST_UPDATED_BY LAST_UPDATED_BY
, ESS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM XLA_EVENT_SOURCES ESS
, XLA_SOURCES_VL STL
, XLA_LOOKUPS LKP1
WHERE ESS.SOURCE_APPLICATION_ID = STL.APPLICATION_ID
AND ESS.SOURCE_CODE = STL.SOURCE_CODE
AND ESS.SOURCE_TYPE_CODE = STL.SOURCE_TYPE_CODE
AND ESS.LEVEL_CODE = LKP1.LOOKUP_CODE
AND LKP1.LOOKUP_TYPE = 'XLA_LEVEL_CODE'