ECC Receivables, Billing Process, SQL3

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