APPS.PO_SHIPMENTS_SV10 dependencies on PO_DISTRIBUTIONS

Line 292: from po_distributions pod

288: IF X_shipment_type NOT IN ('BLANKET','SCHEDULED') THEN
289: if X_line_location_id is not null then
290: select nvl(sum(quantity_ordered),0),nvl(sum(quantity_ordered),0)
291: into X_total, X_total_rtot_db
292: from po_distributions pod
293: where pod.line_location_id = X_line_location_id;
294: else
295: X_total := 0;
296: X_total_rtot_db := 0;

Line 377: FROM po_distributions

373: INTO x_prevent_price_update_flag
374: FROM DUAL
375: WHERE EXISTS
376: (SELECT 'prevent price udpate'
377: FROM po_distributions
378: WHERE line_location_id = x_line_location_id
379: AND
380: (
381: (