ECC Assets, Reconciliation

Description
Categories: Enterprise Command Center
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 Enterprise Command Center
Dataset Key: fa-rec
Query Procedure: FA_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: FA_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues
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