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 9588: DELETE FROM OE_ORDER_LINES_HISTORY

9584:
9585: END LOOP; -- all the lines in a header.
9586:
9587: /* Start Audit Trail */
9588: DELETE FROM OE_ORDER_LINES_HISTORY
9589: WHERE HEADER_ID = p_header_id;
9590: /* End Audit Trail */
9591:
9592: DELETE FROM OE_ORDER_LINES

Line 9803: DELETE FROM OE_ORDER_LINES_HISTORY

9799:
9800: END IF; -- if service lines exist
9801:
9802: /* Start Audit Trail (modified for 11.5.10) */
9803: DELETE FROM OE_ORDER_LINES_HISTORY
9804: WHERE LINE_ID = p_line_id
9805: AND NVL(AUDIT_FLAG, 'Y') = 'Y'
9806: AND NVL(VERSION_FLAG, 'N') = 'N'
9807: AND NVL(PHASE_CHANGE_FLAG, 'N') = 'N';

Line 9809: UPDATE OE_ORDER_LINES_HISTORY

9805: AND NVL(AUDIT_FLAG, 'Y') = 'Y'
9806: AND NVL(VERSION_FLAG, 'N') = 'N'
9807: AND NVL(PHASE_CHANGE_FLAG, 'N') = 'N';
9808:
9809: UPDATE OE_ORDER_LINES_HISTORY
9810: SET AUDIT_FLAG = 'N'
9811: WHERE LINE_ID = p_line_id
9812: AND NVL(AUDIT_FLAG, 'Y') = 'Y'
9813: AND (NVL(VERSION_FLAG, 'N') = 'Y'