92: IF l_temp_count = 0 THEN
93:
94: --API BODY
95:
96: --Get the line id from oe_order_lines_all
97: --Logic Used
98: --1) Normal Case
99: -- split_from_line_id is null in oe_order_lines_all
100: -- use line_id to join to oe_lot_serial_numbers.
95:
96: --Get the line id from oe_order_lines_all
97: --Logic Used
98: --1) Normal Case
99: -- split_from_line_id is null in oe_order_lines_all
100: -- use line_id to join to oe_lot_serial_numbers.
101: --2) Split Case
102: -- split_from_line_id is not null in oe_order_lines_all
103: -- get line_set_id from oe_order_lines_all to join to
98: --1) Normal Case
99: -- split_from_line_id is null in oe_order_lines_all
100: -- use line_id to join to oe_lot_serial_numbers.
101: --2) Split Case
102: -- split_from_line_id is not null in oe_order_lines_all
103: -- get line_set_id from oe_order_lines_all to join to
104: -- oe_lot_serial_numbers.
105:
106: /* Commented the below code and added the new select statement to get
99: -- split_from_line_id is null in oe_order_lines_all
100: -- use line_id to join to oe_lot_serial_numbers.
101: --2) Split Case
102: -- split_from_line_id is not null in oe_order_lines_all
103: -- get line_set_id from oe_order_lines_all to join to
104: -- oe_lot_serial_numbers.
105:
106: /* Commented the below code and added the new select statement to get
107: * correct value in l_orig_line_id i.e to get always line_id of parent RMA line
108: * from which subsequent lines got split. For bug 5144099 */
109: /*
110: SELECT split_from_line_id, line_set_id
111: INTO l_split_from_line_id, l_line_set_id
112: FROM oe_order_lines_all
113: WHERE line_id = p_rma_line_id;
114:
115: IF l_split_from_line_id IS NULL THEN
116:
125: */
126:
127: SELECT min(line_id)
128: INTO l_orig_line_id
129: FROM oe_order_lines_all
130: START WITH line_id = p_rma_line_id
131: CONNECT BY PRIOR split_from_line_id = line_id;
132:
133: /* End of fix for bug 5144099*/