Find Receipt Number

If you are given the PO number, how will you find out corresponding Receipt Nunber?

Questions by meerjasa

Showing Answers 1 - 1 of 1 Answers

select ph.segment1 ponum,
    rsh.reciept_num recieptnum
from po_headers_all ph,
    po_lines_all pl,
    po_line_locations_all pll,
    po_distributions_all pd,
    rcv_shipment_headers rsh,
    rcv_shipment_lines rsl
and    pl.po_line_id=pll.po_line_id
and    pll.line_location_id=pd.line_location_id
and    pd.distribution_id=rsl.po_distribution_id
and    rsh.header_id=rsl.header_id;

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions