ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 22F3F74443D88723E06362FB0905B88EY select x.* from ( select * from ((SELECT fnd_ecc_kff_util.get_vset_values_kff('CAT#','CATEGORY_FLEXFIELD','SEGMENT1',kfv."SEGMENT1",1002485, NULL ,NULL,140,rec_v.language) "BASED_CATEGORY",fnd_ecc_kff_util.get_vset_values_kff('CAT#','CATEGORY_FLEXFIELD','SEGMENT2',kfv."SEGMENT2",1002486,kfv.SEGMENT1,NULL ,140,rec_v.language) "MINOR_CATEGORY",kfv.SEGMENT1 "BASED_CATEGORY_CODE",kfv.SEGMENT2 "MINOR_CATEGORY_CODE" , rec_v.* FROM FA_ECC_F_REC_V rec_v , FA_CATEGORIES_B_KFV kfv where rec_v.language in ('US') AND rec_v.asset_category_id = kfv.category_id ) PIVOT (MAX( "BASED_CATEGORY") AS "BASED_CATEGORY",MAX( "MINOR_CATEGORY") AS "MINOR_CATEGORY" , max(ACCT_LINE_TYPE_NAME) as ACCT_LINE_TYPE_NAME, max(AE_LINE_REFERENCE) as AE_LINE_REFERENCE, max(ASSET_DESCRIPTION) as ASSET_DESCRIPTION, max(GL_TRANSFER_STATUS_NAME) as GL_TRANSFER_STATUS_NAME, max(CURRENCY) as CURRENCY, max(XLA_BALANCE_TYPE) as XLA_BALANCE_TYPE, MAX(ACCOUNTING_ENTRY_STATUS) AS ACCOUNTING_ENTRY_STATUS, MAX(XLA_GL_TRANSFER_STATUS) AS XLA_GL_TRANSFER_STATUS, max(JE_SOURCE_NAME) as JE_SOURCE_NAME, max(JE_CATEGORY_NAME) as JE_CATEGORY_NAME for LANGUAGE in ('US' "US"))) ) x where 2=2 AR ECC الأصول, التسوية (1) Imported from Enterprise Command Center Dataset Key: fa-rec Query Procedure: FA_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: FA_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues D ECC Anlagen, Abstimmung (1) Imported from Enterprise Command Center Dataset Key: fa-rec Query Procedure: FA_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: FA_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues E ECC Assets, Conciliación (1) Imported from Enterprise Command Center Dataset Key: fa-rec Query Procedure: FA_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: FA_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues F ECC Immos, Rapprochement (1) Imported from Enterprise Command Center Dataset Key: fa-rec Query Procedure: FA_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: FA_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues I ECC Cespiti, Quadratura (1) Imported from Enterprise Command Center Dataset Key: fa-rec 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-rec 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-rec 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-rec Query Procedure: FA_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: FA_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues S ECC Anläggn., Avstämning (1) Imported from Enterprise Command Center Dataset Key: fa-rec Query Procedure: FA_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: FA_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues TR ECC Varlıklar, Mutabakat (1) Imported from Enterprise Command Center Dataset Key: fa-rec Query Procedure: FA_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: FA_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues US ECC Assets, Reconciliation (1) Imported from Enterprise Command Center Dataset Key: fa-rec 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-rec Query Procedure: FA_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: FA_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues Enterprise Command Center 2=2