APPS.OE_BIS dependencies on OE_BIS_BOOKINGS_V

Line 51: from oe_bis_bookings_v

47:
48: begin
49: select count(*)
50: into p_days_bookings
51: from oe_bis_bookings_v
52: where customer_id in
53: (select customer_id from oe_bis_top_customers)
54: and trunc(booking_date) = p_day
55: and nvl(p_org_id,ou_id) = ou_id;

Line 136: from oe_bis_bookings_v

132: trunc(sysdate),'Corporate'),
133: 1) *
134: (ordered_quantity - cancelled_quantity) *
135: unit_selling_price) sales
136: from oe_bis_bookings_v
137: where booking_date between
138: to_date('01-01-'||to_char(sysdate,'YYYY'),'DD-MM-YYYY')
139: and sysdate
140: and nvl(p_org_id,ou_id) = ou_id

Line 190: from oe_bis_bookings_v

186: 'Y', gl_currency_API.get_rate(line_currency, p_currency,
187: trunc(sysdate),'Corporate'),
188: 1) *
189: line_selling_price)
190: from oe_bis_bookings_v
191: where booking_date between p_period_start and p_period_end
192: and nvl(p_org_id,ou_id) = ou_id
193: and customer_id = c.customer_id);
194:

Line 247: from oe_bis_bookings_v

243:
244: update oe_bis_top_customers c set
245: order_lines =
246: (select count(distinct line_id)
247: from oe_bis_bookings_v
248: where customer_id = c.customer_id
249: and ou_id = nvl(p_org_id,ou_id)
250: and booking_date between p_period_start and p_period_end);
251:

Line 301: from oe_bis_bookings_v

297: 'Y', gl_currency_API.get_rate(line_currency, bbb.currency_code,
298: trunc(sysdate),'Corporate'),
299: 1) *
300: line_selling_price)
301: from oe_bis_bookings_v
302: where booking_date between bbb.period_start and bbb.period_end
303: and nvl(p_org_id,ou_id) = ou_id);
304:
305: update oe_bis_bbb_info bbb set