Query Request For Quotation Service

Oracle Apps Adapter 6.0 | webMethods Oracle Applications Adapter Documentation | webMethods Oracle Applications Adapter 12.2.7 Predefined Transaction Services Documentation | Procurement Predefined Transaction Services | Query Request For Quotation Service

This service is in the WmOAPRC1227 package and has the following fully-qualified service name: purchasing1227.queryOA.RFQ:queryRFQ.

This service retrieves all new and changed active Request For Quotation (RFQ) data. Because RFQs cannot be deleted, the document status of DELETE does not apply in this case.

You can use the following parameters to query RFQs:

RFQ_NUMBER

RFQ_STATUS

BUYER_NAME

DUE_DATE_FROM

DUE_DATE_TO

CLOSE_DATE_FROM

CLOSE_DATE_TO

EFFECTIVE_DATE_FROM

EFFECTIVE_DATE_TO

ITEM_NUMBER

SUPPLIER_NAME

SUPPLIER_ADDRESS_LINE1, SUPPLIER_ADDRESS_LINE2, SUPPLIER_ADDRESS_LINE3

SUPPLIER_CITY

SUPPLIER_STATE

SUPPLIER_COUNTRY

SUPPLIER_ZIP

Database Scripts

This service uses the same database scripts as the Send Request For Quotation service.

Note:
If you use this service but you do not use the Send Request For Quotation service, you should run the wm_disable_from_rfq.sql script to disable the triggers installed by the Send Request For Quotation service.

For a detailed description of these database scripts, see Send Request For Quotation Service. For more information about using database scripts, see Database Scripts.

Supporting Transaction Definitions

This service uses the following transaction definition:

queryRFQTxn1227.txp

For information about using the transaction definition files to customize this service, see Transaction Definitions.

Flow Control

The main flow queryRFQ executes as follows:

specifyDefaultSettings specifies the default parameter settings required for service execution. You should change these settings accordingly.

queryRFQTxn queries the Oracle Applications database for any RFQ information 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 Request For Quotation service. For a detailed description of the business document’s structure, see Send Request For Quotation Service.