Product: | CSS - Support (obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT HRCHY.PROD_CAT_HRCHY_ID
, HRCHY.CATEGORY_ID
, SUB.CONCATENATED_SEGMENTS CATEGORY_NAME
, HRCHY.PARENT_CATEGORY_ID
, PARENT.CONCATENATED_SEGMENTS PARENT_CATEGORY_NAME
, HRCHY.START_DATE_ACTIVE
, HRCHY.END_DATE_ACTIVE
, HRCHY.CREATED_BY
, HRCHY.CREATION_DATE
, HRCHY.LAST_UPDATED_BY
, HRCHY.LAST_UPDATE_DATE
, HRCHY.LAST_UPDATE_LOGIN
, HRCHY.ATTRIBUTE1
, HRCHY.ATTRIBUTE2
, HRCHY.ATTRIBUTE3
, HRCHY.ATTRIBUTE4
, HRCHY.ATTRIBUTE5
, HRCHY.ATTRIBUTE6
, HRCHY.ATTRIBUTE7
, HRCHY.ATTRIBUTE8
, HRCHY.ATTRIBUTE9
, HRCHY.ATTRIBUTE10
, HRCHY.ATTRIBUTE11
, HRCHY.ATTRIBUTE12
, HRCHY.ATTRIBUTE13
, HRCHY.ATTRIBUTE14
, HRCHY.ATTRIBUTE15
, HRCHY.CONTEXT
FROM CSS_DEF_PROD_CAT_HRCHY HRCHY
, MTL_CATEGORIES_KFV SUB
, MTL_CATEGORIES_KFV PARENT
WHERE HRCHY.CATEGORY_ID = SUB.CATEGORY_ID
AND HRCHY.PARENT_CATEGORY_ID = PARENT.CATEGORY_ID (+)