ECC Service, Service Task

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