ECC Channel Revenue Management, Closed Claims

select
x.*
from
(
SELECT * FROM
				(SELECT ECC_SPEC_ID, dfv.*, FC_ORG_ID,FC_CLAIM_OU,FC_CLAIM_ID,ECC_LAST_UPDATE_DATE,FC_CLAIM_NUMBER,DR_REASON_NAME,FC_CLAIM_TYPE_ID,DT_NAME,DT_DESCRIPTION,
				DR_CLAIM_CLASS_NAME,FC_STATUS_CODE,FC_STATUS,FC_PAYMENT_STATUS,DR_PAYMENT_STATUS_NAME,FC_COMMENTS,FC_VENDOR_ID,FC_VENDOR_NAME,
				FC_VENDOR_SITE_ID,FC_VENDOR_SITE_CODE,FC_VENDOR_ADDRESS,FC_CUSTOMER_REASON,FC_AMOUNT,FC_ACCTD_AMOUNT,FC_CONVERTED_ACCTD_AMT,FC_COMN_CURR_CODE,
				FC_ACCTD_AMOUNT_CUR,FC_ACCTD_AMT_REMAINING,FC_FUNC_AMOUNT,FC_BROKER_NAME,FC_SALES_REP_NAME,FC_OWNER_NAME,FC_CLAIM_DATE,DC_PARTY_NAME,DC_PARTY_ID,
				FC_CUST_ACCOUNT_ID,DC_ACCT_NUMBER,FC_BILLTO_ACCT_SITE_ID,FC_BILL_TO_SITE_NAME,FC_BILL_TO_ADDR,FC_SHIP_TO_CUST,FC_SHIP_TO_ACCT_NUMBER,
				FC_SHIP_TO_SITE_NAME,FC_SHIP_TO_ADDR,FC_CUST_REF_NUMBER,FC_CUST_REF_DATE,FC_RECEIPT_NUMBER,FC_INVOICE_NUMBER,FC_SETTLED_DATE,FC_PAYMENT_METHOD,
				FC_ACCTD_AMT_SETTLED,FC_DAYS_TO_SETTLE,FC_IS_PROMOTIONAL,DO_OFFER_CODE,FC_SPLIT_AMOUNT,DI_ITEM,DI_ITEM_NAME,DI_ITEM_DEC,
				DDS_MONTH_NAME,DDS_QTR_NAME,DDS_YEAR_NAME,FC_TRANSACTION_TYPE,FC_TRANSACTION_NUMBER,FC_ACTIVITY_NAME,TEAM,
				DO_OFFER_KEY,FC_TRANS_AMOUNT,FC_TRANS_CURRENCY,FC_WRITEOFF_AMOUNT,LANGUAGE_CODE FROM OZF_ECC_F_CLOSE_CLAIMS_V cla
				 , (select ROW_ID "'OZFCLA_ROW_ID'",CONTEXT_VALUE "'OZFCLA_CONTEXT_VALUE'",CONCATENATED_SEGMENTS "'OZFCLA_CONCATENATED_SEGMENTS'" from OZF_CLAIMS_ALL_DFV) dfv  WHERE cla.cla_rowid = dfv."'OZFCLA_ROW_ID'"(+))
				PIVOT
			       (max(FC_CLAIM_OU) as FC_CLAIM_OU,
				max(DR_REASON_NAME) as DR_REASON_NAME,
				max(DT_NAME) as DT_NAME,
				max(DT_DESCRIPTION) as DT_DESCRIPTION,
				max(DR_CLAIM_CLASS_NAME) as DR_CLAIM_CLASS_NAME,
				max(FC_STATUS) as FC_STATUS,
				max(DR_PAYMENT_STATUS_NAME) as DR_PAYMENT_STATUS_NAME,
				max(FC_COMN_CURR_CODE) as FC_COMN_CURR_CODE,
				max(FC_OWNER_NAME) as FC_OWNER_NAME,
				max(FC_PAYMENT_METHOD) as FC_PAYMENT_METHOD,
				max(DO_OFFER_CODE) as DO_OFFER_CODE,
				max(DI_ITEM_NAME) as DI_ITEM_NAME,
				max(DI_ITEM_DEC) as DI_ITEM_DEC,
				max(FC_ACTIVITY_NAME) as FC_ACTIVITY_NAME,
				max(FC_TRANS_CURRENCY) as FC_TRANS_CURRENCY
				for LANGUAGE_CODE in ('US' "US"))
) x
where
2=2