DBA Data[Home] [Help]

APPS.OZF_QUOTA_THRESHOLD_PVT dependencies on OZF_PRODUCT_ALLOCATIONS

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