DBA Data[Home] [Help]

APPS.OZF_QUOTA_THRESHOLD_PVT dependencies on OZF_ACCOUNT_ALLOCATIONS

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