ECC Assets, Reconciliation

select
x.*
from
(
select * from ((SELECT * FROM FA_ECC_F_REC_V where language in ('US') )
                                       PIVOT (max(ACCT_LINE_TYPE_NAME) as ACCT_LINE_TYPE_NAME,
                                              max(AE_LINE_REFERENCE) as AE_LINE_REFERENCE,
                                              max(ASSET_DESCRIPTION) as ASSET_DESCRIPTION,
                                              max(GL_TRANSFER_STATUS_NAME) as GL_TRANSFER_STATUS_NAME,
                                              max(CURRENCY) as CURRENCY,
                                              max(XLA_BALANCE_TYPE) as XLA_BALANCE_TYPE,
                                              MAX(ACCOUNTING_ENTRY_STATUS) AS ACCOUNTING_ENTRY_STATUS,
                                              MAX(XLA_GL_TRANSFER_STATUS) AS XLA_GL_TRANSFER_STATUS,
                                              max(JE_SOURCE_NAME) as JE_SOURCE_NAME,
                                              max(JE_CATEGORY_NAME) as JE_CATEGORY_NAME
                                       for LANGUAGE in ('US' "US")))
) x
where
2=2