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 Item Category Service
 
Query Item Category Service
This service is in the WmOAMFG1227 package and has the following fully-qualified service name: inventory1227.queryOA.itemCategory:queryItemCategory.
This service queries item category information, based on the following parameters:
*CATEGORY_NAME: Category name.
*STRUCTURE_NAME: Category set name.
*INACTIVE_DATE_FROM: Beginning inactive date.
*INACTIVE_DATE_TO: Ending inactive date.
Database Scripts
This service uses the following database scripts:
Script
Description
wm_install_from_itemcategory.sql
Runs the scripts listed below, except the uninstall script.
wm_from_itemcategory_vw.sql
Creates the following required view component: WM_INV_ITEM_CATEGORY_QRY_VW
wm_drop_from_itemcategory.sql
Uninstalls all components created by wm_install_from_itemcategory.sql.
For more information about using database scripts, see Database Scripts.
Supporting Transaction Definitions
This service uses the following transaction definition:
*queryItemCategoryTxn1227.txp
For information about using the transaction definition files to customize this service, see Transaction Definitions.
Flow Control
The main flow queryItemCategory executes as follows. If no input parameters are specified, the query returns all rows.
*specifyDefaultSettings specifies the default parameter settings required for service execution. You should change these settings accordingly.
*queryItemCategoryTxn queries the Oracle Applications database for any Item Category records matching the parameter values. The parameters are defined as the input to this service. This service takes four inputs: CATEGORY_NAME, STRUCTURE_NAME, INACTIVE_DATE_FROM, and INACTIVE_DATE_TO.
For more details on query transactions, see Using Query Services.
Business Document Structure
This service uses the following business document structure:
*ITEM_CATEGORY
ITEM_CATEGORY
Document Field
Oracle Applications Table/View Name
Column Name
Description
WEB_
TRANSACTION_
ID
Not used
Not used for query outbound transactions.
DOCUMENT_
TYPE
Use ITEMCATEGORY.
DOCUMENT_
STATUS
Use QUERY.
CATEGORY
MTL_
CATEGORIES_
V
CATEGORY_
CONCAT_SEGS
Segmented Category Name.
STRUCTURE
MTL_
CATEGORIES_
V
STRUCTURE
Category set name.
INACTIVE_
ON_DATE
MTL_
CATEGORIES_
V
DISABLE_DATE
SUMMARY_FLAG
MTL_
CATEGORIES_
V
SUMMARY_FLAG
ENABLED_FLAG
MTL_
CATEGORIES_
V
ENABLED_FLAG
CATEGORY_
DESCRIPTION
MTL_
CATEGORIES_
V
DESCRIPTION
SUPPLIER_
ENABLED_FLAG
MTL_
CATEGORIES_
V
SUPPLIER_
ENABLED_FLAG
Viewable by supplier.
WEB_STATUS
MTL_
CATEGORIES_
V
WEB_STATUS
Enabled for iProcurement.