DBA Data[Home] [Help]

APPS.ISC_EDW_BOOKINGS_F_SIZE dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 32: FROM RA_CUSTOMER_TRX_LINES_ALL ra,

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

Line 254: FROM RA_CUSTOMER_TRX_LINES_ALL;

250: FROM OE_TRANSACTION_TYPES_TL;
251:
252: CURSOR c_11 IS
253: SELECT nvl(avg(nvl(vsize(quantity_invoiced),0)),0)
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;