ECC Channel Revenue Management, Budgets

Description
Categories: Enterprise Command Center
Columns: Ecc Spec Id, 'Ozffun Row Id', 'Ozffun Context Value', 'Ozffun Additional Info', 'Ozffun Concatenated Segments', Benef Party Id, Benef Party Name, Benef Account Number, Cust Party Id, Cust Party Name ...
Imported from Enterprise Command Center
Description: Data Set for Channel Budgets
Dataset Key: ozf-budget
Query Procedure: OZF_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_BUDGET
Security Procedure:
select
x.*
from
(
SELECT * FROM
		(SELECT /*+ leading (fun.earn_paid fun.statusvl fun.funo fun.fun_tl fun.onr fun.hraou fun.hrou)  use_nl(fun.funo fun.fun_tl fun.onr fun.statusvl) */
		  ECC_SPEC_ID, dfv.*, BENEF_PARTY_ID,BENEF_PARTY_NAME,BENEF_ACCOUNT_NUMBER,CUST_PARTY_ID,CUST_PARTY_NAME,CUST_ACCOUNT_NUMBER
		,CUST_ACCOUNT_ID,BILL_TO_CUST_ACCOUNT_ID,BILL_TO_SITE_USE_ID,BILL_TO_SITE_NAME,BILL_TO_ADDR,SHIP_TO_SITE_USE_ID
		,SHIP_TO_CUSTOMER,SHIP_TO_ACCOUNT_NUMBER,SHIP_TO_SITE_NAME,SHIP_TO_ADDR
		,PLAN_TYPE,PLAN_TYPE_MEANING,PLAN_ID,ACTIVITY_NAME,FUND_ID,FUND_NAME,FUND_LEDGER_NAME,LEDGER_ID,FUND_CURRENCY_CODE
		,FUND_CURRENCY_NAME,COMMON_CURRENCY_NAME,STATUS_CODE,FUND_STATUS,FUND_OWNER_ID,OWNER_NAME,CATEGORY_ID,CATEGORY_NAME,ORG_ID
		,OU_NAME,EARNED_AMOUNT,PAID_AMOUNT,CONV_EARNED_AMOUNT,CONV_PAID_AMOUNT,FUND_START_DATE_ACTIVE,FUND_END_DATE_ACTIVE,MARKETING_ACTIVITY
		,OFFER_TYPE,TEAM,LANGUAGE_CODE
		FROM OZF_ECC_F_BUDGETS_V fun
		  , (select ROW_ID "'OZFFUN_ROW_ID'",CONTEXT_VALUE "'OZFFUN_CONTEXT_VALUE'",ADDITIONAL_INFO "'OZFFUN_ADDITIONAL_INFO'",CONCATENATED_SEGMENTS "'OZFFUN_CONCATENATED_SEGMENTS'" from OZF_FUNDS_ALL_B_DFV) dfv  WHERE fun.fun_rowid = dfv."'OZFFUN_ROW_ID'"(+) and fun.language_code in ('US'))PIVOT
		( max(PLAN_TYPE_MEANING) as PLAN_TYPE_MEANING,
		 max(ACTIVITY_NAME) as ACTIVITY_NAME,
		 max(FUND_NAME) as FUND_NAME,
		 max(FUND_CURRENCY_NAME) as FUND_CURRENCY_NAME,
		 max(COMMON_CURRENCY_NAME) as COMMON_CURRENCY_NAME,
		 max(FUND_STATUS) as FUND_STATUS,
		 max(OWNER_NAME) as OWNER_NAME,
		 max(CATEGORY_NAME) as CATEGORY_NAME,
		 max(OU_NAME) as OU_NAME,
		 max(MARKETING_ACTIVITY) as MARKETING_ACTIVITY,
		 max(OFFER_TYPE) as OFFER_TYPE
		 for LANGUAGE_CODE in ('US' "US"))
) x
where
2=2
Parameter Name SQL text Validation
Operating Unit
x.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:operating_unit)
LOV