ZX Lines Summary

➜ Back to Library
Description
Categories: Enginatics, Kcapps
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
Download
 
Related Blitz Reports
GL Account Analysis (Distributions) 11g GL Account Analysis (Distributions) COPY OF: GL Account Analysis GL Account Analysis AR Aggregate VAT Statement DVTST: AP Invoices with PO, Intercompany and SLA Details AP Invoices with PO, Intercompany and SLA Details GL Journals - Tax XXSJ Report VAT Register
Blitz Report™

Blitz Report™ provides multiple benefits: