ECC Channel Revenue Management, Closed Claims

Description
Categories: Enterprise Command Center
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 Enterprise Command Center
Description: Data Set for Channel Closed Claims
Dataset Key: ozf-closed-claim
Query Procedure: OZF_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: OZF_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues
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
Parameter Name SQL text Validation
Operating Unit
x.fc_org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:operating_unit)
LOV