APPS.WSH_SC_DEL_LINES_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 40

      SELECT REQUESTED_QUANTITY
      FROM so_picking_line_details
      WHERE picking_line_detail_id = pld_id;

Line: 77

      UPDATE so_picking_line_details
      SET delivery_id = NULL,
          departure_id = NULL,
          shipped_quantity = NULL,
	  dpw_assigned_flag = 'N',
          load_seq_number = NULL
  --	  transaction_temp_id = NULL
      WHERE picking_line_detail_id = pld_id;

Line: 86

      DELETE FROM so_freight_charges
      WHERE delivery_id = del_id
      AND picking_line_detail_id = pld_id;

Line: 136

     	  SELECT nvl(destination_type_code,'@'),source_organization_id,
           destination_organization_id
	  INTO X_Dest_Type,X_From_Org,X_To_Org
    	  FROM   po_requisition_lines_all pl,po_requisition_headers_all ph,
           po_req_distributions_all pd,so_lines_all sol,so_headers_all soh,
	   so_picking_lines_all pkl,so_picking_headers_all pkh
    	  WHERE pl.line_num = to_number(sol.original_system_line_reference)
    	  AND pl.requisition_header_id = ph.requisition_header_id
    	  AND pd.requisition_line_id = pl.requisition_line_id
    	  AND ph.segment1 = soh.original_system_reference
     	  AND soh.header_id = pkh.order_header_id
    	  AND sol.line_id = pkl.order_line_id
    	  AND pkh.picking_header_id = X_Pk_Hdr_Id
    	  AND pkl.picking_line_id = X_Pk_Line_Id;