ECC Service, Service Task
Description
Categories: Enterprise Command Center
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
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
Run
ECC Service, Service Task and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |