ZX Lines Summary

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Tax lines summary to understand the different applications, entity codes and events that generate tax lines

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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) AR Transaction Upload EOS GL Account Analysis XXAR Transaction Upload XXRG GL Account Analysis GL Account Analysis AR Aggregate VAT Statement EOS GL Account Analysis with Tax
Blitz Report™

Blitz Report™ provides multiple benefits: