eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_ORDER_PURGE_PVT dependencies on OE_ORDER_LINES_HISTORY

Line 2479: FROM oe_order_lines_history

2475: WHERE header_id = p_header_id;
2476:
2477: CURSOR c_purge_lines_hist IS
2478: SELECT line_id
2479: FROM oe_order_lines_history
2480: WHERE header_id = p_header_id
2481: FOR UPDATE NOWAIT;
2482:
2483: CURSOR c_purge_ds IS

Line 2675: DELETE FROM oe_order_lines_history WHERE header_id = p_header_id;

2671: -- Purge the History tables
2672:
2673: OPEN c_purge_lines_hist;
2674: CLOSE c_purge_lines_hist;
2675: DELETE FROM oe_order_lines_history WHERE header_id = p_header_id;
2676:
2677: OE_DEBUG_PUB.Add('Before line delete : ',1);
2678:
2679: DELETE FROM oe_order_lines