ECC Assets, Pipeline

Description
Categories: Enterprise Command Center
Columns: Source, Ecc Spec Id, Org Id, Ledger Name, Period Name, Book Type Code, Asset Category Id, Assets Addition Flag, Assets Tracking Flag, Asset Category ...
Imported from Enterprise Command Center
Dataset Key: fa-clr
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_CLR_V where language in ('US'))
                                       PIVOT (max(FUNCTIONAL_CURRENCY) as FUNCTIONAL_CURRENCY,
                                              max(ASSET_CATEGORY_NAME) as ASSET_CATEGORY_NAME,
                                              max(OPERATING_UNIT) as OPERATING_UNIT,
                                              max(PROJECT_CURRENCY) as PROJECT_CURRENCY,
                                              max(PROJ_TRANS_STATUS) as PROJ_TRANS_STATUS,
                                              MAX(INV_APPROVAL_STATUS) AS INV_APPROVAL_STATUS,
                                              MAX(INV_VALIDATION_STATUS) AS INV_VALIDATION_STATUS,
                                              max(INV_POSTING_FLAG) as INV_POSTING_FLAG,
                                              max(PO_NUMBER_DISPLAY) as PO_NUMBER_DISPLAY,
                                              max(RELEASE_NUMBER_DISPLAY) as RELEASE_NUMBER_DISPLAY,
                                              max(RECEIPT_NUMBER_DISPLAY) as RECEIPT_NUMBER_DISPLAY,
                                              max(INVOICE_CURRENCY) as INVOICE_CURRENCY
                                       for LANGUAGE in ('US' "US")))
) x
where
2=2