APPS.OE_LINE_UTIL dependencies on OE_LOT_SERIAL_NUMBERS

Line 16936: FROM oe_lot_serial_numbers

16932: l_overship_invoice_basis varchar2(30) := null; --bug# 6617423
16933:
16934: CURSOR C_LOT_SERIAL(p_serial_num VARCHAR2) IS
16935: SELECT line_id,line_set_id,from_serial_number,to_serial_number
16936: FROM oe_lot_serial_numbers
16937: WHERE from_serial_number = p_serial_num
16938: OR to_serial_number = p_serial_num;
16939: l_ref_line_id NUMBER;
16940:

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

16968: IF p_line_rec.return_context = 'SERIAL' THEN
16969:
16970: FOR C2 IN C_LOT_SERIAL(p_line_rec.return_attribute2) LOOP
16971:
16972: -- If record exists in oe_lot_serial_numbers for the entered SN,
16973: -- check the line_set_id on it. There will be a value for line_set_id
16974: -- if the RMA line has got split. Get the reference line_id from the
16975: -- following queries.
16976: