[Home] [Help]
View: ICX_RELATED_CATEGORIES_V
View Text
SELECT IRC.CATEGORY_SET_ID
, IRC.CATEGORY_ID
, MC.CONCATENATED_SEGMENTS
, MC.DESCRIPTION
, IRC.RELATED_CATEGORY_ID
, MC2.CONCATENATED_SEGMENTS
, MC2.DESCRIPTION
, IRC.RELATIONSHIP_TYPE
FROM MTL_CATEGORIES_KFV MC
, MTL_CATEGORIES_KFV MC2
, ICX_RELATED_CATEGORIES IRC
WHERE MC.CATEGORY_ID = IRC.CATEGORY_ID
AND MC2.CATEGORY_ID = IRC.RELATED_CATEGORY_ID
Columns
Name |
CATEGORY_SET_ID |
CATEGORY_ID |
CATEGORY_NAME |
CATEGORY_DESCRIPTION |
RELATED_CATEGORY_ID |
RELATED_CATEGORY_NAME |
RELATED_CATEGORY_DESCRIPTION |
RELATIONSHIP_TYPE |