Oracle Apps Adapter 6.0 | webMethods Oracle Applications Adapter Documentation | webMethods Oracle Applications Adapter 12.2.7 Predefined Transaction Services Documentation | Order Management Predefined Transaction Services | Query Sales Order Service
 
Query Sales Order Service
This service is in the WmOAOMG1227 package and has the following fully-qualified service name: orderManagement1227.queryOA.salesOrder:querySalesOrder.
This service queries for new, changed, and deleted booked sales orders. You can use the following parameters to query sales orders:
*CUSTOMER_NAME
*ORDER_NUMBER.
*ORDER_TYPE
*ORGANIZATION_NAME
*SHIP_TO_ADDRESS (1-4)
*SHIP_TO_CITY
*SHIP_TO_COUNTY
*SHIP_TO_POSTAL_CODE
*SHIP_TO_PROVINCE
*SHIP_TO_COUNTRY
*INVOICE_ADDRESS (1-4)
*INVOICE_CITY
*INVOICE_COUNTY
*INVOICE_POSTAL_CODE
*INVOICE_PROVINCE_INT
*INVOICE_COUNTRY
*PRICE_LIST
Database Scripts
This service uses the same database script as the Send Sales Order service.
Note:
If you use this service but you do not use the Send Sales Order service, you should run the wm_disable_from_salesorder.sql script to disable the triggers installed by the Send Sales Order service.
For a detailed description of these database scripts, see Send Sales Order Service . For more information about using database scripts, see Database Scripts.
Supporting Transaction Definitions
This service uses the following transaction definition:
*querySalesOrderTxn1227.txp
Flow Control
The main flow executes as follows:
*querySalesOrderTxn: queries Sales Order information matching the parameter values. The parameters are defined as the input to this service.
For more details on query services, see Using Query Services.
Business Document Structure
This service uses the same business document structure as the Send Sales Order service. For a detailed description of the business document structure, see Send Sales Order Service.