ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN F947FFB3D3EB4F87E05362FB090533DEY select x.* from ( select * from ((SELECT dfv.*, trx_v.* FROM FA_ECC_F_ASSET_V trx_v , (select "ROW_ID" "'FA_ROW_ID'","CONTEXT_VALUE" "'FA_CONTEXT_VALUE'",fnd_ecc_dff_util.get_vset_values_dff('FA_ADDITIONS','INSURANCE_COMPANY',"INSURANCE_COMPANY",140,"CONTEXT_VALUE") "'FA_INSURANCE_COMPANY'",to_char("INSURANCE_RENEWAL_DATE") "'FA_INSURANCE_RENEWAL_DATE'",to_char("BUILDING_SIZE") "'FA_BUILDING_SIZE'",to_char("AREA") "'FA_AREA'","LICENSE_PLATE" "'FA_LICENSE_PLATE'",to_char("LICENSE_RENEWAL_DATE") "'FA_LICENSE_RENEWAL_DATE'","NUMBER_OF_AXLES" "'FA_NUMBER_OF_AXLES'",to_char("CARGO_SIZE") "'FA_CARGO_SIZE'","CONCATENATED_SEGMENTS" "'FA_CONCATENATED_SEGMENTS'","INSURANCE_COMPANY" "'FA_INSURANCE_COMPANY_EDOC'" from FA_ADDITIONS_B_DFV) dfv WHERE trx_v.language in ('US') AND trx_v.fa_rowid = dfv."'FA_ROW_ID'"(+) ) PIVOT (max(CURRENCY) as CURRENCY, max(ASSET_DESCRIPTION) as ASSET_DESCRIPTION, max(PARENT_DESCRIPTION) as PARENT_DESCRIPTION, max(PROPERTY_TYPE) as PROPERTY_TYPE, max(TRANSACTION_TYPE) as TRANSACTION_TYPE, max(ASSET_TYPE) as ASSET_TYPE, MAX(YEAR_AGING_BUCKET) AS YEAR_AGING_BUCKET, MAX(MONTH_AGING_BUCKET) AS MONTH_AGING_BUCKET for LANGUAGE in ('US' "US"))) ) x where 2=2 AR ECC الأصول, الأصول (1) Imported from Enterprise Command Center Dataset Key: fa-asset Query Procedure: FA_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: FA_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues D ECC Anlagen, Anlagen (1) Imported from Enterprise Command Center Dataset Key: fa-asset Query Procedure: FA_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: FA_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues E ECC Assets, Activos (1) Imported from Enterprise Command Center Dataset Key: fa-asset Query Procedure: FA_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: FA_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues F ECC Immos, Immos (1) Imported from Enterprise Command Center Dataset Key: fa-asset Query Procedure: FA_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: FA_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues I ECC Cespiti, Cespiti (1) Imported from Enterprise Command Center Dataset Key: fa-asset Query Procedure: FA_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: FA_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues JA ECC 資産, 資産 (1) Imported from Enterprise Command Center Dataset Key: fa-asset Query Procedure: FA_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: FA_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues KO ECC Assets, 자산 (1) Imported from Enterprise Command Center Dataset Key: fa-asset Query Procedure: FA_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: FA_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues RU ECC Активы, Активы (1) Imported from Enterprise Command Center Dataset Key: fa-asset Query Procedure: FA_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: FA_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues S ECC Anläggn., Anläggn. (1) Imported from Enterprise Command Center Dataset Key: fa-asset Query Procedure: FA_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: FA_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues TR ECC Varlıklar, Varlıklar (1) Imported from Enterprise Command Center Dataset Key: fa-asset Query Procedure: FA_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: FA_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues US ECC Assets, Fixed Assets (1) Imported from Enterprise Command Center Dataset Key: fa-asset Query Procedure: FA_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: FA_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues ZHS ECC Assets, 资产 (1) Imported from Enterprise Command Center Dataset Key: fa-asset Query Procedure: FA_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: FA_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues Enterprise Command Center