3168: x_qty_ordered,
3169: x_qty_received,
3170: x_qty_cancelled,
3171: l_po_line_location_id --
3172: from po_distributions_all pod, --
3174: po_lines_all pol --
3175: where pod.line_location_id = poll.line_location_id
3176: and pod.po_distribution_id = p_po_distribution_id
3456: x_amt_ordered,
3457: x_amt_received,
3458: x_amt_cancelled,
3459: l_po_line_location_id --
3460: from po_distributions_all pod, --
3462: po_lines_all pol --
3463: where pod.line_location_id = poll.line_location_id
3464: and pod.po_distribution_id = p_po_distribution_id
4300: l_qty_rcv_tolerance,
4301: l_qty_ordered,
4302: l_qty_received,
4303: l_qty_cancelled
4304: from po_distributions_all pod, --
4306: po_lines_all pol --
4307: where pod.line_location_id = poll.line_location_id
4308: and pod.po_distribution_id = p_distribution_id