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