Query Manufacturing BOM Service

This service is in the WmOAMFG1227 package and has the following fully-qualified service name: billsOfMaterial1227.queryOA.manufacturingBOM:queryManufacturingBOM.

This service retrieves information on parent, component, and substitute Manufacturing Bills of Material items, as well as revisions. It retrieves this information based on the following parameters:

EFFECTIVITY_DATE_FROM: Beginning effective date.

EFFECTIVITY_DATE_TO: Ending effective date.

If none of the above mentioned parameters are entered, the query retrieves all rows from the Oracle Applications database.

This service uses the same database scripts as the Send Manufacturing BOM service.

Note:
If you use this service but you do not use the Send Manufacturing BOM service, you should run the wm_disable_from_mfgbom.sql script to disable the triggers installed by the Send Manufacturing BOM service.

For a detailed description of these database scripts, see Send Manufacturing BOM. For more information about using database scripts, see Database Scripts.

This service uses the following transaction definition:

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

The main flow queryManufacturingBOM executes as follows:

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

queryManufacturingBOMTxn queries the Oracle Applications database for any Manufacturing 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.

This service uses the same business document structure as the Send Manufacturing BOM service. For a detailed description of the business document’s structure, see Send Manufacturing BOM Service.