Query Engineering BOM Service
This service is in the WmOAMFG1227 package and has the following fully-qualified service name: engineering1227.queryOA.engineeringBOM:queryEngineeringBOM.
This service retrieves information on the parent, component, and substitute Engineering Bills of Material items, as well as revisions. It retrieves this information based on the following parameters:
ORGANIZATION_NAME: Organization Name.
ITEM_NUMBER: Item Number.
UNIT_OF_MEASURE: Unit of Measure.
EFFECTIVITY_DATE_FROM: Effective Date.
EFFECTIVITY_DATE_TO: Effective Date.
If none of the above mentioned parameters are entered, the query retrieves all rows from the Oracle Applications database.
Database Scripts
This service uses the same database scripts as the Send Engineering BOM service.
Note:
If you use this service but you do not use the Send Engineering BOM service, you should run the wm_disable_from_engbom.sql script to disable the triggers installed by the Send Engineering BOM service.
For a detailed description of these database scripts, see
Send Engineering BOM Service. For more information about using database scripts, see
Database Scripts.
Supporting Transaction Definitions
This service uses the following transaction definition:
queryEngineeringBOMTxn1227.txp
For information about using the transaction definition files to customize this service, see
Transaction Definitions.
Flow Control
You can query Engineering Bills of Material data using the following services:
specifyDefaultSettings specifies the default parameter settings required for service execution. You should change these settings accordingly.
queryEngineeringBOMTxn queries the Oracle Applications database for any Engineering BOM 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
The Query Engineering BOM service uses the same business document structure as the Send Engineering BOM service. For a detailed description of the business document’s structure, see
Send Engineering BOM Service.