APPS.PO_DIST_S dependencies on PO_DISTRIBUTIONS

Line 26: FROM po_distributions POD

22: X_total_quantity IN OUT NOCOPY NUMBER) IS
23: X_progress varchar2(3) := '';
24: CURSOR C is
25: SELECT sum(POD.quantity_ordered)
26: FROM po_distributions POD
27: WHERE POD.po_distribution_id = X_po_line_location_id;
28: BEGIN
29: -- dbms_output.put_line('Before open cursor');
30: if (X_po_line_location_id is not null) then

Line 67: FROM po_distributions POD

63: X_max_distribution_id NUMBER := '';
64: BEGIN
65: SELECT max(POD.po_distribution_id)
66: INTO X_max_distribution_id
67: FROM po_distributions POD
68: WHERE POD.line_location_id = X_po_line_location_id;
69: IF (X_max_distribution_id is null) THEN
70: -- dbms_output.put_line('returned false');
71: return(FALSE);

Line 159: FROM po_distributions

155:
156: X_temp_recovery_rate,
157: X_temp_distribution_num,
158: X_temp_dest_subinventory
159: FROM po_distributions
160: WHERE po_distribution_id = X_distribution_id;
161:
162: -- Bug 5409088: Added check for amount ordered
163: IF ((X_temp_quantity_ordered <> X_quantity_ordered )