ECC Channel Revenue Management, Open 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 Open Claims
Dataset Key: ozf-open-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_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 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'"(+) 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"))
) 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