APPS.OZF_FUND_ALLOCATIONS_PVT dependencies on OZF_ORDER_SALES_SUMRY_MV

Line 336: ozf_order_sales_sumry_mv b

332: p_cust_account_id IN NUMBER)
333: IS
334: SELECT NVL(SUM(b.sales_amt),0) tot_sales
335: FROM ozf_time_rpt_struct a,
336: ozf_order_sales_sumry_mv b
337: WHERE a.report_date = p_as_of_date
338: AND BITAND(a.record_type_id, 119) = a.record_type_id
339: AND a.time_id = b.time_id
340: AND b.sold_to_cust_account_id = p_cust_account_id ;

Line 348: -- All data in the ozf_order_sales_sumry_mv is already converted

344: l_sales_for_cust NUMBER := 0;
345: l_total_terr_self_amount NUMBER := 0;
346: l_total_terr_rollup_amount NUMBER := 0;
347:
348: -- All data in the ozf_order_sales_sumry_mv is already converted
349: -- to this currency code;
350: l_common_currency_code VARCHAR2(30) := FND_PROFILE.VALUE('OZF_TP_COMMON_CURRENCY');
351:
352: l_st VARCHAR2(10);