Oracle Apps Adapter 6.0 | webMethods Oracle Applications Adapter Documentation | webMethods Oracle Applications Adapter Sample Transaction Definitions User’s Guide Documentation | Transaction Definitions (Oracle Applications 10.7SC-to-IS) | PurchaseOrderChange
 
PurchaseOrderChange
Use his transaction to retrieve revised purchase orders. You can retrieve new purchase orders by the creation date range, supplier, vendor, PO type, and PO number range. This transaction only retrieves Purchase Orders that fit the above criteria and have already been printed or marked as processed. The acknowledgment SQL marks the specified PO so that it will not be retrieved by the functional query a second time.
Functional Query
Inputs
Same as for the PurchaseOrderNew transaction.
Outputs
Same as for the PurchaseOrderNew transaction, except for the differences noted below.
Header Details
Does not have a TRANSACTION_DATE field.
Line Details
Does not have an ORG_ID field.
Shipment Details
Does not have an ORG_ID field. Contains a QUANTITY_PENDING field.
Acknowledgment SQL
Same as for the PurchaseOrderNew transaction.
Inputs
Same as for the PurchaseOrderNew transaction.
Outputs
Same as for the PurchaseOrderNew transaction.
Usage Comments
*Purchase Orders that have been approved and previously printed are retrieved.
*You can retrieve only BLANKET and STANDARD Purchase Orders Types. To retrieve a STANDARD purchase order, specify a DOCUMENT_TYPE of STANDARD. To retrieve the purchase agreements, specify a DOCUMENT_TYPE of BLANKET. To retrieve releases against a purchase agreement, specify a DOCUMENT_TYPE of RELEASE.