APPS.OE_BIS_ALERTS dependencies on OE_BIS_CUST_SAT_V

Line 44: from oe_bis_cust_sat_v

40: if p_target_level_short_name = 'SHIPVALUE_TOP' then
41: begin
42: select year_period, decode(sum(net_sales),0,0,sum(del_sales)/sum(net_sales) * 100)
43: into l_time_period, l_actual_value
44: from oe_bis_cust_sat_v
45: where set_of_books_id = p_set_of_books_id
46: and sales_channel_code = p_sales_channel
47: and category_id = p_prod_catg
48: and area = p_area

Line 61: from oe_bis_cust_sat_v

57: elsif p_target_level_short_name = 'RETVALUE_TOP' then
58: begin
59: select year_period, decode(sum(net_sales),0,0,sum(ret_sales)/sum(net_sales) * 100)
60: into l_time_period, l_actual_value
61: from oe_bis_cust_sat_v
62: where set_of_books_id = p_set_of_books_id
63: and sales_channel_code = p_sales_channel
64: and category_id = P_prod_catg
65: and area = p_area

Line 76: from oe_bis_cust_sat_v

72: elsif p_target_level_short_name = 'SHIPVALUE_ALL' then
73: begin
74: select year_period, decode(sum(net_sales),0,0,sum(del_sales)/sum(net_sales) * 100)
75: into l_time_period, l_actual_value
76: from oe_bis_cust_sat_v
77: where set_of_books_id = p_set_of_books_id
78: and period_set_name || '+' || year_period = p_period_set_name
79: group by year_period;
80: exception

Line 88: from oe_bis_cust_sat_v

84: elsif p_target_level_short_name = 'RETVALUE_ALL' then
85: begin
86: select year_period, decode(sum(net_sales),0,0,sum(ret_sales)/sum(net_sales) * 100)
87: into l_time_period, l_actual_value
88: from oe_bis_cust_sat_v
89: where set_of_books_id = p_set_of_books_id
90: and period_set_name || '+' || year_period = p_period_set_name
91: group by year_period;
92: exception

Line 159: FROM oe_bis_cust_sat_v;

155: i NUMBER := 0;
156:
157: CURSOR cr_set_of_books IS
158: SELECT distinct set_of_books_id
159: FROM oe_bis_cust_sat_v;
160:
161: CURSOR cr_target IS
162: SELECT tv.target_level_short_name
163: , tv.target_level_name

Line 293: from oe_bis_cust_sat_v

289: end;
290:
291: begin
292: select distinct category_desc into l_catg_name
293: from oe_bis_cust_sat_v
294: where category_id = cr.dim2_level_value_id ;
295: exception
296: when others then
297: l_catg_name := null;