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 1726: FROM OE_ORDER_LINES

1722:
1723: IF p_operation = OE_PC_GLOBALS.UPDATE_OP THEN
1724: SELECT Ordered_Quantity
1725: INTO l_old_qty
1726: FROM OE_ORDER_LINES
1727: WHERE line_id = p_record.line_id;
1728: END IF;
1729:
1730: -- Added for #2871055, frontporting 3329897

Line 1786: FROM OE_ORDER_LINES

1782:
1783: IF p_operation = OE_PC_GLOBALS.UPDATE_OP THEN
1784: SELECT Ordered_Quantity2
1785: INTO l_old_qty2
1786: FROM OE_ORDER_LINES
1787: WHERE line_id = p_record.line_id;
1788: END IF;
1789:
1790: -- CHECK CONSTRAINTS FOR CANCEL OPERATION IF QUANTITY IS REDUCED

Line 3327: FROM oe_order_lines

3323: -- use p_line_rec.service_ref_line_id to get flow_status_code of parent
3324: BEGIN
3325: SELECT flow_status_code
3326: INTO l_flow_status_code
3327: FROM oe_order_lines
3328: WHERE line_id = p_line_rec.service_reference_line_id;
3329: END;
3330:
3331: IF l_flow_status_code = 'CANCELLED' THEN