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
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 |