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: OZF_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues
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