ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN EEE75CEB4AB86AD8E05362FB09051F8B select x.* from ( select * from ( SELECT RECORD_TYPE , ECC_SPEC_ID , PROJECT_ASSET_ID , PROJECT_ID , PROJECT_NUMBER , PROJECT_NAME , projfunc_currency_code , PROJECT_TYPE_CLASS_CODE , PROJECT_TYPE_CLASS , PROJECT_TYPE , ASSET_NUMBER , ASSET_NAME , ASSET_DESCRIPTION , LOCATION_ID , FIXED_ASSET_NUMBER , FIXED_ASSET_STATUS , FIXED_ASSET_STATUS_CODE , BUDGETED_COST , ESTIMATED_COST , DATE_PLACED_IN_SERVICE , ASSET_CATEGORY_ID , ASSET_CATEGORY , TOTAL_EXPENDITURES , NUMBER_OF_TASKS , TXN_PENDING_COST_DIST , TXN_PENDING_BURDEN_DIST , NUMBER_OF_ASSET_LINES , NUMBER_OF_REJ_ASSET_LINES , COST_PENDING_SUMMARIZATION , COST_PENDING_FINAL_ACC , COST_PENDING_AL_GEN , COST_AL_PEND_INTF_FA , COST_REJ_ASSET_LINES , ASSET_RETIRED_IN_FA , CAPITAL_HOLD , MARKED_FOR_AL_REVERSAL , COST_ADJUSTMENT_FLAG , CAPITALIZED , CAPITALIZED_FLAG , CAPITALIZED_DATE , REVERSAL_DATE , CAPITALIZED_COST , GROUPED_CIP_COST , ORG_ID , ORGANIZATION_NAME , ASSET_KEY_CCID , CAPITAL_EVENT_ID , PARENT_ASSET_ID , PROJECT_ASSET_TYPE_CODE , PROJECT_ASSET_TYPE , FA_ASSET_ID , BOOK_TYPE_CODE , ASSET_UNITS , DEPRECIATE_FLAG , ESTIMATED_IN_SERVICE_DATE , ESTIMATED_ASSET_UNITS , ASSET_PAST_DUE , PROJECT_ASSET_LINE_ID , LINE_DESCRIPTION , TASK_ID , TASK_NUMBER , TASK_NAME , CIP_ACCOUNT , ORIGINAL_ASSET_COST , CURRENT_ASSET_COST , PROJECT_ASSET_LINE_DETAIL_ID , GL_DATE , ORIGINAL_ASSET_ID , TRANSFER_STATUS_CODE , AL_STATUS_IN_PROJECTS , TRANSFER_REJECTION_REASON , AMORTIZE_FLAG , NEW_MASTER_FLAG , FA_PERIOD_NAME , QUANTITY , AMOUNT , INTERFACE_TO_FA , PO_VENDOR , PO_NUMBER , PO_LINE_NUMBER , RECEIPT_NUMBER , RECEIPT_LINE_NUMBER , INVOICE_NO , INVOICE_LINE_NUMBER , INVOICE_DISTRIBUTION_ID , LINE_TYPE , EXPENDITURE_ITEM_ID , LINE_NUM , CIP_COST , REVERSED_FLAG , PROJ_ASSET_LINE_DTL_UNIQ_ID , ALERT_TYPE, ALERT_TEXT, TOTAL_ASSET_COST, LANGUAGE FROM pa_ecc_cost_assets where language in ('US') ) PIVOT ( max(PROJECT_TYPE_CLASS) as PROJECT_TYPE_CLASS , max(FIXED_ASSET_STATUS) as FIXED_ASSET_STATUS , max(CAPITAL_HOLD) as CAPITAL_HOLD , max(CAPITALIZED) as CAPITALIZED , max(ORGANIZATION_NAME) as ORGANIZATION_NAME , max(PROJECT_ASSET_TYPE) as PROJECT_ASSET_TYPE , max(AL_STATUS_IN_PROJECTS) as AL_STATUS_IN_PROJECTS , max(MARKED_FOR_AL_REVERSAL) as MARKED_FOR_AL_REVERSAL , max(ASSET_RETIRED_IN_FA) as ASSET_RETIRED_IN_FA , max(INTERFACE_TO_FA) as INTERFACE_TO_FA , max(ALERT_TEXT) as ALERT_TEXT, max(AMORTIZE_FLAG) as AMORTIZE_FLAG, max(NEW_MASTER_FLAG) as NEW_MASTER_FLAG, max(DEPRECIATE_FLAG) as DEPRECIATE_FLAG for LANGUAGE in ('US' "US")) ) x where 2=2 Y AR ECC المشروعات, تحديد تكلفة المشروعات: الأصول Imported from Enterprise Command Center Description: مجموعة البيانات للمعلومات الخاصة بالأصول Dataset Key: pa-ds-cost-asset Query Procedure: PA_ECC_COST_PROJ_PKG.LOAD_FULL_ASSETS_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues D ECC Projects, Projektkosten: Anlagen Imported from Enterprise Command Center Description: DatenSet mit Informationen über Anlagen Dataset Key: pa-ds-cost-asset Query Procedure: PA_ECC_COST_PROJ_PKG.LOAD_FULL_ASSETS_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues E ECC Projects, Costes de Proyectos: Activos Imported from Enterprise Command Center Description: Juego de datos para información sobre activos Dataset Key: pa-ds-cost-asset Query Procedure: PA_ECC_COST_PROJ_PKG.LOAD_FULL_ASSETS_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues F ECC Projects, Projects Costing : Immobilisations Imported from Enterprise Command Center Description: Jeu de données pour informations sur immos Dataset Key: pa-ds-cost-asset Query Procedure: PA_ECC_COST_PROJ_PKG.LOAD_FULL_ASSETS_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues I ECC Projects, Determin. costi progetti: cespiti Imported from Enterprise Command Center Description: Serie di dati per informazioni relative ai cespiti Dataset Key: pa-ds-cost-asset Query Procedure: PA_ECC_COST_PROJ_PKG.LOAD_FULL_ASSETS_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues JA ECC Projects, プロジェクト原価計算: 資産 Imported from Enterprise Command Center Description: 資産に関する情報のデータ・セット Dataset Key: pa-ds-cost-asset Query Procedure: PA_ECC_COST_PROJ_PKG.LOAD_FULL_ASSETS_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues KO ECC 프로젝트, 프로젝트 원가 계산: 자산 Imported from Enterprise Command Center Description: 자산 정보에 대한 데이터 세트 Dataset Key: pa-ds-cost-asset Query Procedure: PA_ECC_COST_PROJ_PKG.LOAD_FULL_ASSETS_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues RU ECC Проекты, Projects Costing: активы Imported from Enterprise Command Center Description: Набор данных об активах Dataset Key: pa-ds-cost-asset Query Procedure: PA_ECC_COST_PROJ_PKG.LOAD_FULL_ASSETS_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues S ECC Projekt, Projektuppföljning: Anläggningar Imported from Enterprise Command Center Description: Datauppsättning för information om anläggningar Dataset Key: pa-ds-cost-asset Query Procedure: PA_ECC_COST_PROJ_PKG.LOAD_FULL_ASSETS_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues TR ECC Projeler, Proje Maliyetlendirme: Varlıklar Imported from Enterprise Command Center Description: Varlıklar hakkındaki bilgiler için veri kümesi Dataset Key: pa-ds-cost-asset Query Procedure: PA_ECC_COST_PROJ_PKG.LOAD_FULL_ASSETS_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues US ECC Projects, Projects Costing: Assets Imported from Enterprise Command Center Description: Data set for information about assets Dataset Key: pa-ds-cost-asset Query Procedure: PA_ECC_COST_PROJ_PKG.LOAD_FULL_ASSETS_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues ZHS ECC Projects, 项目成本计算：资产 Imported from Enterprise Command Center Description: 资产相关信息的数据集 Dataset Key: pa-ds-cost-asset Query Procedure: PA_ECC_COST_PROJ_PKG.LOAD_FULL_ASSETS_DATA Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues Enterprise Command Center