APPS.ISC_EDW_BOOKINGS_F_SIZE dependencies on MTL_RESERVATIONS

Line 45: FROM MTL_RESERVATIONS mtl,

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

Line 258: FROM MTL_RESERVATIONS;

254: FROM RA_CUSTOMER_TRX_LINES_ALL;
255:
256: CURSOR c_12 IS
257: SELECT nvl(avg(nvl(vsize(reservation_quantity),0)),0)
258: FROM MTL_RESERVATIONS;
259:
260: CURSOR c_13 IS
261: SELECT nvl(avg(nvl(vsize(set_of_books_id),0)),0)
262: FROM FINANCIALS_SYSTEM_PARAMS_ALL;