Purchase Document Open Interface(PDOI)

PO模块也有自己的接口表，多用于把其他业务系统在Oracle EBS系统生成采购订单记录。

Table Name	Description	Type
PO_HEADERS_INTERFACE	This is the table where to insert PO headers data in interface table.	Interface table
PO_LINES_INTERFACE	This is where we insert PO lines information to be imported ( it is used also for Shipments details )	Interface table
PO_DISTRIBUTIONS_INTERFACE	This is where we insert PO distribution details before import	Interface table
PO_INTERFACE_ERRORS	Stores all errors resulted from import process.	Errors table
PO_HEADERS_ALL	Stores document headers for purchase orders, purchase agreements,quotations, and RFQs	PO Base table
PO_LINES_ALL	Stores purchase document lines for purchase orders, purchase agreements, quotations, and RFQs	PO Base table
PO_LINE_LOCATIONS_ALL	Stores document shipment schedules for purchase orders, purchase agreements, quotations, and RFQs	PO Base table
PO_DISTRIBUTIONS_ALL	Stores purchase order distributions	PO Base table

下边是主要的三张PO接口表，用于记录订单头，行，Shipments以及Distributions信息

•     PO_HEADERS_INTERFACE
•     PO_LINES_INTERFACE
•     PO_DISTRIBUTIONS_INTERFACE

接口表的查询语句

• Select * from PO_HEADERS_INTERFACE where INTERFACE_HEADER_ID=&headerid;
• Select * from PO_LINES_INTERFACE where INTERFACE_HEADER_ID=&headerid;
• Select * from PO_DISTRIBUTIONS_INTERFACE where INTERFACE_HEADER_ID=&headerid;

R12还引入了另外一张Interface表，PO_LINE_LOCATIONS_INTERFACE，这张表其实暂时还用不到，还只是Oracle标准产品内部使用，但因为名称上很容易让人误解，所以这里提一下。

Table Name	Feature Area
PO_LINE_LOCATIONS_INTERFACE	This table is intended for internal use only. This is the interface table for price breaks and standard PO shipments. You should not populate these tables rather PO_LINES_INTERFACE as before. PDOI internally pushes records to this interface table for processing.

数据插入到接口表后，需要运行Concurrent Program:Import Standard Purchase Orders，用于把接口表导入到采购订单相关表。

Concurrent Program参数：