Hi [:)],
<font color="red"><u><b>Open Interfaces in Purchasing</b></u></font id="red">
In Purchasing we have the following Open Interfaces/API(s).
<font color="red"><b>1.Requisitions Open Interface:</b></font id="red">
With this open interface you can automatically import from other Oracle Applications or your existing non Oracle Systems.
Tables in this interface are as follows:
(i)PO_REQUISITIONS_INTERFACE_ALL
(ii)PO_REQ_DIST_INTERFACE_ALL
etc.,
<font color="red"><b>2.Purchasing Documents Open Interface</b></font id="red">
With this interface you can automatically import and update price/sales catalog information and request for quotation (RFQ) responses from suppliers.You can also import standard purchase orders (for example, from a legacy system) through the Purchasing Documents Open Interface.
Tables in this interface are as follows:
(i)PO_HEADERS_INTERFACE
(ii)PO_LINES_INTERFACE
(iii)PO_DISTRIBUTIONS_INTERFACE
(iv)PO_PRICE_DIFF_INTERFACE
<font color="red"><b>3.Receiving Open Interface</b></font id="red">
With this interface we can process and validate receipt data that
comes from sources other than the Receipts window in Purchasing.
Tables in this interface are as follows:
(i)RCV_HEADERS_INTERFACE
(ii)RCV_TRANSACTIONS_INTERFACE
In addition to this we have got various other API's by which we can apply changes to standard purchase orders , Cancel the PO's ,Custom Pricing on PO's etc.
<font color="blue"><b>Best Regards[:)],
Arun Reddy.
E-Mail:
arunapps@gmail.com</b></font id="blue">