APPS.ISC_EDW_BOOKINGS_F_C dependencies on OE_ORDER_LINES_HISTORY

Line 397: oe_order_lines_history hist

393: SELECT l_seq_id,
394: hist.line_id||to_char(hist.hist_creation_date,'SSSSS'),
395: hist.line_id
396: FROM isc_tmp_pk isc,
397: oe_order_lines_history hist
398: WHERE isc.PK1 = hist.line_id
399: AND isc.seq_ID = p_parent_seq_id
400: AND hist.hist_type_code = 'CANCELLATION'
401: UNION

Line 405: FROM oe_order_lines_history hist

401: UNION
402: SELECT l_seq_id,
403: hist.line_id||to_char(hist.hist_creation_date,'SSSSS'),
404: hist.line_id
405: FROM oe_order_lines_history hist
406: WHERE hist.last_update_date BETWEEN g_push_from_date AND g_push_to_date
407: AND hist.hist_type_code = 'CANCELLATION';
408:
409: p_count := sql%rowcount;