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_LINE_UTIL dependencies on OE_ORDER_LINES_HISTORY

Line 10855: DELETE FROM OE_ORDER_LINES_HISTORY

10851:
10852: END LOOP; -- all the lines in a header.
10853:
10854: /* Start Audit Trail */
10855: DELETE FROM OE_ORDER_LINES_HISTORY
10856: WHERE HEADER_ID = p_header_id;
10857: /* End Audit Trail */
10858:
10859: DELETE FROM OE_ORDER_LINES

Line 11070: DELETE FROM OE_ORDER_LINES_HISTORY

11066:
11067: END IF; -- if service lines exist
11068:
11069: /* Start Audit Trail (modified for 11.5.10) */
11070: DELETE FROM OE_ORDER_LINES_HISTORY
11071: WHERE LINE_ID = p_line_id
11072: AND NVL(AUDIT_FLAG, 'Y') = 'Y'
11073: AND NVL(VERSION_FLAG, 'N') = 'N'
11074: AND NVL(PHASE_CHANGE_FLAG, 'N') = 'N';

Line 11076: UPDATE OE_ORDER_LINES_HISTORY

11072: AND NVL(AUDIT_FLAG, 'Y') = 'Y'
11073: AND NVL(VERSION_FLAG, 'N') = 'N'
11074: AND NVL(PHASE_CHANGE_FLAG, 'N') = 'N';
11075:
11076: UPDATE OE_ORDER_LINES_HISTORY
11077: SET AUDIT_FLAG = 'N'
11078: WHERE LINE_ID = p_line_id
11079: AND NVL(AUDIT_FLAG, 'Y') = 'Y'
11080: AND (NVL(VERSION_FLAG, 'N') = 'Y'