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_SECURITY dependencies on OE_ORDER_LINES

Line 1640: FROM OE_ORDER_LINES

1636:
1637: IF p_operation = OE_PC_GLOBALS.UPDATE_OP THEN
1638: SELECT Ordered_Quantity
1639: INTO l_old_qty
1640: FROM OE_ORDER_LINES
1641: WHERE line_id = p_record.line_id;
1642: END IF;
1643:
1644: -- Added for #2871055, frontporting 3329897

Line 1700: FROM OE_ORDER_LINES

1696:
1697: IF p_operation = OE_PC_GLOBALS.UPDATE_OP THEN
1698: SELECT Ordered_Quantity2
1699: INTO l_old_qty2
1700: FROM OE_ORDER_LINES
1701: WHERE line_id = p_record.line_id;
1702: END IF;
1703:
1704: -- CHECK CONSTRAINTS FOR CANCEL OPERATION IF QUANTITY IS REDUCED

Line 3155: FROM oe_order_lines

3151: -- use p_line_rec.service_ref_line_id to get flow_status_code of parent
3152: BEGIN
3153: SELECT flow_status_code
3154: INTO l_flow_status_code
3155: FROM oe_order_lines
3156: WHERE line_id = p_line_rec.service_reference_line_id;
3157: END;
3158:
3159: IF l_flow_status_code = 'CANCELLED' THEN