Query Supplier Service
This service is in the WmOAPRC1227 package and has the following fully-qualified service name: purchasing1227.queryOA.supplier:querySupplier.
This service retrieves new or changed active supplier data. It extracts information for a supplier only, and not for individual employees who are also set up as suppliers. Because suppliers cannot be deleted, the document status of DELETE does not apply in this case.
You can use the following parameters to query supplier data:
SUPPLIER_NUMBER: Unique supplier identifier in Oracle Applications that is assigned to the supplier upon creation.
SUPPLIER_SITE_CODE: Unique site identifier for a supplier. The same site name can exist for multiple suppliers.
INACTIVE_DATE_FROM: Beginning date when the supplier is inactive.
INACTIVE_DATE_TO: Ending date when the supplier is inactive.
TAXPAYER_ID: Supplier taxpayer ID.
TAX_REGISTRATION_NUMBER: Tax registration number.
Database Scripts
This service uses the same database scripts as the Send Supplier service.
Note:
If you use this service but you do not use the Send Supplier service, you should run the wm_disable_from_supplier.sql script to disable the triggers installed by the Send Supplier service.
For a detailed description of these database scripts, see
Send Supplier Service. For more information about using database scripts, see
Database Scripts.
Supporting Transaction Definitions
This service uses the following transaction definition:
querySupplierTxn1227.txp
For information about using the transaction definition files to customize this service, see
Transaction Definitions.
Flow Control
The main flow querySupplier executes as follows:
specifyDefaultSettings specifies the default parameter settings required for service execution. You should change these settings accordingly.
querySupplierTxn queries the Oracle Applications database for any supplier matching the parameter values. The parameters are defined as the input to this service.
For more details on query transactions, see
Using Query Services.
Business Document Structure
This service uses the same business document structure as the Send Supplier service. For a detailed description of the business document’s structure, see
Send Supplier Service.