ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN EEE75CEB4A456AD8E05362FB09051F8B select x.* from ( SELECT * FROM ( SELECT /*+ leading(stv.PROF stv.inc) cardinality(stv.inc 1000) */ ECC_SPEC_ID,dfv.*, TASK_ID,CREATION_DATE,TASK_NUMBER,TASK_TYPE_ID,TASK_STATUS_ID,TASK_PRIORITY_ID,OWNER_ID,OWNER_TYPE_CODE,ADDRESS, PLANNED_START_DATE,PLANNED_END_DATE,SCHEDULED_START_DATE,SCHEDULED_END_DATE,ACTUAL_START_DATE,ACTUAL_END_DATE, SOURCE_OBJECT_TYPE_CODE,SOURCE_OBJECT_ID,SOURCE_OBJECT_NAME,REASON_CODE, PRIVATE_FLAG, PUBLISH_FLAG, RESTRICT_SR_CLOSURE, PARENT_TASK_ID, OPEN_FLAG,LOCATION_ID,LANGUAGE,FIELD_SERVICE_TASK_FLAG,ESCALATED_FLAG,AT_RISK_FLAG,PAST_DUE_FLAG, DUE_DATE,LAST_UPDATE_DATE,SERVICE_REQUEST,CUSTOMER,ALERT,GROUP_OWNER_ID,INCIDENT_TYPE_ID,INCIDENT_OWNER_ID,OWNER_GROUP_ID, TASK_SUBJECT,TASK_TYPE,STATUS,PRIORITY,OWNER,OWNER_TYPE,ASSIGNEE_NAME,ASSIGNEE_TYPE,AT_RISK,PAST_DUE, CS_ECC_UTIL_PVT.get_lookup_meaning_mls(OPEN_FLAG,'YES_NO',0,language) open_task, CS_ECC_UTIL_PVT.get_lookup_meaning_mls(ESCALATED_FLAG,'YES_NO',0,language) escalated ,task_owner_id,task_owner_code,task_owner_name,INVENTORY_ITEM_ID,inv_organization_id FROM CS_ECC_SERVICE_TASKS_V stv , (select "ROW_ID" "'JTB_ROW_ID'","CONTEXT_VALUE" "'JTB_CONTEXT_VALUE'","TASK_COMPLETION" "'JTB_TASK_COMPLETION'","CONCATENATED_SEGMENTS" "'JTB_CONCATENATED_SEGMENTS'" from ( select ROWID "ROW_ID",ATTRIBUTE_CATEGORY "CONTEXT_VALUE",ATTRIBUTE15 "TASK_COMPLETION",ATTRIBUTE15 "CONCATENATED_SEGMENTS" from JTF_TASKS_B )) dfv WHERE stv.TSK_ROWID = dfv."'JTB_ROW_ID'"(+) AND LANGUAGE in ('US') ) PIVOT( MAX(TASK_SUBJECT) AS TASK_SUBJECT, MAX(TASK_TYPE) AS TASK_TYPE, MAX(STATUS) AS STATUS, MAX(PRIORITY) AS PRIORITY, MAX(OWNER) AS OWNER, MAX(OWNER_TYPE) AS OWNER_TYPE, MAX(ASSIGNEE_NAME) AS ASSIGNEE_NAME, MAX(ASSIGNEE_TYPE) AS ASSIGNEE_TYPE, MAX(AT_RISK) AS AT_RISK, MAX(PAST_DUE) AS PAST_DUE, MAX(OPEN_TASK) AS OPEN_TASK, MAX(ESCALATED) AS ESCALATED, MAX(TASK_OWNER_NAME) AS TASK_OWNER_NAME for LANGUAGE in ('US' "US")) ) x where 2=2 Y AR ECC الخدمة, مهمة الخدمة Imported from Enterprise Command Center Description: تفاصيل المهمة لطلبات الخدمة Dataset Key: cs-task Query Procedure: CS_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: cs_ecc_datasecurity_pkg_pub.GetFilterAttributeValues D ECC Service, Serviceaufgabe Imported from Enterprise Command Center Description: Aufgabendetails für Serviceanfragen Dataset Key: cs-task Query Procedure: CS_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: cs_ecc_datasecurity_pkg_pub.GetFilterAttributeValues E ECC Service, Tarea de Servicio Imported from Enterprise Command Center Description: Detalles de tarea para solicitudes servicio Dataset Key: cs-task Query Procedure: CS_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: cs_ecc_datasecurity_pkg_pub.GetFilterAttributeValues F ECC Service, Tâche de service Imported from Enterprise Command Center Description: Détails de tâche pour demandes de service Dataset Key: cs-task Query Procedure: CS_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: cs_ecc_datasecurity_pkg_pub.GetFilterAttributeValues I ECC Assistenza, Task di assistenza Imported from Enterprise Command Center Description: Dettagli task per richieste di assistenza Dataset Key: cs-task Query Procedure: CS_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: cs_ecc_datasecurity_pkg_pub.GetFilterAttributeValues JA ECC サービス, サービス・タスク Imported from Enterprise Command Center Description: サービス要求のタスク詳細 Dataset Key: cs-task Query Procedure: CS_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: cs_ecc_datasecurity_pkg_pub.GetFilterAttributeValues KO ECC 서비스, 서비스 태스크 Imported from Enterprise Command Center Description: 서비스 요청에 대한 태스크 상세내역 Dataset Key: cs-task Query Procedure: CS_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: cs_ecc_datasecurity_pkg_pub.GetFilterAttributeValues RU ECC Обслуживание, Задачи обслуж. Imported from Enterprise Command Center Description: Сведения о задачах для запросов на обслуж. Dataset Key: cs-task Query Procedure: CS_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: cs_ecc_datasecurity_pkg_pub.GetFilterAttributeValues S ECC Service, Serviceuppgift Imported from Enterprise Command Center Description: Uppgiftsdetaljer för serviceärenden Dataset Key: cs-task Query Procedure: CS_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: cs_ecc_datasecurity_pkg_pub.GetFilterAttributeValues TR ECC Servis, Servis Görevi Imported from Enterprise Command Center Description: Servis istekleri için görev detayları Dataset Key: cs-task Query Procedure: CS_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: cs_ecc_datasecurity_pkg_pub.GetFilterAttributeValues US ECC Service, Service Task Imported from Enterprise Command Center Description: Task details for service requests Dataset Key: cs-task Query Procedure: CS_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: cs_ecc_datasecurity_pkg_pub.GetFilterAttributeValues ZHS ECC Service, 服务任务 Imported from Enterprise Command Center Description: 服务请求的任务详细信息 Dataset Key: cs-task Query Procedure: CS_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: cs_ecc_datasecurity_pkg_pub.GetFilterAttributeValues Enterprise Command Center