ECC Channel Revenue Management, Budgets

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