DBA Data[Home] [Help]

APPS.WSH_SC_DEL_LINES dependencies on SO_LINES_ALL

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 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: