ECC Receivables, Billing Process, SQL3

Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: ar-billproc
Query Procedure: AR_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: AR_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues
Run ECC Receivables, Billing Process, SQL3 and other Oracle EBS reports with Blitz Report™ on our demo environment
select
x.*
from
(
select * from (SELECT ERROR_COUNT
, TYPE
, MESSAGE
, ORG_ID
, OPERATING_UNIT
, LEDGER_CURRENCY
, LEDGER
, ECC_SPEC_ID
, RECORD_TYPE
, LANGUAGE
 FROM ar_ecc_interface_error_v where language in ('US'))
 PIVOT(max(OPERATING_UNIT) as OPERATING_UNIT, max(LEDGER_CURRENCY) as LEDGER_CURRENCY
   for LANGUAGE in ('US' "US"))
) x
where
2=2
Parameter Name SQL text Validation
Operating Unit
x.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:operating_unit)
LOV