ECC Channel Revenue Management, Open Claims

Description
Categories: Enterprise Command Center
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
Run ECC Channel Revenue Management, Open Claims and other Oracle EBS reports with Blitz Report™ on our demo environment
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