ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 32EA9AC9519FBC4BE06362FB09058384 select x.* from ( SELECT * FROM (select /*+ leading(CS_ECC_SRTASKS_DEBRIEF_V.prof CS_ECC_SRTASKS_DEBRIEF_V.inc) index(CS_ECC_SRTASKS_DEBRIEF_V.inc CS_INCIDENTS_EN1) use_nl(CS_ECC_SRTASKS_DEBRIEF_V.jta CS_ECC_SRTASKS_DEBRIEF_V.jtb) use_nl(CS_ECC_SRTASKS_DEBRIEF_V.cdh CS_ECC_SRTASKS_DEBRIEF_V.cdl) */ ECC_SPEC_ID, INCIDENT_ID, SERVICE_REQUEST_NUMBER, INCIDENT_TYPE_ID, INCIDENT_OWNER_ID, OWNER_GROUP_ID, ORG_ID, DEBRIEF_HEADER_ID, DEBRIEF_NUMBER, DEBRIEF_LINE_ID, DEBRIEF_LINE_NUMBER, PROCESSED_FLAG, DEBRIEF_STATUS,TASK_ID,TASK_NUMBER, TASK_ASSIGNMENT_ID, ASSIGNMENT_STATUS_ID, TRANSACTION_TYPE_ID, SERVICE_ACTIVITY, BILLING_CATEGORY, INVENTORY_ITEM_ID, ITEM ,ISSUING_SUB_INVENTORY_CODE, RECEIVING_SUB_INVENTORY_CODE, REPLACED_QUANTITY, RETURN_QUANTITY, REPLACED_PART, RETURN_PART, LABOR_QUANTITY, EXPENSE_AMOUNT, LANGUAGE, LAST_UPDATE_DATE from CS_ECC_SRTASKS_DEBRIEF_V where LANGUAGE in ('US')) PIVOT(MAX(SERVICE_ACTIVITY) AS SERVICE_ACTIVITY, MAX(DEBRIEF_STATUS) AS DEBRIEF_STATUS, MAX(REPLACED_QUANTITY) AS REPLACED_QUANTITY, MAX(RETURN_QUANTITY) AS RETURN_QUANTITY, MAX(REPLACED_PART) AS REPLACED_PART, MAX(RETURN_PART) AS RETURN_PART, MAX(LABOR_QUANTITY) AS LABOR_QUANTITY for LANGUAGE in ('US' "US")) ) x where 2=2 Y AR ECC الخدمة, Service Debrief (1) Imported from Enterprise Command Center Description: Debrief data for all service requests Dataset Key: cs-debrief Query Procedure: CS_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: cs_ecc_datasecurity_pkg_pub.GetFilterAttributeValues D ECC Service, Service Debrief (1) Imported from Enterprise Command Center Description: Debrief data for all service requests Dataset Key: cs-debrief Query Procedure: CS_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: cs_ecc_datasecurity_pkg_pub.GetFilterAttributeValues E ECC Service, Service Debrief (1) Imported from Enterprise Command Center Description: Debrief data for all service requests Dataset Key: cs-debrief Query Procedure: CS_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: cs_ecc_datasecurity_pkg_pub.GetFilterAttributeValues F ECC Service, Service Debrief (1) Imported from Enterprise Command Center Description: Debrief data for all service requests Dataset Key: cs-debrief Query Procedure: CS_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: cs_ecc_datasecurity_pkg_pub.GetFilterAttributeValues I ECC Assistenza, Service Debrief (1) Imported from Enterprise Command Center Description: Debrief data for all service requests Dataset Key: cs-debrief Query Procedure: CS_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: cs_ecc_datasecurity_pkg_pub.GetFilterAttributeValues JA ECC サービス, Service Debrief (1) Imported from Enterprise Command Center Description: Debrief data for all service requests Dataset Key: cs-debrief Query Procedure: CS_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: cs_ecc_datasecurity_pkg_pub.GetFilterAttributeValues KO ECC 서비스, Service Debrief (1) Imported from Enterprise Command Center Description: Debrief data for all service requests Dataset Key: cs-debrief Query Procedure: CS_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: cs_ecc_datasecurity_pkg_pub.GetFilterAttributeValues RU ECC Обслуживание, Service Debrief (1) Imported from Enterprise Command Center Description: Debrief data for all service requests Dataset Key: cs-debrief Query Procedure: CS_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: cs_ecc_datasecurity_pkg_pub.GetFilterAttributeValues S ECC Service, Service Debrief (1) Imported from Enterprise Command Center Description: Debrief data for all service requests Dataset Key: cs-debrief Query Procedure: CS_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: cs_ecc_datasecurity_pkg_pub.GetFilterAttributeValues TR ECC Servis, Service Debrief (1) Imported from Enterprise Command Center Description: Debrief data for all service requests Dataset Key: cs-debrief Query Procedure: CS_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: cs_ecc_datasecurity_pkg_pub.GetFilterAttributeValues US ECC Service, Service Debrief (1) Imported from Enterprise Command Center Description: Debrief data for all service requests Dataset Key: cs-debrief Query Procedure: CS_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: cs_ecc_datasecurity_pkg_pub.GetFilterAttributeValues ZHS ECC Service, Service Debrief (1) Imported from Enterprise Command Center Description: Debrief data for all service requests Dataset Key: cs-debrief Query Procedure: CS_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: cs_ecc_datasecurity_pkg_pub.GetFilterAttributeValues Enterprise Command Center 2=2