XLA Entity Types and Event Class Attributes
Description
Categories: Enginatics
Repository: Github
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 |