723: x_qty_rcv_exception_code,
724: x_item_id,
725: x_po_uom
726: FROM po_line_locations_all pll, --
727: po_lines_all pl --
729: AND pll.po_line_id = pl.po_line_id;
730:
731: x_progress := '010';
919: x_amount_cancelled,
920: x_qty_rcv_tolerance,
921: x_qty_rcv_exception_code
922: FROM po_line_locations_all pll, --
923: po_lines_all pl --
925: AND pll.po_line_id = pl.po_line_id;
926:
927: x_progress := '010';
2594: x_qty_received,
2595: x_qty_cancelled
2596: from po_distributions_all pod, --
2597: po_line_locations_all poll, --
2598: po_lines_all pol --
2600: and pod.po_distribution_id = p_po_distribution_id
2601: and pod.po_line_id = pol.po_line_id;
2602:
2748: x_amt_received,
2749: x_amt_cancelled
2750: from po_distributions_all pod, --
2751: po_line_locations_all poll, --
2752: po_lines_all pol --
2754: and pod.po_distribution_id = p_po_distribution_id
2755: and pod.po_line_id = pol.po_line_id;
2756:
3450: l_qty_received,
3451: l_qty_cancelled
3452: from po_distributions_all pod, --
3453: po_line_locations_all poll, --
3454: po_lines_all pol --
3456: and pod.po_distribution_id = p_distribution_id
3457: and pod.po_line_id = pol.po_line_id;
3458: