DBA Data[Home] [Help]

APPS.OZF_QUOTA_THRESHOLD_PVT dependencies on OZF_CUST_DAILY_FACTS

Line 256: FROM ozf_product_allocations p, ozf_cust_daily_facts c

252: sum(c.current_period_target) monthly_quota,
253: sum(c.current_qtr_target) quarterly_quota,
254: sum(c.lysq_sales) lysq_sales,
255: sum(c.ly_sales) ly_sales
256: FROM ozf_product_allocations p, ozf_cust_daily_facts c
257: WHERE
258: p.item_type <> 'OTHERS' and
259: p.fund_id = p_budget_id and
260: p.item_id = c.product_attr_value and

Line 285: FROM ozf_account_allocations a, ozf_cust_daily_facts c

281: sum(c.current_period_target) monthly_quota,
282: sum(c.current_qtr_target) quarterly_quota,
283: sum(c.lysq_sales) lysq_sales,
284: sum(c.ly_sales) ly_sales
285: FROM ozf_account_allocations a, ozf_cust_daily_facts c
286: WHERE
287: a.allocation_for = 'FUND' and
288: a.allocation_for_id = p_budget_id and
289: a.site_use_code = 'SHIP_TO' and