APPS.OE_DEFAULT_LINE dependencies on OE_LOT_SERIAL_NUMBERS

Line 2852: FROM oe_lot_serial_numbers ls, oe_order_lines ol

2848: -- and removed it from query when cursor is opened.
2849:
2850: CURSOR C_LOT_SERIAL(p_serial_num VARCHAR2) IS
2851: SELECT ls.line_id,ls.line_set_id,ls.from_serial_number,ls.to_serial_number
2852: FROM oe_lot_serial_numbers ls, oe_order_lines ol
2853: WHERE ls.line_id = ol.line_id
2854: AND nvl(ol.cancelled_flag,'N') <> 'Y'
2855: AND (ls.from_serial_number = p_serial_num OR ls.to_serial_number = p_serial_num );
2856: /*

Line 2859: FROM oe_lot_serial_numbers

2855: AND (ls.from_serial_number = p_serial_num OR ls.to_serial_number = p_serial_num );
2856: /*
2857: CURSOR C_LOT_SERIAL(p_serial_num VARCHAR2) IS
2858: SELECT line_id,line_set_id,from_serial_number,to_serial_number
2859: FROM oe_lot_serial_numbers
2860: WHERE from_serial_number = p_serial_num
2861: OR to_serial_number = p_serial_num;
2862: */
2863: -- bug#5452691

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

3055: -- one or more referenced RMA exists.
3056:
3057: l_index2 := 1;
3058:
3059: -- Check the OE_LOT_SERIAL_NUMBERS table for the entered Serial Number.
3060:
3061: IF l_debug_level > 0 THEN
3062: oe_debug_pub.add( 'IN SERIAL5 ' ) ;
3063: END IF;

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

3062: oe_debug_pub.add( 'IN SERIAL5 ' ) ;
3063: END IF;
3064: FOR C2 IN C_LOT_SERIAL(p_return_attribute2) LOOP
3065:
3066: -- If record exists in oe_lot_serial_numbers for the entered SN,
3067: -- check the line_set_id on it. There will be a value for line_set_id
3068: -- if the RMA line has got split. Get the reference line_id from the
3069: -- following queries.
3070: