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_RMA_RECEIVING dependencies on OE_ORDER_LINES_ALL

Line 1286: FROM OE_ORDER_LINES_ALL

1282: l_inv_interface_status_code,
1283: l_ordered_quantity,
1284: l_shipped_quantity,
1285: l_line_set_id
1286: FROM OE_ORDER_LINES_ALL
1287: WHERE line_id = p_rma_line_id;
1288:
1289: IF (l_open_flag = 'N' OR
1290: l_inv_interface_status_code IS NOT NULL OR

Line 1295: from oe_order_lines_all l,

1291: l_ordered_quantity = l_shipped_quantity) THEN
1292: /* this line is closed, or AR interfaced, or fully received */
1293: select l.ordered_quantity
1294: into x_quantity
1295: from oe_order_lines_all l,
1296: wf_item_activity_statuses wf,
1297: wf_process_activities wpa
1298: where l.open_flag = 'Y'
1299: and wpa.activity_item_type='OEOL'

Line 1354: from oe_order_lines_all

1350:
1351:
1352: Select SHIP_TOLERANCE_BELOW, SHIP_TOLERANCE_ABOVE
1353: into x_Under_Return_Tolerance,x_Over_Return_Tolerance
1354: from oe_order_lines_all
1355: Where line_id = p_RMA_Line_ID;
1356:
1357: EXCEPTION
1358: