通过发票号码找PO号:

/* Formatted on 2006/05/08 16:21 (Formatter Plus v4.8.7) */

SELECT rt.quantity, poh.segment1

FROM po_headers_all poh,

po_lines_all pol,

po_line_locations_all poll,

rcv_shipment_lines rcvl,

rcv_transactions rt

WHERE poh.po_header_id = pol.po_header_id

AND pol.po_line_id = poll.po_line_id

AND poll.line_location_id = rcvl.po_line_location_id

AND rcvl.shipment_line_id = rt.shipment_line_id

AND rt.attribute1 = '01260731'

-- rcv_transactions. attribute1 is invoice.NO

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/226700/viewspace-833513/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/226700/viewspace-833513/