/* Formatted on 2006/05/08 16:21 (Formatter Plus v
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博客 ” ，链接：https://blog.itpub.net/226700/viewspace-833513/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
