364: ordered_po_qty,
365: cancelled_po_qty,
366: billed_txn_qty
367: FROM
368: po_distributions pod,
369: rcv_transactions rt
370: WHERE
371: rt.transaction_id = top_transaction_id and
372: rt.po_distribution_id = pod.po_distribution_id;
617: INTO
618: ordered_po_qty,
619: cancelled_po_qty
620: FROM
621: po_distributions pd
622: WHERE
623: pd.po_distribution_id = p_distribution_id;
624:
625: /* Get UOM conversion rates */