[Home] [Help]
View: GMI_ITEM_CATEGORIES_V1
Product: | GMI - Process Manufacturing Inventory |
Description: | View for OPM Item Master support for Eres catsets |
Implementation/DBA Data: |
APPS.GMI_ITEM_CATEGORIES_V1
|
View Text
SELECT GIC.ITEM_ID
, GIC.CATEGORY_ID
, GIC.CATEGORY_SET_ID
, MCSV.STRUCTURE_ID
, MCSV.CATEGORY_SET_NAME
FROM GMI_ITEM_CATEGORIES GIC
, MTL_CATEGORY_SETS_VL MCSV
WHERE GIC.CATEGORY_SET_ID = MCSV.CATEGORY_SET_ID
Columns
Name |
ITEM_ID |
CATEGORY_ID |
CATEGORY_SET_ID |
STRUCTURE_ID |
CATEGORY_SET_NAME |