ZX Lines Summary

Description
Categories: Enginatics
Repository: Github Columns: Application Name, Entity Code, Event Class Code, Event Type Code, Trx Level Type, Count, Event Class Code Desc, Application Id ...
Tax lines summary to understand the different applications, entity codes and events that generate tax lines
select
fav.application_name,
zl.entity_code,
zl.event_class_code,
zl.event_type_code,
zl.trx_level_type,
count(*) count,
xxen_util.meaning(zl.event_class_code,'ZX_LINE_CLASS',0) event_class_code_desc,
zl.application_id
from
fnd_application_vl fav,
zx_lines zl
where
fav.application_id=zl.application_id
group by
fav.application_name,
zl.entity_code,
zl.event_class_code,
zl.event_type_code,
zl.trx_level_type,
zl.application_id
order by
fav.application_name,
zl.entity_code,
count(*) desc