ECC Service, Service Debrief

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