ECC Assets, Reconciliation

➜ Back to Library
Description
Categories: Enterprise Command Center
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
Run ECC Assets, Reconciliation and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Download
 
Related Blitz Reports
ECC Discrete Manufacturing, Resources PN Generate Lease Details ECC Process Manufacturing, Outside Processing Batch ECC Assets, Pipeline ECC Assets, Fixed Assets ECC Assets, Mass Transactions ECC Assets, Fixed Assets (1) XLA Distribution Links Summary PAY RTI - Earlier Year Update Output 2016/17
Blitz Report™

Blitz Report™ provides multiple benefits: