Query Accounts Payable Invoice Service
This service is in the WmOAFIN1227 package and has the following fully-qualified service name: payables1227.queryOA.APInvoice:queryAPInvoice.
This service queries for new or changed invoice records. You set up Accounts Payable Invoices in Oracle Applications Payables to record invoice-related information.
You can use the following parameters to query Accounts Payable Invoice data:
VENDOR_NAME INVOICE_NUM TERMS_NAME VENDOR_SITE_ADDRESS_LINE1 VENDOR_SITE_ADDRESS_LINE2 VENDOR_SITE_ADDRESS_LINE3 VENDOR_TOWN_OR_CITY VENDOR_COUNTY VENDOR_POSTAL_CODE VENDOR_STATE STATUS ORGANIZATION_NAME Database Scripts
This service uses the same database scripts as the Send Accounts Payable Invoice service.
Note:
If you use this service but you do not use the Send Accounts Payable Invoice service, you should run the wm_disable_from_apinvoice.sql script to disable the triggers installed by the Send Accounts Payable Invoice service.
For a detailed description of these database scripts, see
Send Accounts Payable Invoice Service. For more information about using database scripts, see
Database Scripts.
Supporting Transaction Definitions
This service uses the following transaction definition:
queryAPInvoiceTxn1227.txp
For information about using the transaction definition files to customize this service, see
Transaction Definitions.
Flow Control
The main flow executes as follows:
queryAPInvoiceTxn queries for any Accounts Payable Invoice information that matches 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 Accounts Payable Invoice service. For a detailed description of the business document structure, see
Send Accounts Payable Invoice Service.