ECC Assets, Reconciliation, SQL1

Description
Columns: Ecc Spec Id, Acct Line Type, Gl Transfer Status, Ledger Name, Currency Code, Current Period, Last Closed Period, Book Type Code, Org Id, Asset Id ...
Imported from ECC
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")))