VIEW: APPS.XLA_EVENT_SOURCES_FVL

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'