Query Pick Detail Service

This service is in the WmOAOMG1227 package and has the following fully-qualified service name: shipping1227.queryOA.pickDetail:queryPickDetail

This service queries for information about the inventory transfer when the item moves from one location to another. Use the Query Pick Detail service to retrieve the pick details based on the following parameters:

PICKING_RULE_NAME: The rule used by Pick Wave Move orders to locate the material required to fulfill the move order line

MOVE_ORDER_NUMBER: The order number assigned when the order is created.

MOVE_ORDER_TYPE_NAME: The Move order source type such as Requisitions, Replenishment, and Pick Wave.

FROM_ORGANIZATION_NAME: The organization from which the picking was executed.

This service uses the same database script as the Send Pick Detail service.

Note:
If you use this service but you do not use the Send Pick Detail service, you should run the wm_disable_from_pickdetails.sql script to disable the triggers installed by the Send Pick Detail service.

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

This service uses the following transaction definitions:

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

The main flow executes as follows:

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

queryPickDetailTxn queries the Oracle Applications database for any Pick Detail information matching the parameter values. The parameters are defined as the input to this service.

For more details on query services, see Using Query Services.

This service uses the same business document structure as the Send Pick Detail service. For a detailed description of the business document structure, see Send Pick Detail Service.