ECC Assets, Pipeline

Description
Categories: Enterprise Command Center
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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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