今天做采购接收导入的时候发现了个问题
从交货入库退货
接收:会有两步,并产生两条记录,一条接收,一条入库
退货:会有两步,并产生两条记录,一条从库存退货至接收,一条从接收退货至供应商
后台数据:退货后库存现有相应量减少
rcv_transactions_interface.parent_transaction_id 的值取接收事务处理的id,即取数如下
SELECT rt.transaction_id,
rt.shipment_header_id,
rt.shipment_line_id
INTO v_transaction_id, v_ship_id, v_ship_line_id
FROM rcv_transactions rt
WHERE rt.transaction_type = 'DELIVER'
AND rt.po_header_id = v_po_header_id
AND rt.po_line_id = v_po_line_id
AND rt.po_line_location_id = v_line_location_id
AND rt.po_distribution_id = v_po_distribution_id;
接收数据