[Home] [Help]
View: CLN_ITEMMST_ITEMCATEGORY_V
Product: | CLN - Supply Chain Trading Connector for RosettaNet |
Description: | View of the available item categories |
Implementation/DBA Data: |
APPS.CLN_ITEMMST_ITEMCATEGORY_V
|
View Text
SELECT MIC.INVENTORY_ITEM_ID
, MIC.ORGANIZATION_ID
, MCSVC.CATEGORY_ID
, MCSVC.CATEGORY_SET_ID
, MCB.CONCATENATED_SEGMENTS CATEGORY_NAME
, MCT.DESCRIPTION CATEGORY_DESCRIPTION
, MCST.CATEGORY_SET_NAME
FROM MTL_ITEM_CATEGORIES MIC
, MTL_CATEGORY_SET_VALID_CATS MCSVC
, MTL_CATEGORIES_B_KFV MCB
, MTL_CATEGORIES_TL MCT
, MTL_CATEGORY_SETS_B MCSB
, MTL_CATEGORY_SETS_TL MCST
WHERE MCSVC.CATEGORY_ID = MIC.CATEGORY_ID
AND MCSVC.CATEGORY_SET_ID = MIC.CATEGORY_SET_ID
AND MCSVC.CATEGORY_ID = MCB.CATEGORY_ID
AND MCSVC.CATEGORY_SET_ID = MCSB.CATEGORY_SET_ID
AND MCB.CATEGORY_ID = MCT.CATEGORY_ID
AND MCSB.CATEGORY_SET_ID = MCST.CATEGORY_SET_ID
AND MCST.LANGUAGE = USERENV('LANG')
AND MCT.LANGUAGE = USERENV('LANG')
Columns
Name |
INVENTORY_ITEM_ID |
ORGANIZATION_ID |
CATEGORY_ID |
CATEGORY_SET_ID |
CATEGORY_NAME |
CATEGORY_DESCRIPTION |
CATEGORY_SET_NAME |