PO模块也有自己的接口表,多用于把其他业务系统在Oracle EBS系统生成采购订单记录。
下边是主要的三张PO接口表,用于记录订单头,行,Shipments以及Distributions信息
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_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. |
数据插入到接口表后,需要运行Concurrent Program:Import Standard Purchase Orders,用于把接口表导入到采购订单相关表。
Concurrent Program参数:
Default Buyer(Optional):