AR Autoinvoice Interface Summary

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Summary of records in the autoinvoice interface, sorted by operating unit, and including order count, total orders value and currency code.
select
haouv.name operating_unit,
count(*) count,
count(distinct decode(rila.interface_line_context,'ORDER ENTRY',rila.interface_line_attribute1)) order_count,
&lp_columns
sum(rila.amount) amount,
rila.currency_code,
riea.message_text,
rila.batch_source_name,
rila.interface_line_context,
rila.request_id
from
hr_all_organization_units_vl haouv,
ra_interface_lines_all rila,
ra_interface_errors_all riea
where
1=1 and
haouv.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) and
haouv.organization_id=rila.org_id and
rila.interface_line_id=riea.interface_line_id(+)
group by
haouv.name,
&group_by
rila.currency_code,
riea.message_text,
rila.interface_status,
rila.batch_source_name,
rila.interface_line_context,
rila.request_id
order by
haouv.name,
count(*) desc
Parameter NameSQL textValidation
Operating Unit
haouv.name=:operating_unit
LOV
Show Age
trunc(sysdate-rila.creation_date) age,
LOV
Download
Related Blitz Reports
COPY OF: AR Autoinvoice Interface Summary CAC Interface Error Summary INV Intercompany Invoice Reconciliation 11i INV Intercompany Invoice Reconciliation CAC AP Accrual IR ISO Match Analysis ONT Orders and Lines WSH Shipping/Delivery Transactions(GST) ONT Orders and Lines (GST) OKS Service Contracts Billing Schedule
Blitz Report™