[Home] [Help]
View: ICX_RELATED_CATEGORIES_VAL_V
View Text
SELECT IRC.CATEGORY_SET_ID
, IRC.CATEGORY_ID
, IRC.RELATED_CATEGORY_ID
, MC.CONCATENATED_SEGMENTS
, MC.DESCRIPTION
, IRC.RELATIONSHIP_TYPE
FROM MTL_CATEGORIES_KFV MC
, ICX_RELATED_CATEGORIES IRC
WHERE MC.CATEGORY_ID = IRC.RELATED_CATEGORY_ID
AND NVL(START_DATE_ACTIVE
, SYSDATE-1) <= SYSDATE
AND NVL(END_DATE_ACTIVE
, SYSDATE+1)> SYSDATE
Columns
Name |
CATEGORY_SET_ID |
CATEGORY_ID |
RELATED_CATEGORY_ID |
RELATED_CATEGORY_NAME |
RELATED_CATEGORY_DESCRIPTION |
RELATIONSHIP_TYPE |