APPS.OE_LINE_UTIL dependencies on OE_LOT_SERIAL_NUMBERS

Line 15492: FROM oe_lot_serial_numbers

15488: l_overship_invoice_basis varchar2(30) := null; --bug# 6617423
15489:
15490: CURSOR C_LOT_SERIAL(p_serial_num VARCHAR2) IS
15491: SELECT line_id,line_set_id,from_serial_number,to_serial_number
15492: FROM oe_lot_serial_numbers
15493: WHERE from_serial_number = p_serial_num
15494: OR to_serial_number = p_serial_num;
15495: l_ref_line_id NUMBER;
15496:

Line 15528: -- If record exists in oe_lot_serial_numbers for the entered SN,

15524: IF p_line_rec.return_context = 'SERIAL' THEN
15525:
15526: FOR C2 IN C_LOT_SERIAL(p_line_rec.return_attribute2) LOOP
15527:
15528: -- If record exists in oe_lot_serial_numbers for the entered SN,
15529: -- check the line_set_id on it. There will be a value for line_set_id
15530: -- if the RMA line has got split. Get the reference line_id from the
15531: -- following queries.
15532: