saikiran.patnaik

 Profile Answers by saikiran.patnaik 

• Jan 10th, 2011

 

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
where
    ph.po_header_id=pl.po_header_id
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;