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 1395: FROM OE_ORDER_LINES_ALL

1391: l_inv_interface_status_code,
1392: l_ordered_quantity,
1393: l_shipped_quantity,
1394: l_line_set_id
1395: FROM OE_ORDER_LINES_ALL
1396: WHERE line_id = p_rma_line_id;
1397:
1398: IF (l_open_flag = 'N' OR
1399: l_inv_interface_status_code IS NOT NULL OR

Line 1404: from oe_order_lines_all l,

1400: l_ordered_quantity = l_shipped_quantity) THEN
1401: /* this line is closed, or AR interfaced, or fully received */
1402: select l.ordered_quantity
1403: into x_quantity
1404: from oe_order_lines_all l,
1405: wf_item_activity_statuses wf,
1406: wf_process_activities wpa
1407: where l.open_flag = 'Y'
1408: and wpa.activity_item_type='OEOL'

Line 1463: from oe_order_lines_all

1459:
1460:
1461: Select SHIP_TOLERANCE_BELOW, SHIP_TOLERANCE_ABOVE
1462: into x_Under_Return_Tolerance,x_Over_Return_Tolerance
1463: from oe_order_lines_all
1464: Where line_id = p_RMA_Line_ID;
1465:
1466: EXCEPTION
1467: