APPS.OE_BIS dependencies on WSH_BIS_FILL_RATE_V

Line 21: from wsh_bis_fill_rate_v

17: trunc(sysdate),'Corporate'),
18: 1) *
19: shipment_value)
20: into p_daily_value
21: from wsh_bis_fill_rate_v
22: where date_closed = p_day
23: and warehouse_id = p_warehouse_id;
24: */
25: select sum(shipment_value)

Line 27: from wsh_bis_fill_rate_v

23: and warehouse_id = p_warehouse_id;
24: */
25: select sum(shipment_value)
26: into p_daily_value
27: from wsh_bis_fill_rate_v
28: where date_closed = p_day
29: and warehouse_id = p_warehouse_id;
30:
31: return( p_daily_value);

Line 99: from wsh_bis_fill_rate_v

95: select sum(decode(trunc(promise_date),
96: trunc(date_closed),1,0)) /
97: count(*) * 100
98: into delivery_percent
99: from wsh_bis_fill_rate_v
100: where customer_id in
101: (select customer_id
102: from oe_bis_top_customers)
103: and promise_date = p_day

Line 229: from wsh_bis_fill_rate_v

225: on_time_deliveries =
226: (select sum(decode(trunc(promise_date),
227: trunc(date_closed),1,0)) /
228: count(*) * 100
229: from wsh_bis_fill_rate_v
230: where customer_id = c.customer_id
231: and promise_date between p_period_start and p_period_end);
232:
233: update oe_bis_top_customers c set