VIEW: APPS.CLN_ITEMMST_ITEMCATEGORY_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')