APPS.WSH_SC_DEL_LINES dependencies on SO_LINE_DETAILS

Line 69: UPDATE so_line_details

65: end;
66:
67: PROCEDURE update_unrel_lines(del_id number) is
68: begin
69: UPDATE so_line_details
70: SET released_flag = 'N'
71: WHERE line_detail_id IN
72: ( SELECT ld.line_detail_id
73: FROM so_line_details ld, so_lines_all l

Line 73: FROM so_line_details ld, so_lines_all l

69: UPDATE so_line_details
70: SET released_flag = 'N'
71: WHERE line_detail_id IN
72: ( SELECT ld.line_detail_id
73: FROM so_line_details ld, so_lines_all l
74: WHERE ld.delivery_id = del_id
75: AND l.ato_line_id is NULL
76: AND ld.configuration_item_flag is NULL
77: AND l.ato_flag = 'Y'

Line 84: UPDATE so_line_details

80: AND ld.shippable_flag = 'N'
81: AND l.line_id = ld.line_id);
82:
83:
84: UPDATE so_line_details
85: SET delivery_id = NULL,
86: departure_id = NULL,
87: dpw_assigned_flag = 'N'
88: WHERE line_detail_id IN

Line 90: FROM so_line_details ld, so_lines_all l

86: departure_id = NULL,
87: dpw_assigned_flag = 'N'
88: WHERE line_detail_id IN
89: ( SELECT ld.line_detail_id
90: FROM so_line_details ld, so_lines_all l
91: WHERE ld.delivery_id = del_id
92: AND ld.released_flag = 'N'
93: AND l.line_id = ld.line_id);
94: