DBA Data[Home] [Help]

APPS.OE_BIS dependencies on OE_BIS_TOP_CUSTOMERS

Line 53: (select customer_id from oe_bis_top_customers)

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;
56:
57: exception

Line 67: (select customer_id from oe_bis_top_customers)

63: select count(*)
64: into p_days_returns
65: from so_lines_all l, so_headers_all h
66: where h.customer_id in
67: (select customer_id from oe_bis_top_customers)
68: and l.creation_date = p_day
69: and nvl(p_org_id,l.org_id) = l.org_id
70: and l.line_type_code = 'RETURN';
71:

Line 102: from oe_bis_top_customers)

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
104: and nvl(p_org_id,ou_id) = ou_id;
105:
106: exception

Line 148: -- lock table oe_bis_top_customers in exclusive mode nowait;

144: counter number :=0;
145:
146: begin
147:
148: -- lock table oe_bis_top_customers in exclusive mode nowait;
149:
150: delete from oe_bis_top_customers;
151: commit;
152:

Line 150: delete from oe_bis_top_customers;

146: begin
147:
148: -- lock table oe_bis_top_customers in exclusive mode nowait;
149:
150: delete from oe_bis_top_customers;
151: commit;
152:
153: FOR custrec in cust LOOP
154:

Line 155: insert into oe_bis_top_customers (

151: commit;
152:
153: FOR custrec in cust LOOP
154:
155: insert into oe_bis_top_customers (
156: customer_id,
157: ytd_sales,
158: currency_code,
159: period_start,

Line 181: update oe_bis_top_customers c

177:
178:
179: END LOOP;
180:
181: update oe_bis_top_customers c
182: set period_bookings =
183: (select sum(
184: decode(gl_currency_api.rate_exists(line_currency,p_currency,
185: trunc(sysdate),'Corporate'),

Line 195: update oe_bis_top_customers c set

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:
195: update oe_bis_top_customers c set
196: period_billings =
197: (select sum(
198: decode(gl_currency_api.rate_exists(line_currency,p_currency,
199: trunc(sysdate),'Corporate'),

Line 209: update oe_bis_top_customers c set

205: where invoicing_date between p_period_start and p_period_end
206: and nvl(p_org_id,ou_id) = ou_id
207: and customer_id = c.customer_id);
208:
209: update oe_bis_top_customers c set
210: current_backlog =
211: (select sum(
212: decode(gl_currency_api.rate_exists(line_currency,p_currency,
213: trunc(sysdate),'Corporate'),

Line 224: update oe_bis_top_customers c set

220: and nvl(p_org_id,ou_id) = ou_id);
221:
222: --lchen remove alias on_time_perent from following subquery to fix bug 1753574
223:
224: update oe_bis_top_customers c set
225: on_time_deliveries =
226: (select sum(decode(trunc(promise_date),
227: trunc(date_closed),1,0)) /
228: count(*) * 100

Line 233: update oe_bis_top_customers c set

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
234: return_lines =
235: (select count(*)
236: from so_lines_all l, so_headers_all h
237: where l.header_id = h.header_id

Line 244: update oe_bis_top_customers c set

240: and l.org_id = nvl(p_org_id,l.org_id)
241: and l.creation_date between
242: p_period_start and p_period_end);
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