APPS.ISC_EDW_BOOKINGS_F_SIZE dependencies on OE_ORDER_HEADERS_ALL

Line 24: OE_ORDER_HEADERS_ALL h

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
28: OR l.last_update_date between p_from_date and p_to_date);

Line 33: OE_ORDER_HEADERS_ALL h,

29:
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

Line 46: OE_ORDER_HEADERS_ALL h,

42:
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

Line 60: OE_ORDER_HEADERS_ALL h,

56:
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

Line 219: FROM OE_ORDER_HEADERS_ALL;

215: nvl(avg(nvl(vsize(sales_channel_code),0)),0),
216: nvl(avg(nvl(vsize(sold_to_org_id),0)),0),
217: nvl(avg(nvl(vsize(booked_date),0)),0),
218: nvl(avg(nvl(vsize(ordered_date),0)),0)
219: FROM OE_ORDER_HEADERS_ALL;
220:
221: -- Bug 5066532 : Removing BIM object dependency
222: -- CURSOR c_4 IS
223: -- SELECT nvl(avg(nvl(vsize(campaign_fk),0)),0),