采购单和接收事务处理相关的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.line_num,
msi.segment1 as item_num,
msi.description,
rt.*
from rcv_transactions rt,
rcv_shipment_headers rsh,
po_headers_all pha,
po_lines_all pla,
mtl_system_items_b msi
where rt.shipment_header_id = rsh.shipment_header_id
and rt.po_header_id = pha.po_header_id
and rt.po_line_id = pla.po_line_id
and pla.org_id = msi.organization_id
and pla.item_id = msi.inventory_item_id
and pha.segment1 = '9857'
order by rt.creation_date;

select *
from rcv_supply rs
where 1=1
--and rs.rcv_transaction_id = 252514
and rs.shipment_line_id = 134176

最后

以上就是靓丽帽子为你收集整理的采购单和接收事务处理相关的SQL的全部内容，希望文章能够帮你解决采购单和接收事务处理相关的SQL所遇到的程序开发问题。

如果觉得靠谱客网站的内容还不错，欢迎将靠谱客网站推荐给程序员好友。