ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN EEE75CEB4A446AD8E05362FB09051F8BY select x.* from ( select * from (select /*+ leading(srd.PROF srd.inc ) cardinality(srd.inc 1000) */ ECC_SPEC_ID, SOURCE_TYPE, SOURCE_ID, SOURCE_NUMBER, INCIDENT_ID, JTF_NOTE_ID, NOTES, NOTE_TYPE, NOTE_TYPE_MEANING, NOTE_STATUS, NOTE_STATUS_MEANING,last_update_Date, note_language, incident_type_id, incident_owner_id, owner_group_id FROM CS_ECC_NOTES_DETAILS_V cd where note_language in ('US')) PIVOT ( MAX(SOURCE_TYPE) AS SOURCE_TYPE, MAX(NOTES) AS NOTES, MAX(NOTE_TYPE_MEANING) AS NOTE_TYPE_MEANING, MAX(NOTE_STATUS_MEANING) AS NOTE_STATUS_MEANING for NOTE_LANGUAGE in ('US' "US")) ) x where 2=2 AR ECC الخدمة, Service Notes Imported from Enterprise Command Center Dataset Key: cs-srnote Query Procedure: CS_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: CS_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues I ECC Assistenza, Service Notes Imported from Enterprise Command Center Dataset Key: cs-srnote Query Procedure: CS_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: CS_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues JA ECC サービス, Service Notes Imported from Enterprise Command Center Dataset Key: cs-srnote Query Procedure: CS_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: CS_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues KO ECC 서비스, Service Notes Imported from Enterprise Command Center Dataset Key: cs-srnote Query Procedure: CS_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: CS_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues RU ECC Обслуживание, Service Notes Imported from Enterprise Command Center Dataset Key: cs-srnote Query Procedure: CS_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: CS_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues TR ECC Servis, Service Notes Imported from Enterprise Command Center Dataset Key: cs-srnote Query Procedure: CS_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: CS_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues US ECC Service, Service Notes Imported from Enterprise Command Center Dataset Key: cs-srnote Query Procedure: CS_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: CS_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues Enterprise Command Center