DBA Data[Home] [Help]

APPS.OE_SERVICES_PROCESS dependencies on SO_LINES

Line 112: FROM so_lines

108: FUNCTION Next_Order_Line_Number(X_Service_Parent_Line_Id NUMBER) Return NUMBER IS
109: Line_Num NUMBER;
110: CURSOR C_Next_Line_Number(X_Service_Parent_Line_Id NUMBER) IS
111: SELECT Nvl(Max(line_number), 0) + 1
112: FROM so_lines
113: WHERE service_parent_line_id = X_Service_Parent_Line_Id ;
114: begin
115: OPEN C_Next_Line_Number(X_Service_Parent_Line_Id);
116: FETCH C_Next_Line_Number INTO Line_Num;