[Home] [Help]
View: EDWBV_ITEM_ITEM_CAT_LCV
Product: | ENG - Engineering |
Description: | This view includes item category association |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT '_KF:INV:MCAT:MTC'
, MTC.CATEGORY_ID||'-'||INST.INSTANCE_CODE
, INST.INSTANCE_CODE
, 'ALL'
, SUBSTR(MTC.CONCATENATED_SEGMENTS
, 1
, 240)
, SUBSTR(MTC.CONCATENATED_SEGMENTS
, 1
, 80)
, MTC.DESCRIPTION
, MTS.CATEGORY_SET_NAME
, FUNCTIONAL_AREA_ID
, MTC.CATEGORY_ID
, MTC.CREATION_DATE
, GREATEST(MTC.LAST_UPDATE_DATE
, MTS.LAST_UPDATE_DATE
, MTD.LAST_UPDATE_DATE)
, NULL
, '_DF:INV:MTL_CATEGORIES:MTC'
FROM MTL_CATEGORIES_KFV MTC
, MTL_CATEGORY_SETS MTS
, MTL_DEFAULT_CATEGORY_SETS MTD
, EDW_LOCAL_INSTANCE INST
WHERE MTC.STRUCTURE_ID = MTS.STRUCTURE_ID
AND MTS.CATEGORY_SET_ID = MTD.CATEGORY_SET_ID
AND MTS.CONTROL_LEVEL = 1
AND MTD.FUNCTIONAL_AREA_ID IN (1
, 2
, 3
, 4
, 5
, 6
, 7
, 8
, 9) WITH READ ONLY
Columns
Name |
"_KF:MCAT:_EDW" |
CATEGORY_PK |
INSTANCE |
ALL_FK |
CATEGORY_DP |
NAME |
DESCRIPTION |
CATEGORY_SET_NAME |
FUNCTIONAL_AREA_ID |
CATEGORY_ID |
CREATION_DATE |
LAST_UPDATE_DATE |
OPERATION_CODE |
"DF:CAT:_EDW" |