DBA Data[Home] [Help]

APPS.OZF_CUST_FACTS_PVT dependencies on OZF_BASELINE_SALES_V

Line 262: ozf_baseline_sales_v b

258: p_item_id NUMBER ) IS
259: SELECT b.period_type_id,
260: NVL(SUM(b.baseline_sales),0) base_sales
261: FROM ozf_time_rpt_struct a,
262: ozf_baseline_sales_v b
263: WHERE a.report_date = p_report_date
264: AND BITAND(a.record_type_id, 119) = a.record_type_id
265: AND a.time_id = b.time_id
266: AND b.data_source = fnd_profile.value('OZF_DASH_BASELINE_SALES_SRC')