采购单和接收事务处理相关的SQL
从采购单查看RCV_TRANSACTION表,只需用po_headers_all.po_header_id和po_lines_all.po_line_id(其实只用po_line_id就可以的了……)进行连接。select rsh.receipt_num, rt.transaction_type, pha.segment1 as po_num, pla