APPS.OE_DEFAULT_LINE dependencies on OE_LOT_SERIAL_NUMBERS

Line 2971: FROM oe_lot_serial_numbers ls, oe_order_lines ol

2967: -- and removed it from query when cursor is opened.
2968:
2969: CURSOR C_LOT_SERIAL(p_serial_num VARCHAR2) IS
2970: SELECT ls.line_id,ls.line_set_id,ls.from_serial_number,ls.to_serial_number
2971: FROM oe_lot_serial_numbers ls, oe_order_lines ol
2972: WHERE ls.line_id = ol.line_id
2973: AND nvl(ol.cancelled_flag,'N') <> 'Y'
2974: AND (ls.from_serial_number = p_serial_num OR ls.to_serial_number = p_serial_num );
2975: /*

Line 2978: FROM oe_lot_serial_numbers

2974: AND (ls.from_serial_number = p_serial_num OR ls.to_serial_number = p_serial_num );
2975: /*
2976: CURSOR C_LOT_SERIAL(p_serial_num VARCHAR2) IS
2977: SELECT line_id,line_set_id,from_serial_number,to_serial_number
2978: FROM oe_lot_serial_numbers
2979: WHERE from_serial_number = p_serial_num
2980: OR to_serial_number = p_serial_num;
2981: */
2982: -- bug#5452691

Line 3178: -- Check the OE_LOT_SERIAL_NUMBERS table for the entered Serial Number.

3174: -- one or more referenced RMA exists.
3175:
3176: l_index2 := 1;
3177:
3178: -- Check the OE_LOT_SERIAL_NUMBERS table for the entered Serial Number.
3179:
3180: IF l_debug_level > 0 THEN
3181: oe_debug_pub.add( 'IN SERIAL5 ' ) ;
3182: END IF;

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

3181: oe_debug_pub.add( 'IN SERIAL5 ' ) ;
3182: END IF;
3183: FOR C2 IN C_LOT_SERIAL(p_return_attribute2) LOOP
3184:
3185: -- If record exists in oe_lot_serial_numbers for the entered SN,
3186: -- check the line_set_id on it. There will be a value for line_set_id
3187: -- if the RMA line has got split. Get the reference line_id from the
3188: -- following queries.
3189: