oracle ebs po_header_all含税单价,Oracle EBS-追踪PO全过程

Oracle EBS-追踪PO全过程

Oracle EBS:追踪PO全过程

1。创建PO

PO_HEADERS_ALL

select po_header_id from po_headers_all where segment1 = ;

select * from po_headers_all where po_header_id = ;

po_lines_all

select * from po_lines_all where po_header_id = ;

po_line_locations_all

select * from po_line_locations_all where po_header_id = ;

po_distributions_all

select * from po_distributions_all where po_header_id = ;

po_releases_all

Select * FROM po_releases_all Where po_header_id = ;

2.一旦PO收货，则收货数据将转移至接收及库存的表中

RCV_SHIPMENT_HEADERS

select * from rcv_shipment_headers where shipment_header_id in

(select shipment_header_id from rcv_shipment_lines

where po_header_id = );

RCV_SHIPMENT_LINES

select * from rcv_shipment_lines where po_header_id = ;

RCV_TRANSACTIONS

select * from rcv_transactions where po_header_id = ;

RCV_ACCOUNTING_EVENTS

创作挑战赛新人创作奖励来咯，坚持创作打卡瓜分现金大奖

总结

以上是生活随笔为你收集整理的oracle ebs po_header_all含税单价,Oracle EBS-追踪PO全过程的全部内容，希望文章能够帮你解决所遇到的问题。

如果觉得生活随笔网站内容还不错，欢迎将生活随笔推荐给好友。