APPS.WSH_UPGRADE_PICK_SLIP_DATA_NEW dependencies on SO_PICKING_LINE_DETAILS

Line 677: UPDATE SO_PICKING_LINE_DETAILS

673: UPDATE SO_PICKING_HEADERS_ALL PH
674: SET PH.delivery_id = u_delivery_id
675: WHERE PH.picking_header_id = u_picking_header_id;
676:
677: UPDATE SO_PICKING_LINE_DETAILS
678: SET delivery_id = u_delivery_id,
679: departure_id = u_departure_id,
680: dpw_assigned_flag = NULL
681: WHERE picking_line_detail_id IN

Line 684: so_picking_line_details pld,

680: dpw_assigned_flag = NULL
681: WHERE picking_line_detail_id IN
682: ( SELECT pld.picking_line_detail_id
683: FROM
684: so_picking_line_details pld,
685: so_picking_lines_all pl
686: WHERE pl.picking_header_id = u_picking_header_id
687: AND pld.picking_line_id = pl.picking_line_id );
688: END IF;