APPS.ISC_EDW_BOOKINGS_F_SIZE dependencies on OE_ORDER_LINES_ALL

Line 23: FROM OE_ORDER_LINES_ALL l,

19: BEGIN
20:
21: SELECT count(*)
22: INTO l_num_rows1
23: FROM OE_ORDER_LINES_ALL l,
24: OE_ORDER_HEADERS_ALL h
25: WHERE l.header_id = h.header_id
26: AND h.booked_date IS NOT NULL
27: AND (h.last_update_date between p_from_date and p_to_date

Line 34: OE_ORDER_LINES_ALL l

30: SELECT count(*)
31: INTO l_num_rows2
32: FROM RA_CUSTOMER_TRX_LINES_ALL ra,
33: OE_ORDER_HEADERS_ALL h,
34: OE_ORDER_LINES_ALL l
35: WHERE l.line_id = ra.interface_line_attribute6
36: AND l.header_id = h.header_id
37: AND h.booked_date IS NOT NULL
38: AND ra.interface_line_context = 'ORDER ENTRY'

Line 47: OE_ORDER_LINES_ALL l

43: SELECT count(*)
44: INTO l_num_rows3
45: FROM MTL_RESERVATIONS mtl,
46: OE_ORDER_HEADERS_ALL h,
47: OE_ORDER_LINES_ALL l
48: WHERE l.line_id = mtl.demand_source_line_id
49: AND l.header_id = h.header_id
50: AND h.booked_date IS NOT NULL
51: AND mtl.reservation_quantity is not null

Line 61: OE_ORDER_LINES_ALL l

57: SELECT count(*)
58: INTO l_num_rows4
59: FROM oe_order_lines_history hist,
60: OE_ORDER_HEADERS_ALL h,
61: OE_ORDER_LINES_ALL l
62: WHERE hist.line_id = l.line_id
63: AND l.header_id = h.header_id
64: AND h.booked_date IS NOT NULL
65: AND hist.hist_type_code = 'CANCELLATION'

Line 202: FROM OE_ORDER_LINES_ALL

198: nvl(avg(nvl(vsize(promise_date),0)),0),
199: nvl(avg(nvl(vsize(request_date),0)),0),
200: nvl(avg(nvl(vsize(schedule_ship_date),0)),0),
201: nvl(avg(nvl(vsize(item_type_code),0)),0)
202: FROM OE_ORDER_LINES_ALL
203: WHERE last_update_date BETWEEN p_from_date AND p_to_date;
204:
205: CURSOR c_2 IS
206: SELECT nvl(avg(nvl(vsize(agreement_type_code),0)),0)