748: x_qty_rcv_exception_code,
749: x_item_id,
750: x_po_uom
751: FROM po_line_locations_all pll, --
752: po_lines_all pl --
754: AND pll.po_line_id = pl.po_line_id;
755:
756: x_progress := '010';
1052: x_amount_cancelled,
1053: x_qty_rcv_tolerance,
1054: x_qty_rcv_exception_code
1055: FROM po_line_locations_all pll, --
1056: po_lines_all pl --
1058: AND pll.po_line_id = pl.po_line_id;
1059:
1060: x_progress := '010';
3170: x_qty_cancelled,
3171: l_po_line_location_id --
3172: from po_distributions_all pod, --
3173: po_line_locations_all poll, --
3174: po_lines_all pol --
3176: and pod.po_distribution_id = p_po_distribution_id
3177: and pod.po_line_id = pol.po_line_id;
3178:
3458: x_amt_cancelled,
3459: l_po_line_location_id --
3460: from po_distributions_all pod, --
3461: po_line_locations_all poll, --
3462: po_lines_all pol --
3464: and pod.po_distribution_id = p_po_distribution_id
3465: and pod.po_line_id = pol.po_line_id;
3466:
4302: l_qty_received,
4303: l_qty_cancelled
4304: from po_distributions_all pod, --
4305: po_line_locations_all poll, --
4306: po_lines_all pol --
4308: and pod.po_distribution_id = p_distribution_id
4309: and pod.po_line_id = pol.po_line_id;
4310: