DBA Data[Home] [Help]

APPS.ISC_EDW_BOOK_SUM1_F_C dependencies on OE_ORDER_LINES_ALL

Line 433: oe_order_lines_all l

429: SELECT /*+ PARALLEL(h) */
430: distinct to_char(h.header_id),
431: l_seq_id
432: FROM oe_order_headers_all h,
433: oe_order_lines_all l
434: WHERE h.last_update_date between g_push_from_date AND g_push_to_date
435: AND h.booked_date between g_push_from_booked_date AND g_push_to_booked_date
436: AND l.header_id = h.header_id
437: UNION

Line 441: FROM oe_order_lines_all l,

437: UNION
438: SELECT /*+ PARALLEL(l) */
439: distinct to_char(l.header_id),
440: l_seq_id
441: FROM oe_order_lines_all l,
442: oe_order_headers_all h
443: WHERE l.last_update_date between g_push_from_date AND g_push_to_date
444: AND h.booked_date between g_push_from_booked_date AND g_push_to_booked_date
445: AND l.header_id = h.header_id;