Query Accounts Payable Payment Service
This service is in the WmOAFIN1227 package and has the following fully-qualified service name: payables1227.queryOA.APPayment:queryAPPayment.
This service queries Accounts Payable payments. You set up Accounts Payable Payments in Oracle Applications Payables to record payment related information.
You can use the following parameters for querying Accounts Payable Payment data:
ORGANIZATION_NAME CURRENT_BANK_ACCOUNT_NAME PAYMENT_TYPE VENDOR_NAME INVOICE_NUM Database Scripts
This service uses the same database scripts as the Send Accounts Payable Payment service.
Note:
If you use this service but you do not use the Send Accounts Payable Payment service, you should run the wm_disable_from_appayment.sql script to disable the triggers installed by the Send Accounts Payable Payment service.
For a detailed description of these database scripts, see
Send Accounts Payable Payment Service. For more information about using database scripts, see
Database Scripts.
Supporting Transaction Definitions
This service uses the following transaction definition:
queryAPPaymentTxn1227.txp
For information about using the transaction definition files to customize this service, see
Transaction Definitions.
Flow Control
The main flow executes as follows:
queryAPPaymentTxn queries for any Accounts Payable Payment information matching the parameter values. The parameters are 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 Payment service. For a detailed description of the business document structure, see
Send Accounts Payable Payment Service.