APPS.PO_SHIPMENTS_SV5 SQL Statements

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

Line: 61

	       SELECT quantity
	       INTO   X_planned_qty_ordered
	       FROM   po_lines
	       WHERE  po_line_id = X_po_line_id;

Line: 66

	       SELECT sum(quantity - nvl(quantity_cancelled,0))
	       INTO   X_quantity_released
	       FROM   po_line_locations
	       WHERE  po_line_id = X_po_line_id
	       AND    shipment_type = 'SCHEDULED';

Line: 84

               SELECT nvl(sum(nvl(quantity,0) - nvl(quantity_cancelled, 0)),0)
               INTO   X_total_line_quantity
               FROM   po_line_locations
               WHERE  po_line_id    = X_po_line_id
               AND    shipment_type = 'SCHEDULED';

Line: 95

               SELECT sum(quantity - nvl(quantity_cancelled, 0))
               INTO   X_total_line_quantity
               FROM   po_line_locations
               WHERE  po_line_id = X_po_line_id
               AND    shipment_type <> 'PRICE BREAK';

Line: 108

             SELECT line_type,
                    nvl(outside_operation_flag,'N'),
                    receiving_flag,
					receipt_close
             INTO   X_line_type,
                    X_outside_operation_flag,
                    X_receipt_required_flag_temp,
					X_receipt_close_tolerance_tmp
	     FROM   po_line_types_v
             WHERE  line_type_id = X_line_type_id;