Query BOM Revision Service

Oracle Apps Adapter 6.0 | webMethods Oracle Applications Adapter Documentation | webMethods Oracle Applications Adapter 12.2.7 Predefined Transaction Services Documentation | Manufacturing Predefined Transaction Services | Query BOM Revision Service

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

This service retrieves Bills of Material revisions from Oracle Manufacturing, based on the following parameters:

ORGANIZATION_NAME: Name of the organization.

ITEM: Item number.

REVISION: Revision of the parent item.

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.

Database Scripts

This service uses the following database scripts:

Script	Description
wm_install_from_bomrevision.sql	Runs the scripts listed below, except the uninstall script.
wm_from_bomrevision_vw.sql	Creates the following required view component for BOM revision transactions: WM_BOM_REVISIONS_QRY_VW
wm_drop_from_bomrevision.sql	Uninstalls all components created by wm_install_from_bomrevision.sql.

For more information about using database scripts, see Database Scripts.

Supporting Transaction Definitions

This service uses the following transaction definition:

queryBOMRevisionTxn1227.txp

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

Flow Control

You can query BOMRevision data using the following services:

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

queryBOMRevisionTxn queries the Oracle Applications database for any BOMRevision Transaction to be processed. The number of records returned depends on the parameter value specified.

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

Business Document Structure

This service uses the following business document structure:

BOM_REVISIONS

Document Field	Oracle Applications Table/View Name	Column Name	Description
ITEM	MTL_SYSTEM_ ITEMS_B_KFV	CONCATENATED_ SEGMENTS	Concatenated flexfield segment constituting the item number.
INV_ORG_NAME	HR_ALL_ ORG ANIZATION_UNITS	NAME	Organization name.
REVISION	MTL_ITEM_ REVISIONS	REVISION	Item revision code.
CHANGE_ NOTICE	MTL_ITEM_ REVISIONS	CHANGE_NOTICE	Engineering change order number.
ECN_ INITIATION_ DATE	MTL_ITEM_ REVISIONS	ECN_INITIATION_ DATE	Engineering Change initiation date.
IMPLEMENTATION_ DATE	MTL_ITEM_ REVISIONS	IMPLEMENTATION_ DATE	Engineering Change implementation date.
EFFECTIVITY_ DATE	MTL_ITEM_ REVISIONS	EFFECTIVITY_ DATE	Revision effective date.
REVISION_LABEL	MTL_ITEM_ REVISIONS	REVISION_ LABEL	Revision label.
REVISION_ REASON	MTL_ITEM_ REVISIONS	REVISION_ REASON	Revision reason.