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