Query Vendor Service
This service is in the WmOAFIN1227 package and has the following fully-qualified service name: payables1227.queryOA.vendor:queryVendor.
This service queries for new or changed Vendors.
You set up Vendors (also known as Suppliers) in Oracle Applications Payables and Oracle Applications Purchasing to record information about individuals and companies from which you purchase goods and services.
You can use the following parameters to query Vendor data:
VENDOR_NUMBER: Unique identifier for a customer.
TAXPAYER_ID: Vendor Tax payer ID.
INACTIVE_DATE_FROM: Beginning date the vendor is inactive.
INACTIVE_DATE_TO: Ending date the vendor is inactive.
TAX_REGISTRATION_NUMBER: Tax Registration Number.
VENDOR_SITE_CODE: Unique Site identifier for a vendor.
Database Scripts
This service uses the same database scripts as the Send Vendor service.
Note:
If you use this service but you do not use the Send Vendor service, you should run the wm_disable_from_vendor.sql script to disable the triggers installed by the Send Vendor service.
For a detailed description of these database scripts, see
Send Vendor Service. For more information about using database scripts, see
Database Scripts.
Supporting Transaction Definitions
This service uses the following transaction definition:
queryVendorTxn1227.txp
For information about using the transaction definition files to customize this service, see
Transaction Definitions.
Flow Control
The main flow executes as follows:
specifyDefaultSettings specifies the default parameter settings required for service execution. You should change these settings accordingly.
queryVendorTxn queries the Oracle Applications database for any Vendor 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 Vendor service. For a detailed description of the business document structure, see
Send Vendor Service.