Oracle EBS-追蹤PO全過程

Oracle EBS:追蹤PO全過程

1。創(chuàng)建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收貨，則收貨數(shù)據(jù)將轉(zhuǎn)移至接收及庫存的表中

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

創(chuàng)作挑戰(zhàn)賽新人創(chuàng)作獎勵來咯，堅(jiān)持創(chuàng)作打卡瓜分現(xiàn)金大獎

總結(jié)

以上是生活随笔為你收集整理的oracle ebs po_header_all含税单价,Oracle EBS-追踪PO全过程的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。