XLA Entity Types and Event Class Attributes

Description
Categories: Enginatics
Repository: Github
Subledger event types and their attributes, for example reporting view
select
fav.application_short_name,
fav.application_name,
xetv.name entity_type,
xetv.description,
xetv.entity_code,
xeca.je_category_name,
xeca.event_class_code,
xeca.reporting_view_name,
xxen_util.yes(xeca.allow_actuals_flag) allow_actuals_flag,
xxen_util.yes(xeca.allow_budgets_flag) allow_budgets_flag,
xxen_util.yes(xeca.allow_encumbrance_flag) allow_encumbrance_flag
from
fnd_application_vl fav,
xla_entity_types_vl xetv,
xla_event_class_attrs xeca
where
1=1 and
fav.application_id=xetv.application_id and
xetv.entity_code=xeca.entity_code(+) and
xetv.application_id=xeca.application_id(+)
order by
fav.application_name,
xetv.entity_code,
xeca.event_class_code