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_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
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. |