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