Product: | ENG - Engineering |
---|---|
Description: | This view holds product family information |
Implementation/DBA Data: | Not implemented in this database |
SELECT CATS.CATEGORY_ID ||'-'||INST.INSTANCE_CODE
, INST.INSTANCE_CODE
, 'ALL'
, SUBSTR(CATS.CONCATENATED_SEGMENTS
, 1
, 240)
, SUBSTR(CATS.CONCATENATED_SEGMENTS
, 1
, 80)
, SUBSTR(CATS.CONCATENATED_SEGMENTS
, 1
, 240)
, CATS.DESCRIPTION
, CATS.CREATION_DATE
, CATS.LAST_UPDATE_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM MTL_CATEGORIES_KFV CATS
, MTL_CATEGORY_SETS SETS
, EDW_LOCAL_INSTANCE INST
WHERE CATS.STRUCTURE_ID = SETS.STRUCTURE_ID
AND SETS.CATEGORY_SET_NAME = 'PRODUCT FAMILY' WITH READ ONLY