ZX Lines Summary

Description
Categories: Enginatics
Repository: Github
Tax lines summary to understand the different applications, entity codes and events that generate tax lines
Run ZX Lines Summary and other Oracle EBS reports with Blitz Report™ on our demo environment
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