ECC Assets, Pipeline, SQL1

Description
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 ECC
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")))