ECC Channel Revenue Management, Open Claims, SQL1

Description
Columns: Ecc Spec Id, 'Ozfcla Row Id', 'Ozfcla Context Value', 'Ozfcla Concatenated Segments', Fc Org Id, Fc Claim Id, Ecc Last Update Date, Fc Claim Number, Fc Claim Type Id, Fc Status Code ...
Imported from ECC
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_COMMENTS,FC_CUSTOMER_REASON,FC_AMOUNT,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,DDC_REPORT_DATE,DDC_MONTH_SEQ,DDC_MONTH_NAME,
		DDC_QTR_SEQ,DDC_QTR_NAME,DDC_YEAR_SEQ,DDC_YEAR_NAME,DDC_AGE_DAYS,TEAM,
		FC_TRANS_AMOUNT,FC_TRANS_CURRENCY,OPEN_DAYS,LANGUAGE_CODE
		FROM OZF_ECC_F_OPEN_CLAIMS_V cla
		 , (select 'OZFCLA_ROW_ID','OZFCLA_CONTEXT_VALUE','OZFCLA_CONCATENATED_SEGMENTS' from dual where 1=2  union select ROWIDTOCHAR(ROW_ID),CONTEXT_VALUE,CONCATENATED_SEGMENTS from OZF_CLAIMS_ALL_DFV) dfv  WHERE cla.cla_rowid = dfv."'OZFCLA_ROW_ID'"(+) and cla.language_code in ('US'))
		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(FC_COMN_CURR_CODE) as FC_COMN_CURR_CODE,
		 max(FC_OWNER_NAME) as FC_OWNER_NAME,
		 max(DDC_AGE_DAYS) as DDC_AGE_DAYS,
		 max(FC_TRANS_CURRENCY) as FC_TRANS_CURRENCY
		 for LANGUAGE_CODE in ('US' "US"))